Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

932929Apr 24 2012 — edited Apr 29 2012
Hello all,
Here is the situation.

We bought BI Apps lately and just plugged in out of the box. Didn't really work on major configurations or anything like that.
We are trying to run the ETL for the first time and in DAC, we observed only 24 successful tasks but made couple of changes and eventually made almost all of them work except 21 of them. 21 tasks are failing and most of the 21 tasks (or infact all of the 21) are failing because of this error:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

I tried looking into one of the tasks log which failed. Example, W_SALES_BOOKING_LINE_F

ANOMALY INFO::: Error while executing : CREATE INDEX:W_SALES_BOOKING_LINE_F:W_SLS_BKG_LN_F_U1
* MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX*
* W_SLS_BKG_LN_F_U1*
ON
* W_SALES_BOOKING_LINE_F*
*(*
* INTEGRATION_ID ASC*
* ,DATASOURCE_NUM_ID ASC*
*)*
NOLOGGING
* with error DataWarehouse:CREATE UNIQUE INDEX*
* W_SLS_BKG_LN_F_U1*
ON
* W_SALES_BOOKING_LINE_F*
*(*
* INTEGRATION_ID ASC**
* ,DATASOURCE_NUM_ID ASC*
*)*
NOLOGGING
* ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found**
Please help!!!
Its very urgent.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2012
Added on Apr 24 2012
2 comments
4,030 views