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 JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.0 and laterInformation 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
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 |