Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Random error with Kitchen

  1. #1
    Join Date
    Mar 2007
    Posts
    16

    Default Random error with Kitchen

    Hi,
    I have a job that sometimes fails to run with the error message below.
    It's not easily reproducible, for instance on the last 20 runs (1 every 15 minutes): 13 executions OK, 7 with this error.
    I checked the database log and statistics, did not see anything relevant.

    My config: PDI 2.4.1-M1 running on an HP-UX 11.23 Itanium2 box, with Oracle 10GR2 and Java 1.4.

    Thanks for any help, and many thanks for this great product!
    Regards,
    Régis


    10:16:12,195 INFO [J_Charger_Un_Fichier_IQ] J_Charger_Un_Fichier_IQ - Starting entry [T_Chargement_IQ]
    10:16:12,195 INFO [T_Chargement_IQ] T_Chargement_IQ - Opening filename : [null]
    10:16:12,196 INFO [T_Chargement_IQ] T_Chargement_IQ - Opening transformation: [T_Chargement_IQ] in directory [/Data_loading/Ineoquest]
    10:16:12,196 INFO [T_Chargement_IQ] T_Chargement_IQ - Loading transformation from repository [T_Chargement_IQ] in directory [/Data_loading/Ineoquest]
    10:16:12,781 ERROR [T_Chargement_IQ] T_Chargement_IQ - PDI a rencontrÕ une erreur de la base de donnÕes durant la lecture d'une transformation depuis le rÕfÕrentiel
    java.lang.ClassNotFoundException: org.eclipse.core.runtime.IProgressMonitor
    10:16:12,784 ERROR [Thread[J_Charger_Un_Fichier_IQ (J_Charger_Un_Fichier_IQ (Thread-56)),5,main]] Thread[J_Charger_Un_Fichier_IQ (J_Charger_Un_Fichier_IQ (Thread-56)),5,m
    ain] - be.ibridge.kettle.core.exception.KettleException:
    PDI a rencontrÕ une erreur durant la lecture d'une transformation depuis le rÕfÕrentiel
    org.eclipse.core.runtime.IProgressMonitor
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2267)
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2071)
    at be.ibridge.kettle.job.entry.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:712)
    at be.ibridge.kettle.job.entry.trans.JobEntryTrans.execute(JobEntryTrans.java:406)
    at be.ibridge.kettle.job.Job.execute(Job.java:303)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:265)
    at be.ibridge.kettle.job.entry.job.JobEntryJobRunner.run(JobEntryJobRunner.java:70)
    at java.lang.Thread.run(Thread.java:534)
    Caused by: java.lang.ClassNotFoundException: org.eclipse.core.runtime.IProgressMonitor
    at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
    at java.lang.String.<init>(String.java:527)
    at java.lang.StringBuffer.toString(StringBuffer.java:1376)
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2168)
    ... 9 more
    10:16:12,792 ERROR [Thread[J_Charger_Un_Fichier_IQ (J_Charger_Un_Fichier_IQ (Thread-56)),5,main]] Thread[J_Charger_Un_Fichier_IQ (J_Charger_Un_Fichier_IQ (Thread-56)),5,m
    ain] - be.ibridge.kettle.core.exception.KettleException:
    Unexpected error occurred while launching entry [T_Chargement_IQ.0]
    PDI a rencontrÕ une erreur durant la lecture d'une transformation depuis le rÕfÕrentiel
    org.eclipse.core.runtime.IProgressMonitor

    at be.ibridge.kettle.job.Job.execute(Job.java:365)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:265)
    at be.ibridge.kettle.job.entry.job.JobEntryJobRunner.run(JobEntryJobRunner.java:70)
    at java.lang.Thread.run(Thread.java:534)
    Caused by: be.ibridge.kettle.core.exception.KettleException:
    PDI a rencontrÕ une erreur durant la lecture d'une transformation depuis le rÕfÕrentiel
    org.eclipse.core.runtime.IProgressMonitor
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2267)
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2071)
    at be.ibridge.kettle.job.entry.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:712)
    at be.ibridge.kettle.job.entry.trans.JobEntryTrans.execute(JobEntryTrans.java:406)
    at be.ibridge.kettle.job.Job.execute(Job.java:303)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    ... 4 more
    Caused by: java.lang.ClassNotFoundException: org.eclipse.core.runtime.IProgressMonitor
    at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
    at java.lang.String.<init>(String.java:527)
    at java.lang.StringBuffer.toString(StringBuffer.java:1376)
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2168)
    ... 9 more
    10:16:12,819 ERROR [JobEntryJobRunner@1049d3] be.ibridge.kettle.job.entry.job.JobEntryJobRunner@1049d3 - An error occurred executing this job entry :
    Unexpected error occurred while launching entry [T_Definir_variable_FILENAME_IQ.0]
    Unexpected error occurred while launching entry [T_Chargement_IQ.0]
    PDI a rencontrÕ une erreur durant la lecture d'une transformation depuis le rÕfÕrentiel
    org.eclipse.core.runtime.IProgressMonitor

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Bonjour Régis,

    You are working with an old development release.
    Why don't you give version 2.5.0RC1 a try? Or you can wait another week or so for 2.5.0GA.

    Matt

  3. #3
    Join Date
    Mar 2007
    Posts
    16

    Default

    Hi Matt,
    I just upgraded to 2.5.0RC1, and now I have a new blocking issue: the Dimension lookup/update steps don't work anymore. It looks like the technical key field is not added to the stream.

    Here is an example log:
    2007/04/16 15:01:05 - Insertion / MAJ WBDATA Mapping.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : Couldn't find field 'ID' in row!

    I attached the simplified transformation and a sample input file.

    Thanks,
    Attached Files Attached Files

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    You are absolutely right. I'm very glad you found this bug as it failed to show during tests.

    Download a new kettle.jar to update your RC1 install (replace lib/kettle.jar) and try again.

    Thanks,

    Matt

  5. #5
    Join Date
    Mar 2007
    Posts
    16

    Thumbs up Dimension issue solved

    Matt,
    the issue with the Dimension Lookup/update step is now solved. I still need to test my initial problem, but I start thinking it could be due to an Oracle misconfiguration, as it only happens from time to time (I generally don't like that kind of unreproductible bugs ...). However I don't see any Oracle error in the logs.
    I will let you know how it goes.

    Thanks,

  6. #6
    Join Date
    Mar 2007
    Posts
    16

    Default

    Hi Matt,
    I think that my problem is related to the JDK version.
    Infact, with JDK 1.4, I get the same error message (org.eclipse.core.runtime.IProgressMonitor) when exporting the repository with Pan, either with PDI 2.4.x or PDI 2.5.x.
    With JDK 1.5, I don't get any errors.
    Thanks,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.