After 12.1.3 to 12.2.3 Upgrade ADOP Full Cleanup Phase Errors with 'ORA-02449: unique/primary keys in table referenced by foreign keys' in Adopscanlog

(Doc ID 2086044.1)

Last updated on JANUARY 19, 2016

Applies to:

Oracle Applications DBA - Version 12.2.3 to 12.2.5 [Release 12.2Cloud to 12.2]
Information in this document applies to any platform.

Symptoms

After 12.1.3 to 12.2.3 upgrade, ADOP full cleanup phase shows the following errors in the console (and logfile) for "adopscanlog -latest=yes":

ERROR
-----------------------
Calling cleanup in FULL mode...
Log: @ADZDSHOWLOG.sql "2015/02/02 14:21:07"
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_RES"
[ERROR] Error while dropping table ABM.ABM_MLS_RES: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_RE_DS"
[ERROR] Error while dropping table ABM.ABM_MLS_RE_DS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_PERIODS"
[ERROR] Error while dropping table ABM.ABM_PERIODS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_BORS"
[ERROR] Error while dropping table ABM.ABM_BORS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_RESOURCES"
[ERROR] Error while dropping table ABM.ABM_MLS_RESOURCES: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_TAG_SETS"
[ERROR] Error while dropping table ABM.ABM_TAG_SETS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_CURRS"
[ERROR] Error while dropping table ABM.ABM_CURRS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MDLS"
[ERROR] Error while dropping table ABM.ABM_MDLS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS"
[ERROR] Error while dropping table ABM.ABM_MLS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_SEC_PROFL_TYPES"
[ERROR] Error while dropping table ABM.ABM_SEC_PROFL_TYPES:
ORA-02449: unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_IMP_TAG_SETS"
[ERROR] Error while dropping table ABM.ABM_IMP_TAG_SETS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_ACTS"
[ERROR] Error while dropping table ABM.ABM_MLS_ACTS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_BOR_TYPES"
[ERROR] Error while dropping table ABM.ABM_BOR_TYPES: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_DS"
[ERROR] Error while dropping table ABM.ABM_MLS_DS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_RE_DS"
[ERROR] Error while dropping table ABM.ABM_RE_DS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_RES"
[ERROR] Error while dropping table ABM.ABM_RES: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_RESOURCES"
[ERROR] Error while dropping table ABM.ABM_RESOURCES: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_TAGS"
[ERROR] Error while dropping table ABM.ABM_TAGS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_CURRS"
[ERROR] Error while dropping table ABM.ABM_CURRS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MDLS"
[ERROR] Error while dropping table ABM.ABM_MDLS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS"
[ERROR] Error while dropping table ABM.ABM_MLS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_ACTS"
[ERROR] Error while dropping table ABM.ABM_MLS_ACTS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_DS"
[ERROR] Error while dropping table ABM.ABM_MLS_DS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_RES"
[ERROR] Error while dropping table ABM.ABM_MLS_RES: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_RESOURCES"
[ERROR] Error while dropping table ABM.ABM_MLS_RESOURCES: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_MLS_RE_DS"
[ERROR] Error while dropping table ABM.ABM_MLS_RE_DS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_RES"
[ERROR] Error while dropping table ABM.ABM_RES: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_TAGS"
[ERROR] Error while dropping table ABM.ABM_TAGS: ORA-02449:
unique/primary keys in table referenced by foreign keys
[ERROR] ERROR: ORA-02449: unique/primary keys in table referenced by
foreign keys, SQL: drop TABLE ABM."ABM_TAG_SETS"
[ERROR] Error while dropping table ABM.ABM_TAG_SETS: ORA-02449:
unique/primary keys in table referenced by foreign keys

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply 12.2.3 upgrade <Patch 17020683>.
2. Execute "adopscanlog -latest=yes".

Changes

Installed <Patch 17020683> during the 12.1.3 - 12.2.3 upgrade.

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