java.lang.NullPointerException

Pentaho BI Platform Tracking | Alexander Schurman | 11 months ago
  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 | 11 months 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 | 11 months 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

    Android: Saving Map State in Google map

    Stack Overflow | 11 months ago | Junie Negentien
    java.lang.RuntimeException: Unable to resume activity {com.ourThesis.junieNegentien2015/com.ourThesis.junieNegentien2015.MainActivity}: java.lang.NullPointerException

    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