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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download