Error when creating a custom report in CABI MYSQL database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When we are trying to create a new custom report with UIM Metrics Topic we receive an error like the one below: "An error occured while performing the previous request."

jasperserver.log shows:

2022-11-16T18:46:04,847 ERROR UimMetricsTopicLanguage,https-jsse-nio-443-exec-18:1109 - rtable tuple query failed! java.sql.SQLSyntaxErrorException: (conn=xxxxxx) Incorrect parameter count in the call to native function 'isnull'

Caused by: java.sql.SQLException: Incorrect parameter count in the call to native function 'isnull'
Query is: select distinct isnull(sqd.v_table,sqd.r_table) as v_table
from S_QOS_DATA sqd
       join cm_configuration_item_metric ccim
               on sqd.ci_metric_id = ccim.ci_metric_id
               and ccim.ci_metric_type in ('1.5:1')
       join cm_configuration_item_metric_definition ccimd on ccim.ci_metric_type = ccimd.met_type
       join cm_configuration_item cci on ccim.ci_id = cci.ci_id
       join cm_device cd on cci.dev_id = cd.dev_id
       join cm_computer_system ccs on cd.cs_id = ccs.cs_id
               and ccs.cs_id in (select distinct cs_id from CM_GROUP_MEMBER where grp_id = 6)
       join cm_group_member cgm on ccs.cs_id = cgm.cs_id and cgm.grp_id = 6
       join s_qos_snapshot sqs on sqd.table_id = sqs.table_id and sqs.sampletime >= DATE_ADD(NOW(), INTERVAL -1 HOUR)
where sqd.qos IN ('QOS_CPU_USAGE')
        at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:153)

 

Environment

Release : 20.4 CU4
Database MySQL 5.7 Percona
cabi version 8.00 
uim_core_dashboards_pack is 2.51

Resolution

Please copy  uim_core_dashboards_utils.jar (attached to the KB) and then paste it in Nimsoft\\probes\\service\\wasp\\webapps\\cabijs\\WEB-INF\\lib of the Cabi robot then restart the wasp and Cabi probes

The fix will be included in the UIM 20.4 CU6