Exporting large report using new Excel format file causes JasperServer to melt down.

[spierepf]

Greetings,

We're using JasperServer 4.5 and we're having a problem with users trying to export huge (200K rows) reports using Excel's xlsx format.

What happens is that a user will run a huge report. The report runs fine and the results are returned in the browser, but when the user attempts to export the result to xlsx, the server eats up all its available RAM and hangs itself.

We're wondering if there is some way to have the xlsx exporter behave itself, and either generate the report as requested, or have it fail gracefully with some kind of message, or at least not bring the tomcat server to its knees.

Cheers,

Peter.

[cjasper]

I think I have faced this issue earlier .for me it was because of subreports.