Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Issue Reading XLSX file

  1. #1

    Default Issue Reading XLSX file

    Hello I'm using PDI 4.1.0 in W7, and while getting sheets name in an excel xslx file i get the next error

    Unable to open dialog for this step
    java.lang.OutOfMemoryError: Java heap space
    org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3044)
    org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3065)
    org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElement(Locale.java:3259)
    org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo.java:1082)
    org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseAttributesNS(PiccoloLexer.java:1802)
    org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseOpenTagNS(PiccoloLexer.java:1521)
    org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseTagNS(PiccoloLexer.java:1362)
    org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXMLNS(PiccoloLexer.java:1293)
    org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXML(PiccoloLexer.java:1261)
    org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yylex(PiccoloLexer.java:4808)
    org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290)
    org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java:1400)
    org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714)
    org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3454)
    org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1276)
    org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1263)
    org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
    org.openxmlformats.schemas.spreadsheetml.x2006.main.WorksheetDocument$Factory.parse(Unknown Source)
    org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:127)
    org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:119)
    org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:222)
    org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:200)
    org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:172)
    org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63)
    org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:21)
    org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:14)
    org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog.getSheets(ExcelInputDialog.java:1794)
    org.pentaho.di.ui.trans.steps.excelinput.ExcelInputDialog$17.widgetSelected(ExcelInputDialog.java:1151)
    org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)




    IS IT NECESARY that I give more memory to pdi touching spoon.bat ??
    please tell me instructions

  2. #2
    Join Date
    Nov 2008
    Posts
    143

    Default

    Perhaps you should try giving it more memory, then...

  3. #3

    Default

    how much should i put, the file is 6Mb of size and I give about 512 mb to Spoon the problem may be another while retrieving data from xlsx file
    Last edited by pentaho_fan; 02-17-2011 at 09:19 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.