topic Re: Not Loading excel with large size in Talend Studio

Not Loading excel with large size

Anonymous — Mon, 07 May 2018 14:52:57 GMT

Hi,everyone.
I have a size 11.9 MB excel and talend won't load and will crash in the middle of it.

I already changed my TOS_DI-win-x86_64.ini settings to increase talend memory, but it still the same.

current settings:

-vmargs
-Xms1000m
-Xmx2000m
-Dfile.encoding=UTF-8
-Dosgi.requiredJavaVersion=1.8
-XX:+UseG1GC
-XX:+UseStringDeduplication

Re: Not Loading excel with large size

Anonymous — Thu, 10 May 2018 10:05:11 GMT

Hello,

Are you getting "OutofMemory" error when try to load a large size of excel? Have you tried to allocate more memory to your active job instead of the whole studio?

Here is a KB article about:https://community.talend.com/t5/Migration-Configuration-and/OutOfMemory-Exception/ta-p/21669

Best regards

Sabrina

Re: Not Loading excel with large size

Anonymous — Thu, 10 May 2018 15:18:49 GMT

I ended up breaking my excel sheet into multiple sheets, but will try this soon.

Re: Not Loading excel with large size

Anonymous — Fri, 11 May 2018 08:40:17 GMT

Hello,

Feel free to let us know if this solution is OK with you.

Best regards

Sabrina