Unique Constraint Violation on CONTROL_ZONE_TRANSACT_LOG_PK (Doc ID 2163577.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Oracle Utilities Network Management System - Version 1.11.0.4 to 1.12.0.3 [Release 1.11 to 1.12]
Information in this document applies to any platform.

Symptoms

Unique constraint violation on OMS.CONTROL_ZONE_TRANSACT_LOG_PK will be displayed in DBService periodically:

07/19 13:55:59: dbrdwr:40239286
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'INSERT INTO control_zone_transaction_log(transaction_id, action, from_user, to_user, who_initiated, zone_name, ncg_id, num_affected, time) values(:transaction_id, :msg_code, :from_user, :to_user, :who_initiated
, :zone_name, :ncg_id, :num_affected, :curr_time)'
ORA-00001: unique constraint (OMS.CONTROL_ZONE_TRANSACT_LOG_PK) violated
parse offset = 0
07/19 13:55:59: 0x55a,ctp=1101d4608,"sql" sql error: (INSERT INTO control_zone_transaction_log(transaction_id, action, from_user, to_user, who_initiated, zone_name, ncg_id, num_affected, time) values(:transaction_id, :msg_code, :from_us
er, :to_user, :who_initiated, :zone_name, :ncg_id, :num_affected, :curr_time)) from (1/83:36634854.0), result=-1 ORA-00001: unique constraint (OMS.CONTROL_ZONE_TRANSACT_LOG_PK) violated

 

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms