Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: kettle pdi-ce-8.1.0.0-365 error on rename Excel Input Step in transformation

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Sep 2006
    Posts
    17

    Default kettle pdi-ce-8.1.0.0-365 error on rename Excel Input Step in transformation

    Hello all,

    hope you can help me today.

    Environment: Windows 10(64 bit)
    java version "1.8.0_191"

    What I did stepwise:

    • Load pdi-ce-8.1.0.0_356.zip
    • unpack zip
    • go to folder /data-integration
    • create a simple *.xls Excel file test.xls
    • double klick SpoonConsole.bat
    • Select file --> new --> transformation
    • Select design --> input --> Microsoft Excel Input Step
    • Tab = "Files" --> Select in Step --> Browse --> test.xls --> Add the file
    • Tab = "Sheet" --> Select sheet --> select Table1 sheet
    • Tab = "Fields" --> Select "Get fields from header row..." --> ok --> in this tab select "preview rows" --> ok
    • Save the transformation as file *.ktr --> ok
    • Run the transformation --> ok
    • Select the "Microsoft Excel Input" Step again for editing the Step name --> press OK the attached Error Message occurs: "Unable to open dialog for this step"

    It would very nice if you can help me. Do I have to install some thing else?
    With pdi-ce-7.1.0.0_12 all works fine.

    Thank you in advance

    T.


    Please find attached the error log message
    ------------------------------------------------------------
    Creating configuration from pentaho.marketplace.di.cfg
    Nov 28, 2018 6:39:22 PM org.apache.cxf.endpoint.ServerImpl initDestination
    INFORMATION: Setting the server's publish address to be /marketplace
    Nov 28, 2018 6:40:11 PM org.apache.cxf.endpoint.ServerImpl initDestination
    INFORMATION: Setting the server's publish address to be /repositories
    Nov 28, 2018 6:40:27 PM org.apache.cxf.endpoint.ServerImpl initDestination
    INFORMATION: Setting the server's publish address to be /browser
    2018/11/28 18:40:41 - Carte - Installing timer to purge stale objects after 1440 minutes.
    2018/11/28 18:48:35 - /Transformation 1 - Dispatching started for transformation [/Transformation 1]
    2018/11/28 18:48:36 - Microsoft Excel Input.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
    2018/11/28 18:48:36 - dummy.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2018/11/28 18:48:43 - Spoon - Save as...
    2018/11/28 18:48:43 - Spoon - Save file as...
    2018/11/28 18:48:58 - Spoon - Using legacy execution engine
    2018/11/28 18:48:58 - Spoon - Transformation opened.
    2018/11/28 18:48:58 - Spoon - Launching transformation [test_excel_input]...
    2018/11/28 18:48:58 - Spoon - Started the transformation execution.
    2018/11/28 18:48:59 - test_excel_input - Dispatching started for transformation [test_excel_input]
    2018/11/28 18:49:00 - Microsoft Excel Input.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
    2018/11/28 18:49:00 - Spoon - The transformation has finished!!
    java.lang.NullPointerException
    at org.pentaho.di.trans.TransMeta.getStepMetaCacheKey(TransMeta.java:6405)
    at org.pentaho.di.trans.TransMeta.findPreviousSteps(TransMeta.java:1384)
    at org.pentaho.di.trans.TransMeta.findPreviousSteps(TransMeta.java:1371)
    at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.getInfo(ExcelInputDialog.java:1493)
    at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.ok(ExcelInputDialog.java:1468)
    at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.access$600(ExcelInputDialog.java:102)
    at org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog$7.handleEvent(ExcelInputDialog.java:1028)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.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.trans.steps.excelinput.ExcelInputDialog.open(ExcelInputDialog.java:1214)
    at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:120)
    at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8949)
    at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3291)
    at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:785)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.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:1375)
    at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:8104)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9466)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:701)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
    Last edited by athor; 11-29-2018 at 02:00 PM.

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.