Import from MSSQL and load it in excel file

Eight 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.


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

All Replies
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