Export to Excel Fails due to jsexception.QueryExecutionTooManyRowsException

Dear All,

We are getting attached error while doing "Export to Excel".

We have set the adhoc rows limit to 100,000. Reports are getting generated properly and it gives above exception when we export it to Excel.

Looks like the actual number of rows exported to excel  from the database table exceeds 100,000

Appreciate recommendations to resolve this issue. Thanks in advance. 

kumar110580's picture
Joined: Apr 6 2023 - 7:17am
Last seen: 5 months 1 week 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.

arai_4 - 5 months 1 week ago

1 Answer:

I'm getting the same error. Is there any solution for that exception?

We're using the latest JasperSoft Version 8.2.0

Thank you in advance!

sam.gaid's picture
Joined: Aug 13 2022 - 7:10pm
Last seen: 1 month 6 days ago