Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error previewing an excel file when all the fields are empty - Pentaho 5.0.3

  1. #1
    Join Date
    Sep 2013
    Posts
    21

    Default Error previewing an excel file when all the fields are empty - Pentaho 5.0.3

    Hi All,

    When I tried to preview the Xlsx file data using Microsoft Excel Input step, It is throwing the following error :

    ERROR (version 5.0.1, build 1 from 2013-10-30_19-53-32 by buildguy) : Error processing row from Excel file [D:\sample.xlsx] :
    org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : null
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - ERROR (version 5.0.1, build 1 from 2013-10-30_19-53-32 by buildguy) : org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : null
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:500)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1417)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1404)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.ZipPackage.closeImpl(ZipPackage.java:349)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:420)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.close(PoiWorkbook.java:101)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.jumpToNextFile(ExcelInput.java:757)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:717)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:471)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at java.lang.Thread.run(Unknown Source)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - Caused by: java.lang.NullPointerException
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller.marshall(ZipPackagePropertiesMarshaller.java:46)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:444)
    2014/04/20 20:42:13 - Microsoft Excel Input.0 - ... 10 more


    It is able to read the data, till any of the fields contains the data, If all the fields are empty then it is throwing the above mentioned error.


    Note: I'm using Excel 2007 XLSX (Apache POI) as Spread Sheet type (engine).



    Any help is highly appreciated.


    Thanks,
    Siva

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Please, attach an XSLX sample file and a transformation containing your Excel Input configuration, so we can reproduce the error message.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Sep 2013
    Posts
    21

    Default

    Hi Marabu,

    Thanks for your response.

    After lot of struggled, finally figured the issue. Issue is with the content & format of the data available in the Excel file.

    I have changed the file format to .csv because I can't change the source data. It's working fine now.


    Regards,
    Siva
    Last edited by csnr007; 04-28-2014 at 03:11 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.