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
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.
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
