When a JasperSoft Ad Hoc Dataset contains more than 200,000 rows, errors similar to the following are seen:
1. The query for the report has been canceled because it returned more than 200000 rows. Modify the report to reduce the number of rows
2. Exception calling JRDataSource.next() for query select top 200000.................
For performance reasons, the JasperSoft Ad Hoc Dataset Row Limit is set to 200000 by default
Service Management 17.x
All Supported Windows Operating Systems
There are two ways to change this value, temporary and permanent.
Temporary Solution (reset on server restart - the value would revert to default)
1. Login to JasperSoft as Superuser.
2. Go to Manage -> Ad Hoc Settings
3. Set "Ad Hoc Dataset Row Limit" to desired value.
1. Edit the file applicationContext-semanticLayer.xml file under the WEB-INF directory and change the settings to a larger limit
2. Near the bottom of the file, locate the bean property
3. Change the limit value for the setting bellow (default setting is 200000)
4. Save the change and restart JasperSoft server for the change to take effect