java.lang.NullPointerException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • This NPE makes it very hard to know exactly what is wrong in my Transformation: java.lang.NullPointerException at org.pentaho.di.trans.steps.mapping.MappingMeta.loadMappingMeta(MappingMeta.java:624) at org.pentaho.di.trans.steps.mapping.MappingMeta.getFields(MappingMeta.java:383) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1898) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1753) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1811) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1783) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1771) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.get(SelectValuesDialog.java:710) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.access$100(SelectValuesDialog.java:79) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog$2.handleEvent(SelectValuesDialog.java:154) 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:1169) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6943) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) Is there something wrong in my Transformation setup that is causing some of the parameters for this method to be NULL ? public synchronized static final TransMeta loadMappingMeta(MappingMeta mappingMeta, Repository rep, VariableSpace space) throws KettleException { ... } If this is an error on my side, it would be nice to get some message or hint of what configuration is missing in the requirements of getting the fields from a Mapping step.
    via by Robert Wennström,
  • This NPE makes it very hard to know exactly what is wrong in my Transformation: java.lang.NullPointerException at org.pentaho.di.trans.steps.mapping.MappingMeta.loadMappingMeta(MappingMeta.java:624) at org.pentaho.di.trans.steps.mapping.MappingMeta.getFields(MappingMeta.java:383) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1898) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1753) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1811) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1783) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1771) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.get(SelectValuesDialog.java:710) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.access$100(SelectValuesDialog.java:79) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog$2.handleEvent(SelectValuesDialog.java:154) 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:1169) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6943) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) Is there something wrong in my Transformation setup that is causing some of the parameters for this method to be NULL ? public synchronized static final TransMeta loadMappingMeta(MappingMeta mappingMeta, Repository rep, VariableSpace space) throws KettleException { ... } If this is an error on my side, it would be nice to get some message or hint of what configuration is missing in the requirements of getting the fields from a Mapping step.
    via by Robert Wennström,
  • Spoon/Kitchen throws exceptions if a transformation (Outer) has a mapping to second transformation (Between) which itself has a mapping to a third transformation (Inner). Will attach simple test case to reproduce it. Note: - Running Between using a DataGrid as input instead of the Mapping Input step works fine (i.e. the single level of nesting (mapping) from Between to Inner works fine on its own). - Circumventing the mapping in Between to Inner by disabling the hops around the mapping-step and "short-circuiting" past it runs fine from Outer (i.e. the single level of nesting (mapping) from Outer to Between works fine on its own). Also: I tried various combinations of - explicitly defining fields in the Mapping Inputs, or letting it implicitly pass through all unspecified fields, - explicitly connecting the input and output steps in the Mapping-step, or letting it figure it out on its own. The specific exceptions actually vary depending on how the transformation is initiated: - Previewing Outer by selecting its Sort rows step reports: {code} 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to load the mapping transformation because of an error : org.pentaho.di.core.exception.KettleException: 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to prepare (allocate, initialize) the execution of the mapping (sub-transformation) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException: 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to prepare (allocate, initialize) the execution of the mapping (sub-transformation) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.prepareMappingExecution(Mapping.java:273) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.init(Mapping.java:488) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException: 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:792) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.prepareMappingExecution(Mapping.java:271) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : ... 3 more 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Error initializing step [Mapping to Between] 2012/04/26 17:37:06 - NestingTest_Outer - Step [Data Grid.0] initialized flawlessly. 2012/04/26 17:37:06 - NestingTest_Outer - Step [Sort rows.0] initialized flawlessly. 2012/04/26 17:37:06 - NestingTest_Outer - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Step [Mapping to Between.0] failed to initialize! {code} - Previewing by selecting the "Mapping to Between" step in Outer gives a simple {code}There was an error during transformation execution{code} window, with a *Details* button. Clicking *Details* reveals the following Exception: {code} java.lang.NullPointerException at org.pentaho.di.trans.steps.mapping.MappingMeta.loadMappingMeta(MappingMeta.java:620) at org.pentaho.di.trans.steps.mapping.MappingMeta.getFields(MappingMeta.java:383) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1898) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1753) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1730) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1675) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1650) at org.pentaho.di.trans.steps.mapping.MappingMeta.getFields(MappingMeta.java:552) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1898) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1753) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1675) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1650) at org.pentaho.di.ui.trans.debug.TransDebugDialog.showStepDebugInformation(TransDebugDialog.java:373) at org.pentaho.di.ui.trans.debug.TransDebugDialog.refreshStepList(TransDebugDialog.java:251) at org.pentaho.di.ui.trans.debug.TransDebugDialog.getData(TransDebugDialog.java:210) at org.pentaho.di.ui.trans.debug.TransDebugDialog.open(TransDebugDialog.java:187) at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:833) at org.pentaho.di.ui.spoon.Spoon$32$1.run(Spoon.java:7512) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) 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) {code} Purpose: I came across this when trying to refactor a transformation for performance reasons to run part of it in isolation per row via a Single Threader. The part/transformation that is supposed to run inside the Single Threader has mappings to sub transformations of its own. So the same bug applies when using Single Threader instead of "Mapping (sub-transformation)".
    via by Svein Arnesen,
  • Spoon/Kitchen throws exceptions if a transformation (Outer) has a mapping to second transformation (Between) which itself has a mapping to a third transformation (Inner). Will attach simple test case to reproduce it. Note: - Running Between using a DataGrid as input instead of the Mapping Input step works fine (i.e. the single level of nesting (mapping) from Between to Inner works fine on its own). - Circumventing the mapping in Between to Inner by disabling the hops around the mapping-step and "short-circuiting" past it runs fine from Outer (i.e. the single level of nesting (mapping) from Outer to Between works fine on its own). Also: I tried various combinations of - explicitly defining fields in the Mapping Inputs, or letting it implicitly pass through all unspecified fields, - explicitly connecting the input and output steps in the Mapping-step, or letting it figure it out on its own. The specific exceptions actually vary depending on how the transformation is initiated: - Previewing Outer by selecting its Sort rows step reports: {code} 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to load the mapping transformation because of an error : org.pentaho.di.core.exception.KettleException: 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to prepare (allocate, initialize) the execution of the mapping (sub-transformation) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException: 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unable to prepare (allocate, initialize) the execution of the mapping (sub-transformation) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.prepareMappingExecution(Mapping.java:273) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.init(Mapping.java:488) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException: 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:792) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.prepareMappingExecution(Mapping.java:271) 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : ... 3 more 2012/04/26 17:37:06 - Mapping to Between.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Error initializing step [Mapping to Between] 2012/04/26 17:37:06 - NestingTest_Outer - Step [Data Grid.0] initialized flawlessly. 2012/04/26 17:37:06 - NestingTest_Outer - Step [Sort rows.0] initialized flawlessly. 2012/04/26 17:37:06 - NestingTest_Outer - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Step [Mapping to Between.0] failed to initialize! {code} - Previewing by selecting the "Mapping to Between" step in Outer gives a simple {code}There was an error during transformation execution{code} window, with a *Details* button. Clicking *Details* reveals the following Exception: {code} java.lang.NullPointerException at org.pentaho.di.trans.steps.mapping.MappingMeta.loadMappingMeta(MappingMeta.java:620) at org.pentaho.di.trans.steps.mapping.MappingMeta.getFields(MappingMeta.java:383) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1898) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1753) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1730) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1675) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1650) at org.pentaho.di.trans.steps.mapping.MappingMeta.getFields(MappingMeta.java:552) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1898) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1753) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1675) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1650) at org.pentaho.di.ui.trans.debug.TransDebugDialog.showStepDebugInformation(TransDebugDialog.java:373) at org.pentaho.di.ui.trans.debug.TransDebugDialog.refreshStepList(TransDebugDialog.java:251) at org.pentaho.di.ui.trans.debug.TransDebugDialog.getData(TransDebugDialog.java:210) at org.pentaho.di.ui.trans.debug.TransDebugDialog.open(TransDebugDialog.java:187) at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:833) at org.pentaho.di.ui.spoon.Spoon$32$1.run(Spoon.java:7512) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) 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) {code} Purpose: I came across this when trying to refactor a transformation for performance reasons to run part of it in isolation per row via a Single Threader. The part/transformation that is supposed to run inside the Single Threader has mappings to sub transformations of its own. So the same bug applies when using Single Threader instead of "Mapping (sub-transformation)".
    via by Svein Arnesen,
  • I am using a Mapping (sub-transformation) step in my transformation that has the option "Use a file for the mapping transformation" option selected. That file then points to ///${INSTALL_DIR}/mappings/${ENVIRONMENT}/${TABLENAME}.ktr I have tested the variables are all set and it even shows the correct location when I hover over the location in PDI. However when I run the transformation i get the following: Code: 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to load the mapping transformation because of an error : java.lang.NullPointerException 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : java.lang.NullPointerException 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.MappingMeta.loadMappingMeta(MappingMeta.java:638) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.init(Mapping.java:491) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:62) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error initializing step [Mapping (sub-transformation)] 2012/08/13 15:47:11 - CURRENCY - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Step [Mapping (sub-transformation).0] failed to initialize! 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to load the mapping transformation because of an error : org.pentaho.di.core.exception.KettleException: 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to prepare (allocate, initialize) the execution of the mapping (sub-transformation) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleException: 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to prepare (allocate, initialize) the execution of the mapping (sub-transformation) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.prepareMappingExecution(Mapping.java:284) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.init(Mapping.java:499) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:62) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException: 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:823) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.prepareMappingExecution(Mapping.java:282) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : ... 3 more 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error initializing step [Mapping (sub-transformation)] 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Step [Mapping (sub-transformation).0] failed to initialize! 2012/08/13 15:47:11 - Get all rows to process.0 - Finished reading query, closing connection. 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to prepare for execution of the transformation 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleException: 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:823) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.Trans.execute(Trans.java:395) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1034) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:528) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:445) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:68) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source) I have since tried to directly reference the file rather than use variables and I get the exact same error. I have also right clicked the step and clicked "Open Mapping (sub-transformation) and it opens successfully from the file directory. Am I allowed to use a transformation outside of the repository with this step? I am given the option to select it fine but then it fails with a null pointer exception. It works no problem within the repository but when pulled out into the file system it causes issues. Our reason for pulling these files out is to allow users without connectivity to the repository to edit these files. We do not want them to have access to the repository.
    via by Bill Wallace,
    • java.lang.NullPointerException at org.pentaho.di.trans.steps.mapping.MappingMeta.loadMappingMeta(MappingMeta.java:624) at org.pentaho.di.trans.steps.mapping.MappingMeta.getFields(MappingMeta.java:383) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1898) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1753) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1811) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1783) at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1771) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.get(SelectValuesDialog.java:710) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.access$100(SelectValuesDialog.java:79) at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog$2.handleEvent(SelectValuesDialog.java:154) 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:1169) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6943) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    No Bugmate found.