Jasper Reports - UIM Metrics Topic Ad Hoc View error

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When I'm trying to create an Ad Hoc view using "UIM Metrics Topic" data, I get the following error: "An error has occurred. Please contact your system administrator. (6632)".

At Tomcat stdout file in the Jasper machine, we can see the next entries:

2018-08-07 11:37:25,333 ERROR Validator,http-apr-8080-exec-7:499 - Invalid SQL:An error has occurred. Please contact your system administrator. (6632), SQL: SELECT DISTINCT CASE WHEN UPPER('jdbc:tibcosoftware:sqlserver://10.1.2.20:1433;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1000;DATABASENAME=CA_UIM;CRYPTOPROTOCOLVERSION=;MAXPOOLEDSTATEMENTS=0;PROGRAMID=;ENABLECANCELTIMEOUT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;CODEPAGEOVERRIDE=;DATETIMEINPUTPARAMETERTYPE=auto;CONNECTIONRETRYCOUNT=5;ENABLEBULKLOAD=false;BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;HOSTPROCESS=0;FAILOVERPRECONNECT=false;USESERVERSIDEUPDATABLECURSORS=false;SECURERANDOMALGORITHM=;ALWAYSREPORTTRIGGERRESULTS=false;REGISTERSTATEMENTPOOLMONITORMBEAN=false;RESULTSETMETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;FAILOVERGRANULARITY=nonAtomic;HOSTNAMEINCERTIFICATE=;STRINGINPUTPARAMETERTYPE=nvarchar;SNAPSHOTSERIALIZABLE=false;APPLICATIONNAME=;JAVADOUBLETOSTRING=false;LOADLIBRARYPATH=;IMPORTSTATEMENTPOOL=;PROGRAMNAME=;DATETIMEOUTPUTPARAMETERTYPE=auto;NETADDRESS=000000000000;ALTERNATESERVERS=;APPLICATIONINTENT=READWRITE;DESCRIBEINPUTPARAMETERS=noDescribe;STRINGOUTPUTPARAMETERTYPE=nvarchar;WSID=;BULKLOADOPTIONS=2;TRUNCATEFRACTIONALSECONDS=true;RANDOMGENERATOR=SECURERANDOM;ENCRYPTIONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTORE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHENTICATIONMETHOD=auto;LOGINTIMEOUT=0;FETCHTWFSASTIME=false;LONGDATACACHESIZE=2048;LOADBALANCING=false;TRANSACTIONMODE=implicit;DESCRIBEOUTPUTPARAMETERS=noDescribe;SUPPRESSCONNECTIONWARNINGS=false;WORKAROUNDS=0;INSENSITIVERESULTSETBUFFERSIZE=2048;PACKETSIZE=-1;CLIENTHOSTNAME=;DEFAULTSCALE=4;XMLDESCRIBETYPE=;FETCHTSWTZASTIMESTAMP=false;SELECTMETHOD=direct, UserName=dbo, SQLServer') LIKE '%ORACLE%' THEN 'CM_CONFIGURATION_ITEM_METRIC_D' ELSE 'CM_CONFIGURATION_ITEM_METRIC_DEFINITION' END AS ccimd FROM s_qos_data 2018-08-07 11:37:25,344

ERROR errorPage_jsp,http-apr-8080-exec-7:298 - JSException:

Environment

Release:
Component: UIMCBI

Resolution

Follow the next steps:

• Verify that cabi_external probe is at least 3.30 release, if not ,  deploy the latest one.
• Stop the CABI ( jasper ) service 
• Edit ...\cabijs\WEB-INF\classes\esapi\security-config.properties file 
• Change line: 

security.validation.sql.on=true 

to 

security.validation.sql.on=false 

• Restart the CABI ( jasper ) service

Edit security-config.properties file Change line: security.validation.sql.on=true to security.validation.sql.on=false - Restart CABI ( jasper ) service