UIM - OC metric view display empty page after selecting disk metrics

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When you want to monitor disks statistics for the robot, and create a new view in the "metric view" section (for a specific robot in UIM inventory), after selecting the disks metrics and accepting the view nothing is displayed (blank page) - developer tools show the following error: 

Request URL:
https://<hostname>/operatorconsole_portlet/api/v1/metrics/chart?metricTypeId=1.1:99&csIds=112&minutes=720&timezone=Europe/Warsaw&endDateEpoch=1669379700000&aggregationInterval=60&aggregateFunction=AVG&ciNames=C:%5C,D:%5C,E:%5C,F:%5C
Request Method:
GET
Status Code:
500 Internal Server Error
 
Remote Address:
IP_ADDRESS:80
 
{statusCode: 500, statusPhrase: "Internal Server Error",…}
error
: 
"java.sql.SQLSyntaxErrorException: (conn=245052) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'D:\\','E:\\','F:\\')' at line 13"
statusCode
: 
500
statusPhrase
: 
"Internal Server Error"

 

HTTP query parameter : 

metricTypeId:
1.1:3
csIds:
112
minutes:
720
timezone:
Europe/Berlin
endDateEpoch:
1669379700000
aggregationInterval:
60
aggregateFunction:
AVG
 
ciNames:
C:\,D:\,E:\,F:\

 

Environment

Release : 20.4 CU5

This issue was diagnosed with the MySQL server only.

Cause

Code defect 

Resolution

Issue fixed in UIM CU6 / OC CU6 and later.