If you using OBIA 11g with EBS R12.1.3 , while performing FULL
LOAD plan , you might be got an error during LOAD PLAN.
The Error is :
ODI-1232: Procedure TABLE_MAINT_PROC execution fails.
ODI-1228: Task TABLE_MAINT_PROC (Procedure) fails on the target
ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20000: Error creating
Index/Constraint : W_EMPLOYEE_DS_U1 => ORA-01452: cannot CREATE UNIQUE
INDEX; duplicate key
Solution is :
SQLs used to remove duplicate keys : (used the
same for other tables)
select integration_id, datasource_num_id, src_eff_from_dt,
count(*)
from w_employee_ds
group by integration_id, datasource_num_id, src_eff_from_dt
having count(*)>1;
delete from w_employee_ds where integration_id='PER~2901' and
datasource_num_id=11;
Finally :
We will troubleshoot the failed tasks and after issue fixes we have the ability to start that particular task individually. If any failed task ran successfully after fixes, The ODI will resume the load plan automatically to start next dependent (serial) tasks. Otherwise, we can also resume the Load plan with its “restart from the failure” option
We will troubleshoot the failed tasks and after issue fixes we have the ability to start that particular task individually. If any failed task ran successfully after fixes, The ODI will resume the load plan automatically to start next dependent (serial) tasks. Otherwise, we can also resume the Load plan with its “restart from the failure” option
Regards,
Zafar Habib
Hi Zafar,
ReplyDeleteI have seen your post. it is since Decemeber 2013, Did you get any proper solution to get rid of this situation, because most of the time we start Full Load Execution overnight, and we can not stay to rectify these issue till the smooth load runs. I have got 5 similar errors in different table indexes.
Is there any proper solution to fix it.
Regards,
Ather Ali