DX Infrastructure Manager

Expand all | Collapse all

Jasper Reports - UIM Metrics Topic Ad Hoc View error

  • 1.  Jasper Reports - UIM Metrics Topic Ad Hoc View error

    Posted 08-07-2018 10:58 AM

    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!



  • 2.  Re: Jasper Reports - UIM Metrics Topic Ad Hoc View error

    Posted 08-07-2018 11:08 AM

    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



  • 3.  Re: Jasper Reports - UIM Metrics Topic Ad Hoc View error

    Posted 08-07-2018 11:15 AM

    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!



  • 4.  Re: Jasper Reports - UIM Metrics Topic Ad Hoc View error

    Posted 08-07-2018 11:19 AM

    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