Jasper Reports - UIM Metrics Topic Ad Hoc View error

[Legacy User]

Hi everyone;

 

I have UIM 8.5.1 and lastest CABI Jasper version installed for Infrastructure Management in a lab environment. I have them correctly integrated. However, when I'm trying to create an Ad Hoc view using "UIM Metrics Topic" data, I get the following error:

 

If I go to the Tomcat stdout in the Jasper machine, I find the following 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:

 

Looks like a SQL query problem. Any idea what can this be? Every other data input works fine, here's a screen of "UIM Single Qos Topic":

 

But it's no use trying "UIM Metrics Topic", and I need to develop a series of views that should group metrics from different Qos targets.  

 

Any help would be much appreciated!

 

Regards!

[Shawn Walsh]

HI Francisco,

Are you using Oracle for your UIM database?

i see this problem also, when using Oracle as the UIM database.

You may want to open a support case.

Thanks,

Shawn

[Legacy User]

Hi Shawn;

 

I'm using SQL Server, it got my attention that at the end of the query it looks like (from what I get) it's trying to check if it's an oracle db. Strange thing is everything else works fine.

 

Thank you and regards!

[Shawn Walsh]

Sorry, I see the JDBC string now has sqlserver.  This may take some effort to debug. So, it may be worth opening a case.

Thanks Francisco