[HOP-3213] Microsoft Excel input causes exception on large XLSX file and clicking Get sheetnames

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 0.99
• Fix Version/s: Not applicable
• Component/s: Hop GUI, Plugins
• Labels: Excel XLSX
• Environment: Windows 10, JDK15, 34GB allocated to Apache Hop
• Assignee: Hans Van Akelyen
• Reporter: Thad Guidry
• Created: 24/Aug/21 18:53
• Updated: 24/Aug/21 21:56
• Resolved: 24/Aug/21 21:00

Description

Texas SOS Public Data file used for testing:
https://drive.google.com/file/d/1fV-Bwgf2rZpUZgpnMPeiWiBGOZaaScwi/view?usp=sharing

Unable to open dialog for this transform
java.lang.OutOfMemoryError: Java heap space
{{ at org.apache.xmlbeans.impl.store.Cur.createElementXobj(Cur.java:260)}}
{{ at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.startElement(Cur.java:2997)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNode(Locale.java:1415)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNodeChildren(Locale.java:1398)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNode(Locale.java:1440)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNodeChildren(Locale.java:1398)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNode(Locale.java:1440)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNodeChildren(Locale.java:1398)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNode(Locale.java:1440)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNodeChildren(Locale.java:1398)}}
{{ at org.apache.xmlbeans.impl.store.Locale.loadNode(Locale.java:1440)}}
{{ at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1380)}}
{{ at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1365)}}
{{ at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:370)}}
{{ at org.apache.poi.POIXMLTypeLoader.parse(POIXMLTypeLoader.java:164)}}
{{ at org.openxmlformats.schemas.spreadsheetml.x2006.main.WorksheetDocument$Factory.parse(Unknown Source)}}
{{ at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:226)}}
{{ at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:218)}}
{{ at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:443)}}
{{ at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:408)}}
{{ at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:169)}}
{{ at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:270)}}
{{ at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:123)}}
{{ at org.apache.hop.pipeline.transforms.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:66)}}
{{ at org.apache.hop.pipeline.transforms.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:38)}}
{{ at org.apache.hop.pipeline.transforms.excelinput.ExcelInputDialog.getSheets(ExcelInputDialog.java:1840)}}
{{ at org.apache.hop.pipeline.transforms.excelinput.ExcelInputDialog$8.widgetSelected(ExcelInputDialog.java:1086)}}
{{ at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)}}
{{ at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)}}
{{ at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4209)}}
{{ at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043)}}
{

{ at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4026)}

}