Limit exceed error - Excel file to Oracle table

[stan1609735726]

I am trying to load an excel file with large number of records about 85000 records and i am getting this error:

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded

Could you please advise how to load this many excel record to table

[Prakhar1]

-Xmx​8192M

-XX:-UseGCOverheadLimit

-Xms4096​M

Add above jvm parameters in your job.​

[stan1609735726]

Thank you for your reply. Where will I add those parameters? sorry I am new to Talend, Below are the component for my loading job.

[Prakhar1]

Go to Run -> Advance setting -> Click on "use specific jvm parameters -> Change the values there and Click on New if you want to add new JVM parameters.

[stan1609735726]

Thank you very much. It worked.

Another question, if I also need to write large number of records back to another excel file as well and experiencing same issue, exceeding the limit.

Is it possible thru any similar parameters ?

[Prakhar1]

Try with similar jvm parameters. It should work, if not please send a screenshot of error here​