Cannot drop constraint - nonexistent constraint

[harryhome]

I am deleting records from table DCX_PLATFORM_TEAM. The job is deleting the desired record also but it gives following warning , plz help how to remove this warning.


Del_Dcx_Platform_Team..DCX_PLATFORM_TEAM: alter table DCX_CONSOLIDATED_USAGE drop constraint UK_DCX_CONSOLIDATED_USAGE


Del_Dcx_Platform_Team..DCX_PLATFORM_TEAM: ORA-02443: Cannot drop constraint - nonexistent constraint

[rafik2k]

Which update action you set in target table stage?

This is error shows you are tying to alter the table constraint.

[harryhome]

I m trying to delete record from tables Dcx_Sub_Dept_Employee and S_Rot_Class.

following messges in director , 6 th one is the warning message


1)Del_Dcx_Sub_Dept_Employee..Xfm_Seq_Dcx_Sub_Dept_Employee: DSD.StageRun Active stage starting, tracemode = 0.


2)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPLOYEE: DELETE FROM DCX_SUB_DEPT_EMPLOYEE WHERE OBJ_ID = :1

3)Del_Dcx_Sub_Dept_Employee..S_ROT_CLASS: DELETE FROM S_ROT_CLASS WHERE OBJ_ID = :1

4)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPLOYEE: Executing AfterSQL

5)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPLOYEE: alter table DCX_CONSOLIDATED_USAGE drop constraint UK_DCX_CONSOLIDATED_USAGE

6)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPLOYEE: ORA-02443: Cannot drop constraint - nonexistent constraint

7)Del_Dcx_Sub_Dept_Employee..Xfm_Seq_Dcx_Sub_Dept_Employee: DSD.StageRun Active stage finishing.
1 rows read from lnk_Seq_Del_Dcx_Sub_Dept_Employee
1 rows written to lnk_Del_Dcx_Sub_Dept_Employee
1 rows written to lnk_Del_S_Rot_Class
0.080 CPU seconds used, 0.000 seconds elapsed.
3:57:41 PMSweta Patel1)Del_Dcx_Sub_Dept_Employee..Xfm_Seq_Dcx_Sub_Dept_Employee: DSD.StageRun Active stage starting, tracemode = 0.


2)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPLOYEE: DELETE FROM DCX_SUB_DEPT_EMPLOYEE WHERE OBJ_ID = :1

3)Del_Dcx_Sub_Dept_Employee..S_ROT_CLASS: DELETE FROM S_ROT_CLASS WHERE OBJ_ID = :1

4)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPLOYEE: Executing AfterSQL

5)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPLOYEE: alter table DCX_CONSOLIDATED_USAGE drop constraint UK_DCX_CONSOLIDATED_USAGE

6)Del_Dcx_Sub_Dept_Employee..DCX_SUB_DEPT_EMPLOYEE: ORA-02443: Cannot drop constraint - nonexistent constraint

7)Del_Dcx_Sub_Dept_Employee..Xfm_Seq_Dcx_Sub_Dept_Employee: DSD.StageRun Active stage finishing.
1 rows read from lnk_Seq_Del_Dcx_Sub_Dept_Employee
1 rows written to lnk_Del_Dcx_Sub_Dept_Employee
1 rows written to lnk_Del_S_Rot_Class
0.080 CPU seconds used, 0.000 seconds elapsed.

[ray.wurlod]

You have misnamed the constraint in your After SQL, or the constraint as not yet been re-created after the last time you dropped it.

Why are you dropping a constraint in an After SQL anyway? It seems a very strange thing to be doing.

[chulett]

It's pretty obvious what's going on - you are trying to drop a non-existent constraint 'After SQL'. The question is why?