topic Re: Excel Output Java heap out of memory error in Talend Studio

Excel Output Java heap out of memory error

Rajender — Sun, 08 May 2022 09:28:56 GMT

Hi there,

I have a Excel report of size 16 MB which has multiple sheets. I have to update one sheet in Excel. This sheet has information and header set upto 14 rows.

Following is my job desing.

tfileExcelWorkbookOpen -->> tFileDelimitted -->> tMap -->> TFileExcelSheetOutput -->. tFileExcelWorkbookSave

In my Job advance set up, Java memory is set upto 8GB.

While running the job, I am getting OutOfMemory exception.

Please suggest, Is there any way to handle this.

Best Regards,

Rajender Prasad

Re: Excel Output Java heap out of memory error

Shepherd69 — Mon, 09 May 2022 07:20:45 GMT

Re-use exsiting java objects, instead of creating new ones each iteration.

And/or use a csv file instead of excel.

njmcdirect

Re: Excel Output Java heap out of memory error

Anonymous — Mon, 09 May 2022 09:24:51 GMT

You are using the custom component shared by jlolling, can you share a screenshot to show the basic setting of TFileExcelSheetOutput? How about the performance with official component tFileOutputExcel?

Regards

Shong

Re: Excel Output Java heap out of memory error

Rajender — Thu, 19 May 2022 13:56:48 GMT

Thank you

I was using tFileOUtputExcel component. Although I was processing only 252 records but getting Java heap size issue.

I have increase memory upto 12GB, even then I am getting heap size issue.

Job is not getting completed for 30mins, finally job is killed.

Best Regards,

Rajender Prasad