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
Issue:

Problem:

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)

Resolution: 

  1. Stop the Jaspersoft service
  2. Navigate to Jasersoft_home\webapps\reportservice\WEB-INF\classes\esapi\
  3. Look for Security.properties 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

Notes:

·         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.

Resolution:
Please Update This Required Field