Import from MSSQL and load it in excel file

[Anonymous]

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.

[TRF · Accepted solution]

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