java.lang.NullPointerException

Pentaho BI Platform Tracking | Alexander Schurman | 1 year ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    In Pentaho 6 The EXCEL Input step is showing a " java.lang.NullPointerException" when the Files to be processed come from a previous step. I tested with 1 File and/or multiple files. NOTE: issue is not happening if the Files or RegEx are included in the STEP itself and no use of Previous step data. After Executing NEXT error is coming out {noformat} 2016/01/04 11:34:51 - Spoon - Transformation opened. 2016/01/04 11:34:51 - Spoon - Launching transformation [test_excel_file]... 2016/01/04 11:34:51 - Spoon - Started the transformation execution. 2016/01/04 11:34:51 - test_excel_file - Dispatching started for transformation [test_excel_file] 2016/01/04 11:34:51 - GetFile(s).0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Unexpected error 2016/01/04 11:34:51 - Microsoft Excel Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : java.lang.NullPointerException 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:97) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:45) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at Proxy15f9e943_d2ef_49f0_baaa_7ba9f15604db.getResourcesFromRow(Unknown Source) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at Proxy15f9e943_d2ef_49f0_baaa_7ba9f15604db.getResourcesFromRow(Unknown Source) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.extensionpoints.trans.step.StepExternalConsumerRowListener.rowReadEvent(StepExternalConsumerRowListener.java:63) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.BaseStep.getRowFrom(BaseStep.java:2171) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:372) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at java.lang.Thread.run(Unknown Source) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2016/01/04 11:34:51 - test_excel_file - Transformation detected one or more steps with errors. 2016/01/04 11:34:51 - test_excel_file - Transformation is killing the other steps! 2016/01/04 11:34:51 - test_excel_file - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Errors detected! 2016/01/04 11:34:51 - Spoon - The transformation has finished!! 2016/01/04 11:34:51 - test_excel_file - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Errors detected! 2016/01/04 11:34:51 - test_excel_file - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Errors detected! {noformat}

    Pentaho BI Platform Tracking | 1 year ago | Alexander Schurman
    java.lang.NullPointerException
  2. 0

    In Pentaho 6 The EXCEL Input step is showing a " java.lang.NullPointerException" when the Files to be processed come from a previous step. I tested with 1 File and/or multiple files. NOTE: issue is not happening if the Files or RegEx are included in the STEP itself and no use of Previous step data. After Executing NEXT error is coming out {noformat} 2016/01/04 11:34:51 - Spoon - Transformation opened. 2016/01/04 11:34:51 - Spoon - Launching transformation [test_excel_file]... 2016/01/04 11:34:51 - Spoon - Started the transformation execution. 2016/01/04 11:34:51 - test_excel_file - Dispatching started for transformation [test_excel_file] 2016/01/04 11:34:51 - GetFile(s).0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Unexpected error 2016/01/04 11:34:51 - Microsoft Excel Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : java.lang.NullPointerException 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:97) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:45) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at Proxy15f9e943_d2ef_49f0_baaa_7ba9f15604db.getResourcesFromRow(Unknown Source) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at Proxy15f9e943_d2ef_49f0_baaa_7ba9f15604db.getResourcesFromRow(Unknown Source) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.extensionpoints.trans.step.StepExternalConsumerRowListener.rowReadEvent(StepExternalConsumerRowListener.java:63) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.BaseStep.getRowFrom(BaseStep.java:2171) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:372) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - at java.lang.Thread.run(Unknown Source) 2016/01/04 11:34:51 - Microsoft Excel Input.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2016/01/04 11:34:51 - test_excel_file - Transformation detected one or more steps with errors. 2016/01/04 11:34:51 - test_excel_file - Transformation is killing the other steps! 2016/01/04 11:34:51 - test_excel_file - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Errors detected! 2016/01/04 11:34:51 - Spoon - The transformation has finished!! 2016/01/04 11:34:51 - test_excel_file - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Errors detected! 2016/01/04 11:34:51 - test_excel_file - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Errors detected! {noformat}

    Pentaho BI Platform Tracking | 1 year ago | Alexander Schurman
    java.lang.NullPointerException
  3. 0

    I had this transformation (attached) since 4.8 I think... worked nicely over 5.x, but came 6.0 it broke. I get an NPE on the step. If I use the filename directly into the step configuration, it works - so it's not the "it's inside a zip file" problem at all (i.e.: "zip:file:///C:/Users/me/Documents/Pentaho/samples/XLS_example1.zip!/XLS_example1.xls" set into Excel Input step works) Could be related, duplicated from PDI-5312, but I have a feeling it's not. {noformat} 2015/11/18 09:59:03 - Microsoft Excel Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Unexpected error 2015/11/18 09:59:03 - Microsoft Excel Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : java.lang.NullPointerException 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:97) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:45) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at Proxy03eabb94_c291_4911_9281_b1170d23b13e.getResourcesFromRow(Unknown Source) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at Proxy03eabb94_c291_4911_9281_b1170d23b13e.getResourcesFromRow(Unknown Source) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.extensionpoints.trans.step.StepExternalConsumerRowListener.rowReadEvent(StepExternalConsumerRowListener.java:63) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.BaseStep.getRowFrom(BaseStep.java:2171) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:372) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at java.lang.Thread.run(Thread.java:745) {noformat}

    Pentaho BI Platform Tracking | 1 year ago | João Ciocca
    java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I had this transformation (attached) since 4.8 I think... worked nicely over 5.x, but came 6.0 it broke. I get an NPE on the step. If I use the filename directly into the step configuration, it works - so it's not the "it's inside a zip file" problem at all (i.e.: "zip:file:///C:/Users/me/Documents/Pentaho/samples/XLS_example1.zip!/XLS_example1.xls" set into Excel Input step works) Could be related, duplicated from PDI-5312, but I have a feeling it's not. {noformat} 2015/11/18 09:59:03 - Microsoft Excel Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Unexpected error 2015/11/18 09:59:03 - Microsoft Excel Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : java.lang.NullPointerException 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:97) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:45) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at Proxy03eabb94_c291_4911_9281_b1170d23b13e.getResourcesFromRow(Unknown Source) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at Proxy03eabb94_c291_4911_9281_b1170d23b13e.getResourcesFromRow(Unknown Source) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.metaverse.analyzer.kettle.extensionpoints.trans.step.StepExternalConsumerRowListener.rowReadEvent(StepExternalConsumerRowListener.java:63) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.BaseStep.getRowFrom(BaseStep.java:2171) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:372) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/11/18 09:59:03 - Microsoft Excel Input.0 - at java.lang.Thread.run(Thread.java:745) {noformat}

    Pentaho BI Platform Tracking | 1 year ago | João Ciocca
    java.lang.NullPointerException
  6. 0

    Getting a nullpointer exception when switching displayables in J2ME

    Stack Overflow | 6 years ago | Pallinder
    java.lang.NullPointerException: 0 at javax.microedition.lcdui.Display$ChameleonTunnel.callScreenListener(), bci=46 at com.sun.midp.chameleon.layers.SoftButtonLayer.processCommand(), bci=74 at com.sun.midp.chameleon.layers.SoftButtonLayer.soft1(), bci=37 at com.sun.midp.chameleon.layers.SoftButtonLayer.keyInput(), bci=36 at com.sun.midp.chameleon.CWindow.keyInput(), bci=38 at javax.microedition.lcdui.Display$DisplayEventConsumerImpl.handleKeyEvent(), bci=17 at com.sun.midp.lcdui.DisplayEventListener.process(), bci=277 at com.sun.midp.events.EventQueue.run(), bci=179

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow()
    2. org.pentaho.metaverse
      ExcelInputExternalResourceConsumer.getResourcesFromRow
      1. org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:97)
      2. org.pentaho.metaverse.analyzer.kettle.step.excelinput.ExcelInputExternalResourceConsumer.getResourcesFromRow(ExcelInputExternalResourceConsumer.java:45)
      2 frames
    3. Unknown
      Proxy15f9e943_d2ef_49f0_baaa_7ba9f15604db.getResourcesFromRow
      1. Proxy15f9e943_d2ef_49f0_baaa_7ba9f15604db.getResourcesFromRow(Unknown Source)
      2. Proxy15f9e943_d2ef_49f0_baaa_7ba9f15604db.getResourcesFromRow(Unknown Source)
      2 frames
    4. org.pentaho.metaverse
      StepExternalConsumerRowListener.rowReadEvent
      1. org.pentaho.metaverse.analyzer.kettle.extensionpoints.trans.step.StepExternalConsumerRowListener.rowReadEvent(StepExternalConsumerRowListener.java:63)
      1 frame
    5. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.step.BaseStep.getRowFrom(BaseStep.java:2171)
      2. org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:372)
      3. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      3 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame