Not Loading excel with large size

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina