topic Re: Limit exceed error - Excel file to Oracle table in Talend Studio

Limit exceed error - Excel file to Oracle table

stan1609735726 — Sat, 16 Nov 2024 00:29:02 GMT

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

Re: Limit exceed error - Excel file to Oracle table

Prakhar1 — Sat, 06 Mar 2021 08:31:28 GMT

-Xmx8192M

-XX:-UseGCOverheadLimit

-Xms4096M

Add above jvm parameters in your job.

Re: Limit exceed error - Excel file to Oracle table

stan1609735726 — Sun, 07 Mar 2021 04:01:17 GMT

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.

Re: Limit exceed error - Excel file to Oracle table

Prakhar1 — Sun, 07 Mar 2021 06:25:02 GMT

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.

Re: Limit exceed error - Excel file to Oracle table

stan1609735726 — Sun, 07 Mar 2021 08:08:11 GMT

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 ?

Re: Limit exceed error - Excel file to Oracle table

Prakhar1 — Sun, 07 Mar 2021 14:29:17 GMT

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