ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to disable SQL security validation in Unified Reports


Article ID: 34669


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) NIMSOFT PROBES



Certain queries will work in iReport but will not work in Unified Reports. ?This is due to Unified Reports performing a SQL security validation on the SQL code and rejecting certain SQL commands for security reasons. ?This helps to prevent tampering via malicious SQL embedded into the reports.

Checking the jasperserver.log file will reveal errors similar to the following error:
2015-10-19 13:31:59,397 ERROR Validator,pool-32-thread-2:493 - Invalid SQL:An error has occurred. Please contact your system administrator.?

The security checks can be disabled to allow more flexibility in the commands being used.


Log into the UMP server
Open in an editor.
On Windows systems, the default location will be?C:\Program Files (x86)\Nimsoft\probes\service\wasp\webapps\jasperserver-pro\WEB-INF\classes\esapi
On Linux systems, the default location will be /opt/nimsoft/probes/service/wasp/webapps/jasperserver-pro/WEB-INF/classes/esapi

Change true to false
Restart wasp


Component: CAUIM