A single custom report is not working after upgrading the environment. Other custom reports are running fine. Out of the Box (OOTB) reports are running successfully.
Error Message:
Error Details The server has encountered an error. Please excuse the inconvenience.
Error Message An error has occurred. Please contact your system administrator. (6632)
Checking the Jasperserver.log, an error similar to the below displays:
com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) at com.jaspersoft.jasperserver.api.security.validators.ValidatorImpl.validateSQL(ValidatorImpl.java:394)
Release: All Supported Releases
Component: Clarity Jaspersoft
Based on the 6632 error, this likely indicates invalid underlying SQL queries
Example: the semicolon (;) character is forbidden in queries by an input validation rule on the server with the intent to prevent malicious attacks against the server to filtrate data: Configuring Input Validation
Contact your Report Developer to edit the custom report in Studio and fix the SQL validation error by replacing the ';' character with a comma character ','.