Cannot use CABI UIM Metrics Topic on Shared CABI

Document ID : KB000117426
Last Modified Date : 11/10/2018
Show Technical Document Details
Issue:

The UIM Metrics topic with external cabi (cabi_external) and shared CABI server returns an error.
Server Error

An error has occurred. Please contact your system administrator. (6632)

CA UIM External CABI UIM Metrics Topic
Environment:
UIM 8.51
cabi_external 3.20
Shared CABI Server for Infrastructure Management 6.3
MS SQL, MySQL or Oracle Backend database for UIM
Cause:
/opt/CA/CABI/apache-tomcat/webapps/jasperserver-pro/WEB-INF/classes/esapi/security-config.properties
has a security constraint preventing some SQL syntax.
Resolution:

1- Backup the file:
/opt/CA/CABI/apache-tomcat/webapps/jasperserver-pro/WEB-INF/classes/esapi/security-config.properties

2- Edit the file:
/opt/CA/CABI/apache-tomcat/webapps/jasperserver-pro/WEB-INF/classes/esapi/security-config.properties
     
# Turns sql validation on or off.
security.validation.sql.on=true
User-added image
to 
 
# Turns sql validation on or off.
security.validation.sql.on=false

3- Restart the CABI Tomcat Service on Windows
    For Linux, run the command:
           /opt/CA/CABI/stopServers.sh
           /opt/CA/CABI/startServers.sh