Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Kettle Error loading Tranformation

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

    Default Kettle Error loading Tranformation

    (Folks, please use "Plain" format when posting around stack traces...)

    Hello all,

    I am using kettle for two weeks now to do some basic ETL on see what is can bring us. It's a great product but has some nasty bugs. I had created a transformation with a Join Rows step in it, works fine. So today i changed the transformation and after saving it, I am unable to open the transformation again.

    So i rebuild the transformation from scratch, and guess what the same problem, unable to open the tranformation with the following error fragment (If you need the full errorstack output, i can post it here.)

    I exported the transformation to xml and importing it work. If i then drop the "Join rows" step, and save and open the transformation everything is. If i create a tranformation with a Join Rows step it fails to open it corectly

    Is it possible that my repository is corrupt ?

    Regards Rob Sessink

    ----
    An error occured reading a transformation from the repository

    Unexpected error reading step information from the repository
    at be.ibridge.kettle.spoon.Spoon.main (Spoon.java:4486)
    at be.ibridge.kettle.spoon.Spoon.readAndDispatch (Spoon.java:472)
    at org.eclipse.swt.widgets.Display.readAndDispatch (Display.java:2713)
    at org.eclipse.swt.widgets.Display.runDeferredEvents (Display.java:3080)
    at org.eclipse.swt.widgets.Widget.sendEvent (Widget.java:843)
    at org.eclipse.swt.widgets.EventTable.sendEvent (EventTable.java:66)
    at be.ibridge.kettle.spoon.Spoon$4.handleEvent (Spoon.java:564)
    at be.ibridge.kettle.spoon.Spoon.openFile (Spoon.java:2362)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog.open (TransLoadProgressDialog.java:70)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run (ProgressMonitorDialog.java:447)
    at org.eclipse.jface.operation.ModalContext.run (ModalContext.java:291)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread (ModalContext.java:346)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog$1.run (TransLoadProgressDialog.java:58)
    at be.ibridge.kettle.trans.TransMeta.<init> (TransMeta.java:1784)
    at be.ibridge.kettle.trans.step.StepMeta.<init> (StepMeta.java:419)
    at be.ibridge.kettle.trans.step.joinrows.JoinRowsMeta.readRep (JoinRowsMeta.java:257)
    at be.ibridge.kettle.core.Condition.<init> (Condition.java:728)

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

    Default RE: Kettle Error loading Tranformation

    Hey Rob,

    Could you post the complete stack trace?
    I&#39;m sure it is something we can repair...

    Thanks,

    Matt

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

    Default RE: Kettle Error loading Tranformation

    And Rob, while you&#39;re at it, please tell us about the other nasty bugs as well. That way we can fix those as well.
    Also, please be so kind to tell us on what version (Spoon, OS, JRE) you are running.

    I&#39;m also sure that you know, but I&#39;ll mention this again for the other readers: it IS possible to add bug reports on this very site by using the Trackers tab.

    Thanks a lot!
    Matt

  4. #4
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Kettle Error loading Tranformation

    I just exported all my transformations and recreated a new repository. I also imported the conflicting transformation and the importing/saving/opening now works again. I also exported 2 Jobs, but In "Chef" there is no option to import them again, is there another way to do this ?

    Regards Rob Sessink


    Here is the trace

    An error occured reading a transformation from the repository

    Unexpected error reading step information from the repository
    at be.ibridge.kettle.spoon.Spoon.main (Spoon.java:4486)
    at be.ibridge.kettle.spoon.Spoon.readAndDispatch (Spoon.java:472)
    at org.eclipse.swt.widgets.Display.readAndDispatch (Display.java:2713)
    at org.eclipse.swt.widgets.Display.runDeferredEvents (Display.java:3080)
    at org.eclipse.swt.widgets.Widget.sendEvent (Widget.java:843)
    at org.eclipse.swt.widgets.EventTable.sendEvent (EventTable.java:66)
    at be.ibridge.kettle.spoon.Spoon$4.handleEvent (Spoon.java:564)
    at be.ibridge.kettle.spoon.Spoon.openFile (Spoon.java:2362)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog.open (TransLoadProgressDialog.java:70)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run (ProgressMonitorDialog.java:447)
    at org.eclipse.jface.operation.ModalContext.run (ModalContext.java:291)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread (ModalContext.java:346)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog$1.run (TransLoadProgressDialog.java:58)
    at be.ibridge.kettle.trans.TransMeta.<init> (TransMeta.java:1784)
    at be.ibridge.kettle.trans.step.StepMeta.<init> (StepMeta.java:419)
    at be.ibridge.kettle.trans.step.joinrows.JoinRowsMeta.readRep (JoinRowsMeta.java:257)
    at be.ibridge.kettle.core.Condition.<init> (Condition.java:728)



    java.lang.reflect.InvocationTargetException: Error loading transformation
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:62)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346)
    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:447)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:70)
    at be.ibridge.kettle.spoon.Spoon.openFile(Spoon.java:2362)
    at be.ibridge.kettle.spoon.Spoon$4.handleEvent(Spoon.java:564)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
    at be.ibridge.kettle.spoon.Spoon.readAndDispatch(Spoon.java:472)
    at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:4486)
    Caused by: be.ibridge.kettle.core.exception.KettleException:
    An error occured reading a transformation from the repository

    Unexpected error reading step information from the repository
    at be.ibridge.kettle.spoon.Spoon.main (Spoon.java:4486)
    at be.ibridge.kettle.spoon.Spoon.readAndDispatch (Spoon.java:472)
    at org.eclipse.swt.widgets.Display.readAndDispatch (Display.java:2713)
    at org.eclipse.swt.widgets.Display.runDeferredEvents (Display.java:3080)
    at org.eclipse.swt.widgets.Widget.sendEvent (Widget.java:843)
    at org.eclipse.swt.widgets.EventTable.sendEvent (EventTable.java:66)
    at be.ibridge.kettle.spoon.Spoon$4.handleEvent (Spoon.java:564)
    at be.ibridge.kettle.spoon.Spoon.openFile (Spoon.java:2362)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog.open (TransLoadProgressDialog.java:70)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run (ProgressMonitorDialog.java:447)
    at org.eclipse.jface.operation.ModalContext.run (ModalContext.java:291)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread (ModalContext.java:346)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog$1.run (TransLoadProgressDialog.java:58)
    at be.ibridge.kettle.trans.TransMeta.<init> (TransMeta.java:1784)
    at be.ibridge.kettle.trans.step.StepMeta.<init> (StepMeta.java:419)
    at be.ibridge.kettle.trans.step.joinrows.JoinRowsMeta.readRep (JoinRowsMeta.java:257)
    at be.ibridge.kettle.core.Condition.<init> (Condition.java:728)


    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:1842)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:58)
    ... 12 more
    Caused by: be.ibridge.kettle.core.exception.KettleException:
    Unexpected error reading step information from the repository
    at be.ibridge.kettle.spoon.Spoon.main (Spoon.java:4486)
    at be.ibridge.kettle.spoon.Spoon.readAndDispatch (Spoon.java:472)
    at org.eclipse.swt.widgets.Display.readAndDispatch (Display.java:2713)
    at org.eclipse.swt.widgets.Display.runDeferredEvents (Display.java:3080)
    at org.eclipse.swt.widgets.Widget.sendEvent (Widget.java:843)
    at org.eclipse.swt.widgets.EventTable.sendEvent (EventTable.java:66)
    at be.ibridge.kettle.spoon.Spoon$4.handleEvent (Spoon.java:564)
    at be.ibridge.kettle.spoon.Spoon.openFile (Spoon.java:2362)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog.open (TransLoadProgressDialog.java:70)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run (ProgressMonitorDialog.java:447)
    at org.eclipse.jface.operation.ModalContext.run (ModalContext.java:291)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread (ModalContext.java:346)
    at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog$1.run (TransLoadProgressDialog.java:58)
    at be.ibridge.kettle.trans.TransMeta.<init> (TransMeta.java:1784)
    at be.ibridge.kettle.trans.step.StepMeta.<init> (StepMeta.java:419)
    at be.ibridge.kettle.trans.step.joinrows.JoinRowsMeta.readRep (JoinRowsMeta.java:257)
    at be.ibridge.kettle.core.Condition.<init> (Condition.java:728)

    at be.ibridge.kettle.trans.step.joinrows.JoinRowsMeta.readRep(JoinRowsMeta.java:266)
    at be.ibridge.kettle.trans.step.StepMeta.<init>(StepMeta.java:419)
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:1784)
    ... 13 more
    Caused by: java.lang.NullPointerException
    at be.ibridge.kettle.core.Condition.<init>(Condition.java:728)
    at be.ibridge.kettle.trans.step.joinrows.JoinRowsMeta.readRep(JoinRowsMeta.java:257)
    ... 15 more

  5. #5
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Kettle Error loading Tranformation

    I am using Kettle 2.2.2 on Windows 2000 JRE 1.5.0_06-b05

    and tried Kettle 2.2.2. on Suse 9.3 JRE 1.4.2_11-b06

    With the nasty bugs i meant that I frequently get lockups of Kettle under Linux when using the "File" --> "Open" menu item
    I will post my known bugs in the tracker

    greetz Rob

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

    Default RE: Kettle Error loading Tranformation

    FYI, I have the File/Open problem also in other applications besides Kettle.
    That is because Spoon actually uses a completely native Windows File dialog that has nothing to do with Java, Kettle or Spoon.


    My theory is that it is related to shared folders or the like. Don't really know actually.



    The obvious google search yields plenty of results, it's almost impossible to check them all.



    First google result



    All the best,



    Matt

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

    Default RE: Kettle Error loading Tranformation

    Looking at the stack trace I give it a +90% chance that this bug is already fixed in the latest development release.


    Perhaps you could give it a swing?



    Thanks,



    Matt

  8. #8
    Join Date
    Sep 2009
    Posts
    5

    Default

    I had a very similar problem in 3.2.0 - repository wouldn't open (repeated attempts) and gave error

    pentaho java.lang.reflect.InvocationTargetException: Error loading transformation

    I downloaded latest CI Build (3.2.2) and repo opened successfully. I then went back to 3.2.0 and it opened successfully too.

    I don't have the full stack trace anymore (Sorry!) - but if I see it again I'll post a Jira if you like.

    Steve

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.