java.lang.NullPointerException

Pentaho BI Platform Tracking | João Ciocca | 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

    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
  2. 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
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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

    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
      Proxy03eabb94_c291_4911_9281_b1170d23b13e.getResourcesFromRow
      1. Proxy03eabb94_c291_4911_9281_b1170d23b13e.getResourcesFromRow(Unknown Source)
      2. Proxy03eabb94_c291_4911_9281_b1170d23b13e.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(Thread.java:745)
      1 frame