adop phase=cleanup cleanup_mode=full Failed

[syedahmed]

Hi Emran, unable to start prepare phase then tried to cleanup mode full getting the following error Statement Handler Error Code: 12991 Statement Handler Error Message: ORA-12991: column is referenced in a multi-column constraint ORA-06512: at "APPS.AD_ZD", line 64 ORA-06512: at "APPS.AD_ZD", line 48 ORA-06512: at "APPS.AD_ZD_TABLE", line 28 ORA-06512: at "APPS.AD_ZD_TABLE", line 2701 ORA-06512: at "APPS.AD_ZD_TABLE", line 2701 ORA-06512: at "APPS.AD_ZD", line 1152 ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute) Reference of statement-handler is valid, not attempting database reconnect. Failed to execute SQL statement: begin execute immediate 'alter session set DDL_LOCK_TIMEOUT = 600'; ad_zd.cleanup('FULL'); end; Error Message: ORA-12991: column is referenced in a multi-column constraint ORA-06512: at "APPS.AD_ZD", line 64 ORA-06512: at "APPS.AD_ZD", line 48 ORA-06512: at "APPS.AD_ZD_TABLE", line 28 ORA-06512: at "APPS.AD_ZD_TABLE", line 2701 ORA-06512: at "APPS.AD_ZD_TABLE", line 2701 ORA-06512: at "APPS.AD_ZD", line 1152 ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute) [UNEXPECTED]Error occurred calling cleanup PL/SQL API. [UNEXPECTED]Cleanup phase has failed.

[ErmanArslansOracleBlog]

ORA-12991 error occurs if a multi-column constraint is being dropped, for multi-column constraints you can't just drop one of them otherwise you will get this error.

Ref:

ORA-12991: column is referenced in a multi-column constraint
12991. 00000 - "column is referenced in a multi-column constraint"
*Cause: An attempt was made to drop a column referenced by some
constraints.
*Action: Drop all constraints referencing the dropped column or
specify CASCADE CONSTRAINTS in statement.

Action plan

You need to find exactly which table and constraint are causing the hang-up.
Once you identify the table and the constraint, you may manually drop it , only if it is a custom table and if it is safe for you! if it is a standard table, we need to do a Oracle Support search about it.
Cleanup full may be helpful in all the cases. Probably a metadata issue is there..