Ad Hoc Row Limit

Summary

[toc on_off::hide=1]

When Ad Hoc Dataset contains more than 200,000 rows, exception is thrown: "The query for the report has been canceled because it returned more than 200000 rows. Modify the report to reduce the number of rows"

Causes

For performance reasons Ad Hoc Dataset Row Limit is set to 200000 by default.

Resolutions

There are two ways to change this value: temporary and permanent.

Temporary Solution (reset on server restart)

NB: on server restart the value would revert to default.

• Login as Superuser.
• Go to Manage -> Ad Hoc Settings
• Set "Ad Hoc Dataset Row Limit" to desired value.

Permanent Solution

You can permanently increase this limit by editing applicationContext-semanticLayer.xml file under WEB-INF directory and change the settings to a larger limit to accommodate your needs:

• go to the bottom of the file and locate the bean property

• change the limit value for the setting bellow (default setting is 200000):

• save the change, restart your server and run the report again.

11:21, 6 December 2011 (UTC)