Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

6678700: 12:Oracle Solaris on SPARC (64-bit) : FAILED: file czrp.odf on worker 1.

edited Nov 1, 2012 6:04AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
 running the R12 upgrade driver u6678700 & its failing on worker 1
ATTENTION: All workers either have failed or are waiting:

          FAILED: file czrp.odf     on worker  1.

in the worker log

*******************************************************
The table is missing the index CZ_ARCHIVE_REFS_PK
or index CZ_ARCHIVE_REFS_PK exists on another table.
Create it with the statement:


Start time for statement below is: Thu Nov 01 2012 09:13:09

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.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center