Seven Stars

Import from MSSQL and load it in excel file

I am new to Talend. I have created a graph where the data is pulled from a MSsql server table and loading it in Excel but its throwing the below error

 

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

 

First i got this error when the setting was -Xms512m, then i changed it to -Xms1024m but it didn't made any impact. I have even tried it with -Xms2048m, in this scenario the TALEND application didn't start. After every changes, i have restarted my machine. Please help me solve it.

1 ACCEPTED SOLUTION

Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: Import from MSSQL and load it in excel file

Change Xmx for the job to 2048 or 4096 or more depending on your memory capacity.

TRF
1 REPLY
Forteen Stars TRF
Forteen Stars

Re: Import from MSSQL and load it in excel file

Change Xmx for the job to 2048 or 4096 or more depending on your memory capacity.

TRF