Excel Output Java heap out of memory error

[Rajender]

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

[Shepherd69]

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

 And/or use a csv file instead of excel.

njmcdirect

[Anonymous]

Hi

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

[Rajender]

Hi

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