Getting OutOfMemory error while loading an excel file of 18 MB size.

[Anonymous]

exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded  

Getting the above error

Job Design is tFileInputExcel->tMap->tDBOutput

Any resolutions?

[MaheswarReddy · Accepted solution]

Hi 

Did you try increasing the memory size ?

Run window --> Advanced settings --> Enable (Use specific JVM arguments ) and give 1 GB as minimum . and 5 GB as maximum and run the job again.

Thanks,

Mahesh

[Anonymous]

Yes, I did

But the problem still persists

[MaheswarReddy]

Can you attach the screenshots of your job ?

[Anonymous]

I increased to 10 GB and it worked.

Thanks for your suggestion.

[Anonymous]

Hello,

Here is a related community knowledge:https://community.talend.com/t5/Migration-Configuration-and/OutOfMemory-Exception/ta-p/21669 

Hope it will be helpful for your subsequent work.

Best regards

Sabirna