Java-heap issue while exporting a BIRT report in excel using v4.5

Shasha
Shasha Member
edited February 11, 2022 in Analytics #1

Hi Guys,


I am facing issue while exporting a BIRT report in excel using v4.5.

For a report with 40 columns and .5m records it consumes like 40gb of memory which eventually causes java heap error.


Now i know BIRT used spudsoft emitter for generating excel and I read that 

:bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/UserProperties has some data but lately this link is not getting opened.


I need to know how to set options.setOption("ExcelEmitter.ExtractMode", "TRUE");

Which version has this feature as I don't see this option as per below version of spudsoft

EclispeBIRT/org.eclipse.birt

https://github.com/EclispeBIRT/org.eclipse.birt/blob/master/engine/uk.co.spudsoft.birt.emitters.excel/src/uk/co/spudsoft/birt/emitters/excel/ExcelEmitter.java

Eclipse BIRT. Contribute to EclispeBIRT/org.eclipse.birt development by creating an account on GitHub.



Thanks

Shasha

Comments