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:\
Release : 20.4 CU5
This issue was diagnosed with the MySQL server only.
Code defect
Issue fixed in UIM CU6 / OC CU6 and later.