How to increase limitation on the 'Domain Query Text Area' via Domain Designer

Document ID : KB000067211
Last Modified Date : 06/03/2018
Show Technical Document Details


An Error has Occurred. Please contact your system administrator. (5321) comes when the large queries are entered on the "Domain Query Text Area" via Domain Designer.

Steps to Reproduce:

  1. Login to CA PPM --> Navigate to Advance Reporting
  2. Create a domain by writing a query under Derived Tables Tab
  3. In the Domain Query Text Area write a large query which has more than 50k Character

Expected Result: The query should be validated and domain should be created.

Actual Result: An Error has Occurred. Please contact your system administrator. (5321)


  1. Stop the Jaspersoft service
  2. Navigate to Jasersoft_home\webapps\reportservice\WEB-INF\classes\esapi\
  3. Look for file
  4. Find a line createdQuerySql=Alpha,ValidSQL,50000,true,createdQuerySql-Run_Report_context
  5. Change the ValidSQL,50000 to ValidSQL,100000
  6. Start the Jaspersoft service

 Additional Information: 

  • The Domain Query Text Area has a default character limit of 50k.
  • If you query increase more than 50k it will throw an error.
  • The error message is generic and in Jaspersoft Server logs you will see error with below message {maxLength=50000, isBlacklist=false]
  • Reference Jaspersoft Security Change Configuration


·         This setting is optimized for SaaS System, if you encounter any error while creating a domain using Domain Text Area. Please contact CA Technical Support.

Please Update This Required Field