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'
Last updated on JANUARY 27, 2017
Applies to:
Business Intelligence Applications Consumer - Version 7.9.6.4 and laterInformation 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
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