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.

  • Cassandra another frame size issue
    via Stack Overflow by Kacu
    ,
  • Pentaho Error while importing data and cleaning
    via Stack Overflow by Zack
    ,
  • CSV - Lazy conversion gives an error message, but everything works. Here is the example of error message. If I switch Lazy conversion off then error disappears. 2011/09/29 12:00:31 - Spoon - Transformation opened. 2011/09/29 12:00:31 - Spoon - Launching transformation [TestForSelectValues]... 2011/09/29 12:00:31 - Spoon - Started the transformation execution. 2011/09/29 12:00:31 - TestForSelectValues - Dispatching started for transformation [TestForSelectValues] 2011/09/29 12:00:31 - Transformation metadata - Natural sort of steps executed in 0 ms (4 time previous steps calculated) 2011/09/29 12:00:31 - CSV file input.0 - Header row skipped in file 'N:\Daily Positions\State Street\Pentaho\Null in CashPercentage\2010-08-04 SS Position.csv' 2011/09/29 12:00:31 - CSV file input.0 - Finished processing (I=597, O=0, R=0, W=596, U=0, E=0) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Error writing field (0,3) : java.lang.NullPointerException 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : java.lang.NullPointerException 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:424) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:279) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeRowToFile(ExcelOutput.java:215) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:147) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Unknown Source) 2011/09/29 12:00:31 - Select values.0 - Finished processing (I=0, O=0, R=596, W=596, U=0, E=0) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - Finished processing (I=0, O=2, R=3, W=2, U=0, E=1) 2011/09/29 12:00:31 - Spoon - The transformation has finished!! 2011/09/29 12:00:31 - TestForSelectValues - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected! 2011/09/29 12:00:31 - TestForSelectValues - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected! 2011/09/29 12:00:31 - TestForSelectValues - TestForSelectValues 2011/09/29 12:00:31 - TestForSelectValues - TestForSelectValues
    via by Alex Sviridov,
  • * In pdi, DynamicSQLRow shows an Exception if you select "Query only on parameters change" and you handle the errors. 2013/06/10 13:48:04 - Dynamic SQL row.0 - ERROR (version 4.4.0, build 1 from 2013-06-04 10.04.23 by fabs) : Unexpected error 2013/06/10 13:48:04 - Dynamic SQL row.0 - ERROR (version 4.4.0, build 1 from 2013-06-04 10.04.23 by fabs) : java.lang.NullPointerException 2013/06/10 13:48:04 - Dynamic SQL row.0 - ERROR (version 4.4.0, build 1 from 2013-06-04 10.04.23 by fabs) : at org.pentaho.di.trans.steps.dynamicsqlrow.DynamicSQLRow.lookupValues(DynamicSQLRow.java:87) 2013/06/10 13:48:04 - Dynamic SQL row.0 - ERROR (version 4.4.0, build 1 from 2013-06-04 10.04.23 by fabs) : at org.pentaho.di.trans.steps.dynamicsqlrow.DynamicSQLRow.processRow(DynamicSQLRow.java:255) 2013/06/10 13:48:04 - Dynamic SQL row.0 - ERROR (version 4.4.0, build 1 from 2013-06-04 10.04.23 by fabs) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2013/06/10 13:48:04 - Dynamic SQL row.0 - ERROR (version 4.4.0, build 1 from 2013-06-04 10.04.23 by fabs) : at java.lang.Thread.run(Thread.java:636) That's why I made this small patch: $ diff ./src/org/pentaho/di/trans/steps/dynamicsqlrow/DynamicSQLRow.java ./src/org/pentaho/di/trans/steps/dynamicsqlrow/DynamicSQLRow.java~ 89,91d88 < < // Save current parameters value as previous ones < data.previousSQL= sql; 216a214,219 > } > > // Save current parameters value as previous ones > if(meta.isQueryOnlyOnChange()) > { > data.previousSQL= sql;
    via by Fabien Carrion,
    • java.lang.NullPointerException at org.pentaho.di.trans.steps.jsoninput.JsonInput.prepareToRowProcessing(JsonInput.java:153) at org.pentaho.di.trans.steps.jsoninput.JsonInput.processRow(JsonInput.java:101) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Unknown Source)

    Users with the same issue

    Unknown visitor1 times, last one,