Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError

Anonymous — Tue, 11 Dec 2012 14:47:48 GMT

Hi All,
I am using Talend DI 5.0.
I have created a job which extracts records from excel file to a MS - SQL server table.
The records in excel file is around 1.1 Lakhs.
Whenever I am running job I am getting fillowing error:
Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError: Java heap space
at ismartetl.etl_vbrk_0_1.ETL_VBRK.tFileInputExcel_1Process(ETL_VBRK.java:1324)
at ismartetl.etl_vbrk_0_1.ETL_VBRK.runJobInTOS(ETL_VBRK.java:1502)
at ismartetl.etl_vbrk_0_1.ETL_VBRK.main(ETL_VBRK.java:1370)
Caused by: java.lang.OutOfMemoryError: Java heap space
at org.apache.xmlbeans.impl.store.Locale$ScrubBuffer.<init>(Locale.java:1885)
at org.apache.xmlbeans.impl.store.Locale.getScrubBuffer(Locale.java:1904)
at org.apache.xmlbeans.impl.store.Xobj.getValueAsString(Xobj.java:1205)
at org.apache.xmlbeans.impl.store.Xobj.fetch_text(Xobj.java:1796)
at org.apache.xmlbeans.impl.values.XmlObjectBase.get_wscanon_text(XmlObjectBase.java:1332)
at org.apache.xmlbeans.impl.values.XmlObjectBase.check_dated(XmlObjectBase.java:1269)
at org.apache.xmlbeans.impl.values.JavaLongHolder.longValue(JavaLongHolder.java:53)
at org.apache.xmlbeans.impl.values.XmlObjectBase.getLongValue(XmlObjectBase.java:1502)
at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTRowImpl.getR(Unknown Source)
at org.apache.poi.xssf.usermodel.XSSFRow.getRowNum(XSSFRow.java:321)
at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:180)
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:147)
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:134)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:235)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:190)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:182)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:198)
at ismartetl.etl_vbrk_0_1.ETL_VBRK.tFileInputExcel_1Process(ETL_VBRK.java:690)
... 2 more
Job ETL_VBRK ended at 20:07 11/12/2012.

I have tried all the workarounds like increasing memory size in "TOS_DI-win32-x86.ini" file.
-vmargs-Xms512m-Xmx768m-XX:MaxPermSize=256m etc. but in vain.
Any help on this...?
My machine is having 3 GB Ram

Regards,
Vishal

Re: Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError

Anonymous — Tue, 11 Dec 2012 19:07:50 GMT

your mentioned memory preferences will only be used for the studio application but not for your job. Open the job, go to the view Job run and there to the register Advanced settings. Here you can specify the memory for your job.

Re: Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError

Anonymous — Wed, 12 Dec 2012 03:52:16 GMT

Hi,
Thanks for reply.
There is no such option as View -> Run ->Register Advance Settings.
Which version of Talend DI are you talking about ?
I am using Talend DI 5.0.
Would you please share the screen shot ?
Regards,
Vishal

topic Re: Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError in Talend Studio

Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError

Re: Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError

Re: Exception in thread "main" java.lang.Error: java.lang.OutOfMemoryError