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

One Star VSD
One Star

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

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
Seventeen Stars

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

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.
One Star VSD
One Star

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

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