My Oracle Support Banner

Unique Constraint Error On PK_CMN_VERSION_CONTROL During Database Upgrade From Argus 8.0 To 8.1 (Doc ID 2484145.1)

Last updated on MARCH 06, 2019

Applies to:

Oracle Argus Safety - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

While upgrading Argus Safety database from version 8.0 to 8.1, receive the following error.

\FactoryData81\argus_81_CMN_VERSION_CONTROL_data_change1.sql

insert into CMN_VERSION_CONTROL (TABLE_ID, DESCRIPTION, TABLE_NAME, TABLE_TYPE, COPY_ENTERPRISE) values (84501207, 'User Facility/Importer data from', 'CL_DATA_FROM', 1, 0)
FAILED: ORA-00001: unique constraint (ARGUS_APP.PK_CMN_VERSION_CONTROL) violated


Checking the CMN_VERSION_CONTROL table confirms a record with TABLE_ID= 84501207
SELECT TABLE_NAME,
 TABLE_ID
FROM CMN_VERSION_CONTROL
WHERE TABLE_ID = 84501207;


Changes

 

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.