java.lang.NullPointerException

Pentaho BI Platform Tracking | Bill Wimsatt | 9 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    I am receiving a Null Pointer Exception with using parameters with Table Input step. I have a simple two-step transformation. First Step: Add Constants Name - MyVariable Type - String Value - Deductable Second Step: Table Input Query - Select col1 from mytab where col2 = '?' Replace Variables in Script - True Insert Data from Step - Add Constants Execute for Each Row - True 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : Unexpected error : 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : java.lang.NullPointerException 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.step.BaseStep.getRowFrom(BaseStep.java:1417) 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:92) 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:326) I have tried various ways of execution and none of them are working. If I change the variable type to Integer and provide the appropriate value and column to compare, I do get data returned, but the results are not correct (e.g. Value = 100 and I get values with 0).

    Pentaho BI Platform Tracking | 9 years ago | Bill Wimsatt
    java.lang.NullPointerException
  2. 0

    I am receiving a Null Pointer Exception with using parameters with Table Input step. I have a simple two-step transformation. First Step: Add Constants Name - MyVariable Type - String Value - Deductable Second Step: Table Input Query - Select col1 from mytab where col2 = '?' Replace Variables in Script - True Insert Data from Step - Add Constants Execute for Each Row - True 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : Unexpected error : 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : java.lang.NullPointerException 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.step.BaseStep.getRowFrom(BaseStep.java:1417) 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:92) 2008/03/03 11:43:33 - Table input.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:326) I have tried various ways of execution and none of them are working. If I change the variable type to Integer and provide the appropriate value and column to compare, I do get data returned, but the results are not correct (e.g. Value = 100 and I get values with 0).

    Pentaho BI Platform Tracking | 9 years ago | Bill Wimsatt
    java.lang.NullPointerException

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at org.pentaho.di.trans.step.BaseStep.getRowFrom()
    2. org.pentaho.di
      TableInput.run
      1. org.pentaho.di.trans.step.BaseStep.getRowFrom(BaseStep.java:1417)
      2. org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:92)
      3. org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:326)
      3 frames