Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
-Xmx8192M
-XX:-UseGCOverheadLimit
-Xms4096M
Add above jvm parameters in your job.
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.
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.
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 ?
Try with similar jvm parameters. It should work, if not please send a screenshot of error here