One Star

Java Heap space error when trying to create metadata for a excel file

HI,
I am trying to create metadata for an excel file but my program gets "Unhandled event loop exception, Java heap space" when I select the file in step 2 of file creation - At the bottom I have posted the error from the log.
The file is only 7mb in size(tried other files too) and I have used files before with 200mb+ with no problems so I can't see why it is crashing. The current jobs in the project run fine with no problems.
Running on XP - TOS version Version: 4.0.1 - 2GB ram
I have read through some forum post about memory problems and they suggested adjusting the heap size in the config file but i have attempted with no luck. below is my current setup for the heap size
-vmargs
-Xms40m
-Xmx512m
-XX:MaxPermSize=128m

As mention the error from the logs
java.lang.OutOfMemoryError: Java heap space
at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3039)
at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3060)
at org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElement(Locale.java:3250)
at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo.java:1082)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseAttributesNS(PiccoloLexer.java:1802)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseOpenTagNS(PiccoloLexer.java:1521)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseTagNS(PiccoloLexer.java:1362)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXMLNS(PiccoloLexer.java:1293)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXML(PiccoloLexer.java:1261)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yylex(PiccoloLexer.java:4808)
at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290)
at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java:1400)
at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714)
at org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439)
at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1270)
at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1257)
at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
at org.openxmlformats.schemas.spreadsheetml.x2006.main.WorksheetDocument$Factory.parse(Unknown Source)
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:126)
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:118)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:201)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:164)
at org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelReader.init(Unknown Source)
at org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelReader.<init>(Unknown Source)
at org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep1Form.viewExcelFile(Unknown Source)
at org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep1Form.access$4(Unknown Source)
at org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep1Form$7.modifyText(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:167)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1027)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1008)

Any help with this would be much appreciated.
2 REPLIES
Community Manager

Re: Java Heap space error when trying to create metadata for a excel file

Hi
Which OS? We just release the latest stable version 4.2 yesterday, please download it and try it again.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Java Heap space error when trying to create metadata for a excel file

Hi Shong,
I'm running Windows XP SP3 and i have tried to get the latest version 4.2 and still recieving the same error. I have tried other excel files but still getting the same error. CSV files seem to be working fine tho.
Regards,
Gary