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.

  • When editing Sparkl plugin, go to "Elements" and preview the "variableinfo" dashboard. It returns "No data available in table". pentaho.log: 2015-01-19 15:17:35,516 INFO [org.pentaho.di] 2015/01/19 15:17:35 - getVariableInfo - Dispatching started for transformation [getVariableInfo] 2015-01-19 15:17:35,519 INFO [org.pentaho.di] 2015/01/19 15:17:35 - Get Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0) 2015-01-19 15:17:35,521 ERROR [org.pentaho.di] 2015/01/19 15:17:35 - OUTPUT.0 - ERROR (version 5.3.0.0-196, build 1 from 2015-01-17_19-53-46 by buildguy) : Unexpected error 2015-01-19 15:17:35,521 ERROR [org.pentaho.di] 2015/01/19 15:17:35 - OUTPUT.0 - ERROR (version 5.3.0.0-196, build 1 from 2015-01-17_19-53-46 by buildguy) : java.lang.NullPointerException 2015/01/19 15:17:35 - OUTPUT.0 - at org.pentaho.di.core.row.RowMeta.searchValueMeta(RowMeta.java:489) 2015/01/19 15:17:35 - OUTPUT.0 - at org.pentaho.di.core.row.RowMeta.exists(RowMeta.java:153) 2015/01/19 15:17:35 - OUTPUT.0 - at org.pentaho.di.core.row.RowMeta.addValueMeta(RowMeta.java:166) 2015/01/19 15:17:35 - OUTPUT.0 - at org.pentaho.di.trans.steps.normaliser.NormaliserMeta.getFields(NormaliserMeta.java:254) 2015/01/19 15:17:35 - OUTPUT.0 - at org.pentaho.di.trans.steps.normaliser.Normaliser.processRow(Normaliser.java:74) 2015/01/19 15:17:35 - OUTPUT.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/01/19 15:17:35 - OUTPUT.0 - at java.lang.Thread.run(Unknown Source) 2015-01-19 15:17:35,525 INFO [org.pentaho.di] 2015/01/19 15:17:35 - OUTPUT.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2015-01-19 15:17:35,525 INFO [org.pentaho.di] 2015/01/19 15:17:35 - getVariableInfo - Transformation detected one or more steps with errors.
    via by Eduardo Lopes,
  • 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.core.row.RowMeta.searchValueMeta(RowMeta.java:489) at org.pentaho.di.core.row.RowMeta.exists(RowMeta.java:153) at org.pentaho.di.core.row.RowMeta.addValueMeta(RowMeta.java:166) at org.pentaho.di.trans.steps.normaliser.NormaliserMeta.getFields(NormaliserMeta.java:254) at org.pentaho.di.trans.steps.normaliser.Normaliser.processRow(Normaliser.java:74) 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,