Error: java.lang.OutOfMemoryError: Java heap space

[Anonymous]

Hi, currently i am getting the out of memory error while loading the data into MYSQL server. Below the complete error. Request you to please help.

Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at org.talend.fileprocess.TOSDelimitedReader$ColumnBuffer4Joiner.saveCharInJoiner(TOSDelimitedReader.java:503)
at org.talend.fileprocess.TOSDelimitedReader.joinAndRead(TOSDelimitedReader.java:261)
at org.talend.fileprocess.TOSDelimitedReader.readRecord_SplitField(TOSDelimitedReader.java:148)
at org.talend.fileprocess.TOSDelimitedReader.readRecord(TOSDelimitedReader.java:125)
at org.talend.fileprocess.FileInputDelimited.nextRecord(FileInputDelimited.java:301)
[statistics] disconnected 

[Anonymous]

Hi,

   Could you please refer the below link for the resolution for similar issue?

https://community.talend.com/t5/Design-and-Development/resolved-java-lang-OutOfMemoryError-Java-heap...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi Nikhil, Thanks for your time... I tried the solution, but still it is not working. still i am getting the same error.... is there any other setting or issues that i can try....

Regards,

Shrinidhi DC

[Anonymous]

Hi Shrinidhi,

I faced this problem once while giving input file as excel so I used the below:

double click on your component, go to advanced settings, there is Generation mode. Select Less memory consumed for large file. 

If the above doesnt work you can increase the heap size by going to the run console. After you run the job when the job fails, go to advanced settings and select Use specific JVM arguments. Then you can increase the size instead of 1024, 2048 or 4096 etc.  Attaching a screenshot.

run.JPG

[Anonymous]

Hi Shrinidhi,

    Could you please share the job screenshot so that we will get more idea about the job flow? What is the input data volume and how much is the current memory parameters you have set?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂