UIMAPI-ORA-01878: specified field not found in datetime or interval after 2022 DST change

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

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

Environment

• Release: 20.4
• Component: UIM - API
• Oracle 12c

Resolution

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