PDA

View Full Version : Kettle Error loading Tranformation



MattCasters
04-20-2006, 03:21 AM
(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)

MattCasters
04-20-2006, 03:23 AM
Hey Rob,

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

Thanks,

Matt

MattCasters
04-20-2006, 03:43 AM
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

kettle_anonymous
04-20-2006, 03:46 AM
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

kettle_anonymous
04-20-2006, 03:57 AM
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

MattCasters
04-20-2006, 04:06 AM
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 (http://www.jsifaq.com/SUBG/TIP3200/rh3244.htm)



All the best,



Matt

MattCasters
04-20-2006, 04:07 AM
Looking at the stack trace I give it a +90% chance that this bug is already fixed in the latest development release (http://www.javaforge.com/proj/doc/details.do?doc_id=3719).


Perhaps you could give it a swing?



Thanks,



Matt

spidie
09-20-2009, 06:12 PM
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