My Oracle Support Banner

ORA-00001: unique constraint (NMS_ADMIN.SRS_LOG_PK) violated Error in JMService Log- Event Log Not Being Updated (Doc ID 2996204.1)

Last updated on JANUARY 08, 2024

Applies to:

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

Symptoms

On : 2.5.0.2.0 version, NMS Infrastructure

Event log is not being updated.  All user actions for events are not being logged into the event log.



ERRORin JMService log
-----------------------
/13/23 10:09:43: JMService 0x7f9654593700,ctp=0x65d3258,"JMLogger" *ERROR* - sql failed:
  result=-1 error='ORA-00001: unique constraint (NMS_ADMIN.SRS_LOG_PK) violated
  sql=[INSERT INTO srs_log(numb, action, who, when, event_cls, event_idx, from_device_cls, from_device_idx, to_device_cls, to_device_idx, state_trigger, from_state_key, to_state_key, from_name, to_name, ncg, alarm_cls, alarm_idx, old_time, new_time, new_event_cls, new_event_idx, inc_numb, storm_name, storm_date, reason)




Changes

 This is a new NMS installed system.

Cause

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
Symptoms
Changes
Cause
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.