topic Re: java.sql.SQLException: GC overhead limit exceeded in Talend Studio

java.sql.SQLException: GC overhead limit exceeded

sekertu — Wed, 30 Sep 2020 13:32:17 GMT

Hi all,

I am trying to load data from production system to our DWH.

source table has 600.000 rows data.

but I had java.sql.SQLException: GC overhead limit exceeded error.

my computer has 32GB ram and I already increased the heap space.

would you please help me if you have an idea?

Thanks

Tugba

Re: java.sql.SQLException: GC overhead limit exceeded

root — Wed, 30 Sep 2020 15:41:25 GMT

Where did you increase the limit? This sounds like either the limit is not set correctly in the job. Please check the "Advanced Settings" and set parameters and let us know. Thanks.

Re: java.sql.SQLException: GC overhead limit exceeded

sekertu — Thu, 01 Oct 2020 11:21:26 GMT

Hi, thank you for your quick response.

I changed the heap space in TOS_DI-win-x86_64.ini file. It didn't solve my problem. but after your answer I increased the heap space in the job/Run/Advanced settings part. it worked, my problem was SOLVED!!!

Thank you so much

Tugba

Re: java.sql.SQLException: GC overhead limit exceeded

David_Beaty — Sun, 04 Oct 2020 09:14:46 GMT

Hi,

The problem is probably your tMap. Single click on the component and select the Advanced options. Try using a disk cache, you’ll need to give it a working/temp directory.

Thanks

David