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

Shasha

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

Shasha

Anyone?

Karen Weir

Hi @Shasha , I shared this internally to help get the advice you need.