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

  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.

  2. #2
    Join Date
    May 2016
    Posts
    258

    Default

    Try with Java 1.8, I don't think 1.9 is supported with any version right now.
    Regards
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

  3. #3
    Join Date
    Aug 2016
    Posts
    239

    Default

    Not backwards compatible?

  4. #4
    Join Date
    Sep 2006
    Posts
    17

    Default

    Hello All,

    I'm verry sorry I reported the wrong java version above on my first entry, I correct this. I use the following environment:
    java version "1.8.0_191"
    Java(TM) SE Runtime Environment (build 1.8.0_191-b12)
    Java HotSpot(TM) 64-Bit Server VM (build 25.191-b12, mixed mode)

    Sorry for by wrong issue description. So the issue occurs with the mentioned java version further.

    I appreciate your help very much

    Best regards

    T.

  5. #5
    Join Date
    Sep 2006
    Posts
    17

    Default

    Hello,

    I Test it also with Windows 8.1 and Java jdk1.8.0_131 Version please find attached the Stacktrace from the SpoonDebut.bat - Aplication.
    Please note, the transformation runs successful, but it is not possible to change the name of the Excel Input Step.

    [size=-3]
    DEBUG: Using JAVA_HOME
    DEBUG: _PENTAHO_JAVA_HOME=d:\Java\jdk1.8.0_131
    DEBUG: _PENTAHO_JAVA=d:\Java\jdk1.8.0_131\bin\java.exe

    D:\Programme\kettle\pdi-ce-8.1.0.0-365\data-integration>"d:\Java\jdk1.8.0_131\bin\java.exe" "-Xms1024m" "-Xmx2048m" "-XX:MaxPermSize=256m" "-Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2" "-Djava.library.path=libswt\win64" "-DKETTLE_HOME=D:\Programme\kettle\pdi-ce-8.1.0.0-365\data-integration" "-DKETTLE_REPOSITORY=" "-DKETTLE_USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\launcher.jar -lib ..\libswt\win64 /levelebug
    19:46:33,370 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
    19:46:37,485 INFO [KarafInstance]
    *******************************************************************************
    *** Karaf Instance Number: 1 at D:\Programme\kettle\pdi-ce-8.1.0.0-365\data ***
    *** -integration\.\system\karaf\caches\spoon\data-1 ***
    *** FastBin Provider Port:52901 ***
    *** Karaf Port:8802 ***
    *** OSGI Service Port:9051 ***
    *******************************************************************************
    Nov 29, 2018 7:46:38 PM org.apache.karaf.main.Main$KarafLockCallback lockAquired
    INFORMATION: Lock acquired. Setting startlevel to 100
    2018-11-29 19:46:42.823:INFOejs.Server:jetty-8.1.15.v20140411
    2018-11-29 19:46:42.876:INFOejs.AbstractConnector:Started NIOSocketConnectorWrapper@0.0.0.0:9051
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/core
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/configuration/beans
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/configuration/parameterized-types
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/configuration/security
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://schemas.xmlsoap.org/wsdl/
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://www.w3.org/2005/08/addressing
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/08/addressing
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (192) [org.apache.cxf.management.InstrumentationManager]
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-wsdl (195) [org.apache.cxf.wsdl.WSDLManager]
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-xml (197) [org.apache.cxf.binding.xml.XMLBindingFactory, org.apache.cxf.binding.xml.wsdl11.XMLWSDLExtensionLoader]
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-soap (198) [org.apache.cxf.binding.soap.SoapBindingFactory, org.apache.cxf.binding.soap.SoapTransportFactory]
    Nov 29, 2018 7:46:43 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/bindings/soap
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-policy (217) [org.apache.cxf.ws.policy.PolicyEngine, org.apache.cxf.policy.PolicyDataEngine, org.apache.cxf.ws.policy.AssertionBuilderRegistry, org.apache.cxf.ws.policy.PolicyInterceptorProviderRegistry, org.apache.cxf.ws.policy.PolicyBuilder, org.apache.cxf.ws.policy.PolicyAnnotationListener, org.apache.cxf.ws.policy.attachment.ServiceModelPolicyProvider, org.apache.cxf.ws.policy.attachment.external.DomainExpressionBuilderRegistry, org.apache.cxf.ws.policy.attachment.external.EndpointReferenceDomainExpressionBuilder, org.apache.cxf.ws.policy.attachment.external.URIDomainExpressionBuilder, org.apache.cxf.ws.policy.attachment.wsdl11.Wsdl11AttachmentPolicyProvider, org.apache.cxf.ws.policy.mtom.MTOMAssertionBuilder, org.apache.cxf.ws.policy.mtom.MTOMPolicyInterceptorProvider]
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (199) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/transports/http/configuration
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/simple
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-frontend-jaxws (201) [org.apache.cxf.jaxws.context.WebServiceContextResourceResolver]
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxws
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs-client
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/binding/coloc
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-local (213) [org.apache.cxf.transport.local.LocalTransportFactory]
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-object (214) [org.apache.cxf.binding.object.ObjectBindingFactory]
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/binding/object
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/policy
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://www.w3.org/ns/ws-policy
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://www.w3.org/2006/07/ws-policy
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/09/policy
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/...secext-1.0.xsd
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/...tility-1.0.xsd
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://www.w3.org/2000/09/xmldsig#
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://docs.oasis-open.org/ws-sx/ws-...ypolicy/200702
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-addr (234) [org.apache.cxf.ws.addressing.policy.AddressingAssertionBuilder, org.apache.cxf.ws.addressing.policy.UsingAddressingAssertionBuilder, org.apache.cxf.ws.addressing.policy.AddressingPolicyInterceptorProvider, org.apache.cxf.ws.addressing.impl.AddressingWSDLExtensionLoader, org.apache.cxf.ws.addressing.WSAddressingFeature$WSAddressingFeatureApplier, org.apache.cxf.ws.addressing.MAPAggregator$MAPAggregatorLoader]
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/ws/addressing
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-security (236) [org.apache.cxf.ws.security.policy.WSSecurityPolicyLoader, org.apache.cxf.ws.security.cache.CacheCleanupListener]
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-rm (238) [org.apache.cxf.ws.rm.RMManager, org.apache.cxf.ws.rm.policy.RMPolicyInterceptorProvider, org.apache.cxf.ws.rm.policy.RM10AssertionBuilder, org.apache.cxf.ws.rm.policy.RM12AssertionBuilder, org.apache.cxf.ws.rm.policy.WSRMP12PolicyLoader, org.apache.cxf.ws.rm.policy.MC11PolicyLoader, org.apache.cxf.ws.rm.policy.RSPPolicyLoader]
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://cxf.apache.org/ws/rm/manager
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
    INFORMATION: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2005/02/rm/policy
    Nov 29, 2018 7:46:44 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
    INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-javascript (239) [org.apache.cxf.javascript.JavascriptServerListener]
    Nov 29, 2018 7:46:44 PM org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
    INFORMATION: New Caching Service registered
    SLF4J: Class path contains multiple SLF4J bindings.
    SLF4J: Found binding in [jar:file:/D:/Programme/kettle/pdi-ce-8.1.0.0-365/data-integration/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: Found binding in [jar:file:/D:/Programme/kettle/pdi-ce-8.1.0.0-365/data-integration/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
    SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
    SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
    Nov 29, 2018 7:46:48 PM org.apache.cxf.endpoint.ServerImpl initDestination
    INFORMATION: Setting the server's publish address to be /lineage
    Nov 29, 2018 7:46:48 PM org.apache.cxf.endpoint.ServerImpl initDestination
    INFORMATION: Setting the server's publish address to be /i18n
    Nov 29, 2018 7:46:49 PM org.apache.cxf.endpoint.ServerImpl initDestination
    INFORMATION: Setting the server's publish address to be /marketplace
    Nov 29, 2018 7:46:49 PM org.apache.cxf.endpoint.ServerImpl initDestination
    INFORMATION: Setting the server's publish address to be /repositories
    Nov 29, 2018 7:46:49 PM org.apache.cxf.endpoint.ServerImpl initDestination
    INFORMATION: Setting the server's publish address to be /browser
    2018/11/29 19:46:53 - Spoon - Logging is at level : Debug
    2018/11/29 19:46:54 - Carte - Installing timer to purge stale objects after 1440 minutes.
    2018/11/29 19:46:58 - Spoon - Use of StepMetaInterface#getDialogClassName is deprecated, use PluginDialog annotation instead.
    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)
    2018/11/29 19:47:24 - Spoon - Use of StepMetaInterface#getDialogClassName is deprecated, use PluginDialog annotation instead.
    2018/11/29 19:47:41 - Spoon - Using legacy execution engine
    2018/11/29 19:47:41 - Spoon - Transformation opened.
    2018/11/29 19:47:41 - Spoon - Launching transformation [test_excel_input]...
    2018/11/29 19:47:41 - Spoon - Started the transformation execution.
    2018/11/29 19:47:41 - test_excel_input - Dispatching started for transformation [test_excel_input]
    2018/11/29 19:47:43 - Microsoft Excel Input.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
    2018/11/29 19:47:43 - Microsoft Excel Input 2.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
    2018/11/29 19:47:43 - Spoon - The transformation has finished!!
    2018/11/29 19:47:51 - Spoon - Use of StepMetaInterface#getDialogClassName is deprecated, use PluginDialog annotation instead.
    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)
    [size]
    Last edited by athor; 11-29-2018 at 02:56 PM.

  6. #6
    Join Date
    Apr 2008
    Posts
    4,639

    Default

    This looks like a regression bug.
    You should file a report at http://jira.pentaho.com

  7. #7
    Join Date
    Sep 2006
    Posts
    17

    Default

    Hi All,

    @gutlez, Thank you very much for the tip. I checked the jira with the following filter (https://jira.pentaho.com/browse/PDI-...72018-01-01%27) to find that this issue was [p]solved in pdi 8.2[b]

    After installing the 8.2.x.x Version I can say the Excel Step I'm able to rename it.

    How can I set a Thread to "solved"?

    Thank you all

    T.

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 - 2017 Pentaho Corporation. All Rights Reserved.