My Oracle Support Banner

Upgrade 8.0->8.1 - ORA-00001: Unique Constraint Issue In CMN_PROFILE_ENTERPRISE (Doc ID 2419187.1)

Last updated on JULY 13, 2023

Applies to:

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

Goal

Oracle Life Sciences Argus Safety Version 8.1

Recently upgraded from 6.0.7.8 -> 8.1.1

While upgrading from 8.0 ->8.1, getting following errors in the upgrade log.

However during the upgrade these errors are not prompted on the Upgrade wizard. They are only recorded in the upgrade log

FAILED: ORA-00001: unique constraint (ARGUS_APP.PK_CMN_PROFILE_ENTERPRISE) violated

INSERT INTO cmn_profile_enterprise ( SECTION, KEY, VALUE, DELETED, TREE_NAME, KEY_TYPE, KEY_LABEL, KEY_OPTIONS, LINK_TABLE, LINK_COLUMN_SEQ, LINK_COLUMN_DISPLAY, HELP_TEXT_TREE_NAME, NEXT_KEY, SORT_ORDER )
VALUES ( 'DATABASE', 'DEBUG_PKG_PSR_JPER_RPT', '0', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL )
FAILED: ORA-00001: unique constraint (ARGUS_APP.PK_CMN_PROFILE_ENTERPRISE) violated
 

 

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


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