search cancel

Clarity:Jaspersoft Query limits on the "Ad Hoc Options" page via Jaspersoft Console


Article ID: 33277


Updated On:


Clarity PPM On Premise



How to Set Query limits on the "Ad Hoc Options" page via Jaspersoft Console.


  1. To enable the same you need to login to Jaspersoft Console using superuser account
  2. Navigate to Manage tab and Click on Server Settings
  3. In the Server Settings Click on Ad Hoc Settings
  4. Under Ad Hoc Settings check the options under Query Limits







This is an how to information and not a defect 


Component: PPMJSP



Additional Information: 

  • This is an administrative web page available on Jaspersoft Console under "Manage -> Ad Hoc Options." There are two parameters there that are worth testing for possible performance gains:
  •  Ad Hoc Filter List of Values Row Limit - The maximum number of items that should be displayed in the Condition Editor when a user defines filters for and Hoc report that is based on a Domain. If this limit is exceeded when users define filters, Jasperserver displays a message to that effect. Setting this to a lower value can improve performance.
  • Ad Hoc Dataset Row Limit - The maximum number of rows that an Ad Hoc report can return. JasperServer truncates the data when the limit is reached.
  • Setting this to a lower number may improve performance, but your reports may not reflect the full data set.
  • If the limit is exhausted you will get an error on the page and even while exporting the same 


  • The Ad Hoc options must be set after every restart of JasperServer. They are not preserved between restarts. See the slConfig bean in WEB- INF/applicationContext-semanticLayer.xml to set these permanently.
  • The new query limits do not apply to reports that you saved before modifying the settings. To apply the new query limits to existing ad Hoc reports, open the reports for editing in the Ad Hoc Designer and save them again.
  • This setting is already optimized for SAAS System so no modifications are required



1558699081307000033277_sktwi1f5rjvs16oiw.jpeg get_app