ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 237887


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


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:

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 PM' and sampletime <= '12-MAR-22 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 PM' and sampletime <= '12-MAR-22 PM' ;