OBIA 7964 SIL_MfgOperationDetailFact Task Failed During ETL Load With The Error Message 'Error while execution : CREATE UNIQUE INDEX W_MFG_OPERATION_DETAIL_F_U1'

(Doc ID 2001603.1)

Last updated on JANUARY 27, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

The ETL failed at 99% with following task SIL_MfgOperationDetailFact. Looks like the Index failed to be created due to duplicate records.

2015-03-23 16:52:43.912 CREATE INDEX:W_MFG_OPERATION_DETAIL_F:W_MFG_OPERATION_DETAIL_F_U1 has started.

ANOMALY INFO::: Error while executing : CREATE INDEX:W_MFG_OPERATION_DETAIL_F:W_MFG_OPERATION_DETAIL_F_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_MFG_OPERATION_DETAIL_F_U1
ON
W_MFG_OPERATION_DETAIL_F
(INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc)
NOLOGGING
 with error DataWarehouse:CREATE UNIQUE INDEX
W_MFG_OPERATION_DETAIL_F_U1
ON
W_MFG_OPERATION_DETAIL_F
(INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc)
NOLOGGING
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

EXCEPTION CLASS::: java.lang.Exception

com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:516)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)
com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)
com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
java.util.concurrent.FutureTask.run(FutureTask.java:138)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
java.util.concurrent.FutureTask.run(FutureTask.java:138)
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
java.lang.Thread.run(Thread.java:738)

::: CAUSE :::
MESSAGE :::Error while execution : CREATE UNIQUE INDEX
W_MFG_OPERATION_DETAIL_F_U1
ON
W_MFG_OPERATION_DETAIL_F
(INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc)
NOLOGGING
 with error DataWarehouse:CREATE UNIQUE INDEX
W_MFG_OPERATION_DETAIL_F_U1
ON
W_MFG_OPERATION_DETAIL_F
(INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc)
NOLOGGING
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

 

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