When Generating Jasper Excel output with large set of data,following issue iam facing

1.Heap space memory Issue

2.Taking more time in Hours

3.Output is not generted and get hanged

4.if Generated,generating in multisheets(i Need in single sheet)

Expecting Some Solutions for all this

Thank You

kenil.m's picture
Joined: Mar 22 2023 - 10:25pm
Last seen: 3 weeks 4 days ago

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

mrajkuma - 4 months 3 weeks ago

2 Answers:

There isn't enough memory allocated to the JVM to process that much data; jasper is failing because it doesn't have the resources needed to fill that report. 

If this is happening on your local machine, you can increase the memory available to the JVM, but that will be limited by the system you're using (the actual memory available).


If this is happening on JasperServer, you have several options available to address this, but the most straight forward is again to increase the memory available. You can find documentation on the Apache Tomcat website, and here's an example that demonstrates how that's done


If increasing the memory available the JVM isn't an option, you can look into virtualizers, which can help segment the amount of memory in use - if so just post back, that's a bit more involved than just bumping up the memory settings - 


darth_fader's picture
Joined: Mar 7 2010 - 9:45pm
Last seen: 3 months 2 weeks ago


This memory issue you can resolve by settings of JVM options with increasing the memory as mentioned in section 4.1.1 in the below document:


I hope this will help you, please let us know if you have any queries. thanks!

Swapnil Pawar's picture
Joined: Apr 22 2021 - 5:44am
Last seen: 4 days 2 hours ago