Uploaded image for project: 'Apache Hop'
  1. Apache Hop
  2. HOP-3213

Microsoft Excel input causes exception on large XLSX file and clicking Get sheetnames

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Bug
    • 0.99
    • Not applicable
    • Hop GUI, Plugins
    • Windows 10, JDK15, 34GB allocated to Apache Hop

    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)}

      }

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            hansva Hans Van Akelyen Assign to me
            thadguidry@gmail.com Thad Guidry
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment