Five Stars

Java Memory Error on Excel File

I am getting Java Memory Heap error when trying to read a big (130 MB) excel (xlsx) file during the meta-data creation step. My big file memory setting is "user mode" . When I change the setting to event based the file is read without any issues, though it took few seconds.

 

I tried increasing the JVM memory settings in the open studio ini file.

Any help/pointers on this topic is much appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: Java Memory Error on Excel File

Hello,

Please refer to this KB article:https://community.talend.com/t5/Migration-Configuration-and/Allocating-more-memory-to-Talend-Studio/....

Feel free to let us know if it works for 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.
1 REPLY
Moderator

Re: Java Memory Error on Excel File

Hello,

Please refer to this KB article:https://community.talend.com/t5/Migration-Configuration-and/Allocating-more-memory-to-Talend-Studio/....

Feel free to let us know if it works for 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.