Import from MSSQL and load it in excel file

Anonymous — Sat, 05 May 2018 12:05:49 GMT

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.

Re: Import from MSSQL and load it in excel file

TRF — Sat, 05 May 2018 12:20:59 GMT

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

topic Re: Import from MSSQL and load it in excel file in Talend Studio

Import from MSSQL and load it in excel file

Re: Import from MSSQL and load it in excel file