Export to Excel Fails due to jsexception.QueryExecutionTooManyRowsException

[kumar110580]

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. 

[anish.rai]

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.

[sam.gaid]

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!

[Tom C]

• JasperReports Server (JRS) ad hoc views and reports feature an Ad Hoc Dataset Row Limit to prevent inadvertent retrieval of excessively large datasets during experimentation in the JRS Ad Hoc designer. The default limit is 200,000 rows. Exceeding this limit results in a 'jsexception.QueryExecutionTooManyRowsException' error. To process larger datasets, a superuser must increase the Ad Hoc Dataset Row Limit via the JRS 9.0 web UI under Manage > Server Settings > Ad Hoc Settings. This adjustment addresses the use case scenario for sam.gaid.
• Regarding kumar110580's issue, where the report generates successfully but encounters the row limit error during Excel export, it is likely the user initially viewed sample data (1,000 rows) within the Ad Hoc Designer web UI. When exporting to Excel from this interface, the ad hoc view generates a temporary report using the default template, and then executes the full data query, which surpasses the 100,000 row limit.