So I am currently running TOS 6.4.1 with JDK 8 and I struggle to open a 23 210 ko Excel File in my job.
I get the following message when I try to open the xls file:
Internal Error: An out of memory error has occurred. Consult the "Running Eclipse" section of the read me file information on preventing this kind of error in the future.
The thing is that I can't find this read me file... I'd like to apologize for asking those kind of questions but I am a complete beginner with Java, TOS and computer development.
Also, I think that maybe my JVM settings are responsible of the issue. They are the one displayed in the first screenshot (I've also written the same informations into the .ini file that you can see in the second picture).
My computer uses Windows 7 Pro, and runs 32GB DDR3 RAM.
Do you know where is my mistake and what should I set to my JVM to be able to open my Excel file?
Thank you for your answer.
Can you detail a bit more how can I use the second option to load Excel Files in my TOS job please?
Your solution worked great for me until step 3/4.
It allowed me to load the Excel File, but now I'm stuck in step 3 because my computer can't detect the scheme of the data file.
Any idea why? The JVM is not set correctly?
(If, by the way, you could explain or show me a link about the meaning of each line in the JVM setting panel, it would be great).
Thank you very much,
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema