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

Four Stars

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

Hi All.
One Table has 4,5 million rows.
I am Exporting those rows to another table and I am getting this error message.
"Exception in thread "main" java.lang.OutOfMemoryError: Java heap space"

I read many discussions about that same problem and I applied these configurations: 

+ For the cursor in the input component: 100000

+ For the advanced settings of the execution tab for the JVM parameters: -Xms1024  //  -Xmx1024  //  -XX:-UseGCOverheadLimit

 

Please find attached the design of my job.

 

I want to know if it's an optimization issue ( so I have to change the design of the job, ...which it's not very possible due to business model matters) or it's a classic memory issue (so I have just to increase the memory for JVM).

 

I'm on Talend Open Studio for Data Integration 6.5.1.

 

I have to wait 2 hours for each test... it's a little bit hard lol


Thanks for your time and answers! 
Hedi

Forteen Stars TRF
Forteen Stars

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

Did you tried to change Xms value to 2048 or 4096 or more?


TRF
Four Stars

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

Hello TRF! Thank you for your answer and attention! 

 

Yes I did it once... -Xms2048, but with a -Xmx245 (not sure about the value and the role of this parameter)

 

Hedi