My Oracle Support Banner

DBService Log Getting Filled with Recurring Error "ORA-00001: unique constraint (NMS.DDS_ALARM_LOG_PK) violated" (Doc ID 2471140.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Network Management for Utilities - DMS - Version 1.12.0.3 and later
Oracle Utilities Network Management System - Version 1.12.0.3 and later
Information in this document applies to any platform.

Goal

What would cause the following error?

11/08/18 13:18:32: dbrdwr:29456
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'INSERT into dds_alarm_log(alarm_cls, alarm_idx, parent_alarm_cls, parent_alarm_idx, device_cls, device_idx, device, rti_alias, system_time, user_time, source, state, nominal, phase, attribute, attribute_unit, attribute_desc, quality, alarm_type, time_ack, who_ack, ncg, p_idx, feeder, limit, description, term_station, alarm_priority, external_id, active, silence, alarm_sender, op_count, is_alarm, job_idx) VALUES(:alarm_cls, :alarm_idx, :parent_alarm_cls, :parent_alarm_idx, :device_cls, :device_idx, :device, :rti_alias, to_date(:system_time, 'MM/DD/YYYY HH24:MI:SS'), to_date(:user_time, 'MM/DD/YYYY HH24:MI:SS'), :source, :state, :nominal, :phase, :attribute, :attribute_unit, :attribute_desc, :quality, :alarm_type, NULL, :who_ack, :ncg, :p_idx, :feeder, :limit, :description, :term_station, :alarm_priority, :external_id, :active, :silence, :alarm_sender, :op_count, :is_alarm, :job_idx) '
ORA-00001: unique constraint (NMS.DDS_ALARM_LOG_PK) violated


in DDService, this error message is seen.
11/08/18 14:18:22: DDService 0x7f50fe4fd700,ctp=0x834b168,"DDService::updateEvents" ::writeDb - DB write failed for [INSERT into dds_alarm_log(alarm_cls, alarm_idx, parent_alarm_cls, parent_alarm_idx, device_cls, device_idx, device, rti_alias, system_time, user_time, source, state, nominal, phase, attribute, attribute_unit, attribute_desc, quality, alarm_type, time_ack, who_ack, ncg, p_idx, feeder, limit, description, term_station, alarm_priority, external_id, active, silence, alarm_sender, op_count, is_alarm, job_idx) VALUES(:alarm_cls, :alarm_idx, :parent_alarm_cls, :parent_alarm_idx, :device_cls, :device_idx, :device, :rti_alias, to_date(:system_time, 'MM/DD/YYYY HH24:MI:SS'), to_date(:user_time, 'MM/DD/YYYY HH24:MI:SS'), :source, :state, :nominal, :phase, :attribute, :attribute_unit, :attribute_desc, :quality, :alarm_type, NULL, :who_ack, :ncg, :p_idx, :feeder, :limit, :description, :term_station, :alarm_priority, :external_id, :active, :silence, :alarm_sender, :op_count, :is_alarm, :job_idx) ]

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.