Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Can't open transformation with Spoon

  1. #1

    Default Can't open transformation with Spoon

    Hi, I have a transformation I created using spoon,
    I can open it using a text editor and see the .xml but I cannot open it in Spoon.
    I had an error saving the last change I made to it from spoon, now I can't open it.
    Is there something I could do to the .xml to get spoon to open it again ?

    Thanks

  2. #2
    Join Date
    Mar 2008
    Posts
    140

    Default

    Can you paste the error you are getting? (If you need to edit the spoon.bat file and change javaw to java. This will give you a console)

  3. #3

    Default

    Quote Originally Posted by cboyden View Post
    Can you paste the error you are getting? (If you need to edit the spoon.bat file and change javaw to java. This will give you a console)
    INFO 17-07 11:00:02,218 - Using "C:\DOCUME~1\rdmclure\LOCALS~1\Temp\vfs_cache" as temporary files store.
    INFO 17-07 11:00:02,953 - Spoon - Logging goes to file:///C:/DOCUME~1/rdmclure/LOCALS~...fe5e8b684e.log
    WARN 17-07 11:00:04,750 - could not parse [vertical] as Align value
    INFO 17-07 11:00:05,125 - Spoon - Asking for repository
    INFO 17-07 11:00:05,265 - SetElements on listbox called: collection has 1 rows
    Changed to: C:\unzip folder\pdi-ce-4.1.0-stable\data-integration\docs\English\welcome\kettle_document_map.html
    INFO 17-07 11:00:05,484 - Version checker - OK
    WARN 17-07 11:00:07,796 - could not parse [vertical] as Align value
    WARN 17-07 11:00:07,953 - Cannot overlay element with id [trans] as it does not exist in the target document.
    WARN 17-07 11:00:07,953 - Cannot overlay element with id [job] as it does not exist in the target document.
    ERROR 17-07 11:00:39,671 - Error invoking method: spoon.openFile()
    java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:135)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1161)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6725)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:545)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: java.lang.NullPointerException
    at org.pentaho.di.trans.TransMeta.loadXML(TransMeta.java:2535)
    at org.pentaho.di.ui.spoon.TransFileListener.open(TransFileListener.java:42)
    at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3806)
    at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3507)
    at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3462)
    ... 22 more
    ERROR 17-07 11:00:39,671 - Error calling oncommand event
    org.pentaho.ui.xul.XulException: Error invoking method: spoon.openFile()
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:333)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:135)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1161)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6725)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:545)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    ... 17 more
    Caused by: java.lang.NullPointerException
    at org.pentaho.di.trans.TransMeta.loadXML(TransMeta.java:2535)
    at org.pentaho.di.ui.spoon.TransFileListener.open(TransFileListener.java:42)
    at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3806)
    at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3507)
    at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3462)
    ... 22 more

  4. #4

    Default

    Quote Originally Posted by cboyden View Post
    Can you paste the error you are getting? (If you need to edit the spoon.bat file and change javaw to java. This will give you a console)
    I have attached the xml if that helps.
    Attached Files Attached Files

  5. #5
    Join Date
    Mar 2008
    Posts
    140

    Default

    EventConversion23APR2012versioning-fixed.ktr

    So there were some error handling hops at the end with a source, but no destination. I removed them and can now open the transformation.

    -- EDIT --
    Your transformation may be missing some error handling that seemed to be there before, please check the transformation before using it.
    -- END EDIT --

    </step_error_handling>
    <error>
    <source_step>DVS_IDVIN_HISTORY</source_step>
    <target_step/> <--- This should not be empty
    <is_enabled>Y</is_enabled>
    <nr_valuename/>
    <descriptions_valuename/>
    <fields_valuename/>
    <codes_valuename/>
    <max_errors/>
    <max_pct_errors/>
    <min_pct_rows/>
    </error>
    </step_error_handling>


    I have created a case to get this bug fixed: http://jira.pentaho.com/browse/PDI-8201
    Can you please annotate the case with a reproduction path of how you got the file into that state in the first place? We need to fix that as well, this never should have happened.

    If you can simplify the example for reproduction of the bad file, that would be awesome, that file is massive.

    Thank you!
    - Curtis

  6. #6

    Default

    Thank you so much!,
    I have other transformations that seem to work fine
    but they also have <target_step/> <--- empty

    so I don't think that is the exact problem, but something you deleted was causing the problem.
    Thanks again.

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.