topic Memory heap error in Talend Studio

Memory heap error

Anonymous — Tue, 22 May 2018 09:12:47 GMT

I was getting memory heap error whenever i pull excel from input. I have resolved it somehow by changing the setting given in the attached JPG file. Now the performance is very slow. Please suggest the setting which i should have for a better performance. Is it everywhere the xmx and xmx should be in sync?

Re: Memory heap error

Anonymous — Tue, 22 May 2018 09:45:28 GMT

On top of that, the execution time is taking more than 45min to complete a simple job which has only InputExcel-->tLogRow

My machine is having 8GB RAM, i think this is enough but still the execution time is longer.

Re: Memory heap error

manodwhb — Wed, 23 May 2018 07:38:49 GMT

@samisyed80,yes ,you try with sync,even you might preocessing large file. memory you need to use based on size of files.

Re: Memory heap error

David_Beaty — Wed, 23 May 2018 10:50:38 GMT

There are many utils/java routines that allow you to extract all columns/rows from a sheet in an Excel spreadsheet into a CSV

You'll probably be better off doing this and then consuming the resulting CSV - especially if the Excel sheet is very large.