[resolved] java.lang.OutOfMemoryError: Java heap space

[Soumya_M]

Hi all,

My talend job looks like - tPostgresqlInput - tMap - tPostgresqlOutput

the input table has 6mn+ records, I need to extract 2 columns from input table and send it to the output table

when i run the job, I'm getting error like -

Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "Thread-0"

Exception in thread "main" java.lang.OutOfMemoryError: Java heap space

Even though I've set JVM settings for -Xms and Xmx as 4096m and 8192m respectively

Can anyone please help me in rectifying this error

[Anonymous · Accepted solution]

Hello,

Please have a look at this KB article about:

https://community.talend.com/s/article/OutOfMemory-Exception-WmtmQ

Hope it will be helpful for your use case.

Best regards

Sabrina

[Amanda2569]

The solution worked for me thanks to the community and the members for the solution.

[Anonymous]

Hello,

Great it helps.

Feel free to let us know if there is any further help we can give.

Best regards

Sabrina

[Soumya_M]

Thank you!!

that was helpful 🙂

[Anonymous]

Hello,

I've seen this error many times when using existing connection with Auto commit enabled.

Try the following:

• Make sure fetch size is enabled under the advanced settings.
• Use built in connection or existing connection without auto commit.