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

MOSC Banner

R12.2 upgrade driver failed cnsca.odf

edited May 28, 2014 12:00PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

Upgrade from 11.5.10.2 to 12.2, The R12.2 upgrade driver failed with below error, please let us know, if any one faced same issue or any suggestions .

Start time for statement below is: Mon May 19 2014 19:28:19

CREATE UNIQUE INDEX CN."CN_SCA_RULE_ATTRIB_ALL_TL_U2" ON

CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL (SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE)

LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )  PCTFREE 10 INITRANS 11

MAXTRANS 225 COMPUTE STATISTICS   TABLESPACE APPS_TS_SEED

Statement executed.

AD Worker error:

The index cannot be created as the table has duplicate keys.

Use the following SQL statement to identify the duplicate keys:

SELECT SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE, count(*)

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

EBS LCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center