uimapi - ORA-01878: specified field not found in datetime or interval after DST change - oracle 12c - after 2022 DST change

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

uimapi returns a 500 errors when we use a time range for metrics

Environment

Release : 20.4

Component : UIM - API

Resolution

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' ;