Getting an Internal Server Error in an Adhoc view/ Jaspersoft report in Advanced Reporting/Jaspersoft in Clarity
Error in Jasperserver.log:ERROR JRFillSubreport,pool-6-thread-957:879 [.....|....] - Fill 1: exception
Release : All Supported releases
Run the report setting parameters to reduce the number of pages below the limit.
Current default limitations:
For custom reports, one way to avoid this issue is to make a parameter mandatory (i.e. to select just one project rather than all of them).
For Ad Hoc Views, see the below excerpt from: Ad Hoc Views and Custom Report Development.
The maximum number of report pages that you can generate is 500 pages for both scheduled and unscheduled reports. The limit applies to all reports and ad-hoc views that are exported using paginated options such as Excel (Paginated) and XLSX (Paginated). The limit is not applicable to the ad-hoc views exported using non-paginated export options such as Excel and XLSX. The following image shows the export options that have a limit to the maximum number of pages that are exported. this is working as expected, as the limit has been reached for the maximum amount of pages.