R121.1. Upgrade: czpkctr2.sql and czrp.odf Jobs Fail ORA-02437 : cannot validate (CZ.CZ_ARCHIVE_REFS_PK) - primary key violated (Doc ID 1667782.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Configurator - Version 12.1.1 to 12.1.1 [Release 12.0]
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Installation and Upgrade

When upgrading to R12, the following two jobs fail when running the 12.1.1 upgrade driver : czpkctr2.sql and czrp.odf.

According to Bug 14846811, there are duplicate rows in table CZ_ARCHIVE_REFS which may be causing the error seen.


ERROR
-----------------------
czpkctr2.sql errors:
Creating Primary Key on 'CZ_ARCHIVE_REFS'
ALTER TABLE CZ.CZ_ARCHIVE_REFS add constraint CZ_ARCHIVE_REFS_PK
  *
ERROR at line 1:
ORA-02437: cannot validate (CZ.CZ_ARCHIVE_REFS_PK) - primary key violated

czrp.odf errors:
CREATE UNIQUE INDEX CZ.CZ_ARCHIVE_REFS_PK ON CZ.CZ_ARCHIVE_REFS
 (DEVL_PROJECT_ID, SEQ_NBR) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4
 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
 APPS_TS_SEED

Statement executed.
  
AD Worker error:
The index cannot be created as the table has duplicate keys.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. upgrade to R12 , CZ patch 6678700
 

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