[resolved] Unhandled event Loop Exception: Java Heap Space

[Anonymous]

Hi,
I have looked through the posts on the forums and nothing is working for me. I have even tried the talend website but nothing seems to work. I have tried increasing the memory in the .ini file and the Run/Debug section of the Talend Preferences but it's no fruition. My Excel file is 14,200 kb which is about 4 mb. Please provide assistance. 

https://community.talend.com/t5/Design-and-Development/resolved-Unhandled-event-loop-exception-Java-...

https://help.talend.com/search/all?query=Allocating+more+memory+to+Talend+Studio&content-lang=en-US



Thanks,

[JR1]

At first glance I noticed that you have modified the 32bit version of the ini file. I am assuming that you are also starting the Studio using TOS_DI-win32-x86.exe, correct? In simple terms, you will not be able to set Xmx to a value higher than 4GB and even this might be too much. If you have more than 4GB on your machine (which I highly recommend for Talend), use the 64bit version TOS_DI-win-x86_64.exe which will require a 64bit Java installed on your machine. I hope I got this right and that it helps.

Furthermore, it is not just the size of the input file that defines the used memory. Without knowing what you are trying to do, I cannot tell you why you reach your memory limits. Are you using e.g. lookups in large tables? This will certainly affect the memory consumption.

[Anonymous]

Hi Joe,
Thanks for responding. I'm fairly new to Talend and overall ETL. I have 16.0 gb machine and 64 bit system. I have been using the win32-x86 Application because that's the only one which works. The win-x86_64 Application shows me something I don't know how to fix. And my excel file is simple straightforward no formulas nor vlookups nothing of that sort. Any assistance provided will be greatly appreciated.
Thanks,

[JR1 · Accepted solution]

I believe you can fix the problem with the 64bit version if you install the 64bit Java JDK (current version is 1.8.0_101 - download it from Oracle directly). After that make sure to set the Windows environment variable JAVA_HOME to the directory where Java was installed (something like C:\Program Files\Java\jdk1.8.0_101) and add (!) the path C:\Program Files\Java\jdk1.8.0_101\bin to your PATH environment variable.

[Anonymous]

Hi Joe,
Thanks for the help. I was able to accomplish what you had suggested and now I'm running the win-x86_64 Application. I'm still using the 14,200kb Excel file and I'm getting a new error, Unhandled event look exception GC overhead limit exceeded. If it's a memory issue, should I increase the memory in the .ini configuration file or the Preferences -----> Talend ---------> Run/Debug memory?
Please advice, thanks for the assistance.

[Anonymous]

Hi Joe,
I was able to take care of the issue. Made some adjustments to the .ini file and everything worked out. Thanks again for your assistance.