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
Fifteen Stars TRF
Fifteen 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
Fifteen Stars TRF
Fifteen 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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog