Java Memory Error on Excel File

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.


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.

All Replies
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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads