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)
Release : 20.4 CU4
Database MySQL 5.7 Percona
cabi version 8.00
uim_core_dashboards_pack is 2.51
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