Targeted Collection Error - Duplicate Keys Found

Last updated on MARCH 09, 2018

Applies to:

Symptoms

When running targeted collection the following errors are seen in one of the Load Entity logs:


ERROR
The Load Entity process started with refresh number xxxxxx.
Number of records copied from ODS to Temp = 0
MSC_ITEM_STRUCTURES
ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

ORA-06512: at "FUSION.ADM_FUSION_DDL", line 490
ORA-06512: at "FUSION.MSC_COLL_PARTITIONS", line 613

Exchange partition failed for table : MSC_ITEM_STRUCTURES
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-

ORA-06512: at "FUSION.MSC_COLL_PARTITIONS", line 1075
ORA-06512: at "FUSION.MSC_COLL_BOMS", line 1825

ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-

ORA-06512: at "FUSION.MSC_COLL_BOMS", line 1911
ORA-06512: at line 1
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1056

ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-
ORA-20107: ORA-20401: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found-

ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1069
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 2196


STEPS TO REPRODUCE
1. Run Targeted Collections.
2. See the errors in the Load Entity log file

Changes

Cause