Unique constraint Error in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE

[Former Member]

Hello Gurus,

I am facing the below error during SPS stack upgrade in an ERP system.

in the phase DBCLONE.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CLONING ERRORS and RETURN CODE in DBCLONE06.QUT

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETGCLN CREATE TABLE "RFCDOC~" ("RFCLANG" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "RFCDEST" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "RFCDOC1" VARCHAR2 (000216) DEFAULT ' ' NOT NULL, "RFCDOC2" VARCHAR2 (000216) DEFAULT ' ' NOT NULL, "RFCDOC3" VARCHAR2 (000216) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 COMPRESS BASIC STORAGE (INITIAL 0000000256 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'RFCDOC~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "RFCDOC~0" ON "RFCDOC~" ("RFCLANG", "RFCDEST") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'RFCDOC~' AND INDEXNAME = '0'

3 ETGCLN insert /*+ APPEND */ into "RFCDOC~" (  "RFCLANG", "RFCDEST", "RFCDOC1", "RFCDOC2", "RFCDOC3" ) select  "RFCLANG", "RFCDEST", "RFCDOC1", "RFCDOC2", "RFCDOC3" from "RFCDOC"

1EETGCLN ORA-00001: unique constraint (UNKNOWN.obj#=541510) violated

1EETGCLN RFCDOC

1EETGCLN Error copying table data

=================

SQL> desc sapsr3."RFCDOC~";

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

RFCLANG                                   NOT NULL VARCHAR2(3)

RFCDEST                                   NOT NULL VARCHAR2(96)

RFCDOC1                                   NOT NULL VARCHAR2(216)

RFCDOC2                                   NOT NULL VARCHAR2(216)

RFCDOC3                                   NOT NULL VARCHAR2(216)

===================

SQL> select table_name from dba_tables where table_name like 'RFCDOC%'

  2  ;

TABLE_NAME

------------------------------

RFCDOC

RFCDOC~

======================

And it says unknown object id , Can anyone please advise.

Thanks,

Sowmya

[Former Member · Accepted solution]

Please check note

1742979 - ORA-00001: unique constraint violated encountered in DBCLONE phase during upgrade