Atrium Integrator - Error processing row from Excel file -  java.lang.NullPointerException

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Atrium Core - CMDB


    COMPONENT:

    BMC Atrium Core


    APPLIES TO:

    9.1.03 and above



    PROBLEM:

    Spoon Version : 6.0

    When the Pentaho transformation is run the step that uses the excel spreadsheet as input fails with the following message:

    2018/04/17 21:13:18 - Stelco Input Data.0 - ERROR (version 6.0.1.0-386, build 1 from 2017-12-28 11.31.33 by buildadm) : Error processing row from Excel file [/opt/bmc/ars/data/ToOnDemand/StelcoData/StelcoAssetDump-MASTER-2018-Mar-02.xlsx] : java.lang.NullPointerException
    2018/04/17 21:13:18 - Stelco Input Data.0 - ERROR (version 6.0.1.0-386, build 1 from 2017-12-28 11.31.33 by buildadm) : java.lang.NullPointerException
    2018/04/17 21:13:18 - Stelco Input Data.0 -     at org.pentaho.di.trans.steps.excelinput.ExcelInput.fillRow(ExcelInput.java:135)
    2018/04/17 21:13:18 - Stelco Input Data.0 -     at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:620)
    2018/04/17 21:13:18 - Stelco Input Data.0 -     at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:430)
    2018/04/17 21:13:18 - Stelco Input Data.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    2018/04/17 21:13:18 - Stelco Input Data.0 -     at java.lang.Thread.run(Thread.java:748)

     


    SOLUTION:


    Spoon Version : 6.0.1.0.-386

    Issue is with Spread sheet type (Engine) Excel 2007 XLSX (Apache POI Streaming) which doesnt allows the null value in the spread sheet.

    -Login to Spoon Client
    -Modify Microsoft Excel Input File and Set the Spread sheet type Engine Excel 2007 XLSX (Apache POI Streaming) to Excel 2007 XLSX (Apache POI)


    User-added image

    Modify to Excel 2007 XLSX (Apache POI)

    User-added image




     
     


    Article Number:

    000152229


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles