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

Shasha · 2021-01-18T11:11:49+00:00

There was an error rendering this rich post.

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

Thanks

Shasha

Anyone?

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