Six Stars

Not Loading excel with large size

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

3 REPLIES
Moderator

Re: Not Loading excel with large size

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Not Loading excel with large size

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

Moderator

Re: Not Loading excel with large size

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.