uimapi returns a 500 errors when we use a time range for metrics
Release : 20.4
Component : UIM - API
Review the following to understand the issue further:
https://knowledge.broadcom.com/external/article?articleId=44786
To boil it down I did the following:
Either delete the data from the following hour on each RN/HN table (this is based on EST TZ):
delete from RN_QOS_DATA_0025 where sampletime >= '12-MAR-22 09.00.00.000000000 PM' and sampletime <= '12-MAR-22 10.00.00.000000000 PM' ;
or update the records of each table using the following query as an example:
update RN_QOS_DATA_0025 set sampletime = to_date('2022/03/12 22:00:01', 'yyyy/mm/dd hh24:mi:ss')
where sampletime >= '12-MAR-22 09.00.00.000000000 PM' and sampletime <= '12-MAR-22 10.00.00.000000000 PM' ;