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

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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: 

1. The Domain Query Text Area has a default character limit of 50k.
2. If you query increase more than 50k it will throw an error.
3. The error message is generic and in Jaspersoft Server logs you will see error with below message {maxLength=50000, isBlacklist=false]
4. 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.