This discussion is archived
1 Reply Latest reply: Oct 18, 2012 12:41 PM by Ben Speckhard RSS

Workspace rollback or remove throws exception child record found

969158 Newbie
Currently Being Moderated
Oracle 10g
Error appears on DBMS_WM.REMOVEWORKSPACE or DBMS_WM.ROLLBACKWORKSPACE call.
In workspace we had modified two tables T1 and T2, T1 has forein key on T2.

We get workspace merged to LIVE, but when we want to remove workspace:

BA_PostTransaction' failed due to: Stored procedure invocation error. Error while trying to prepare and execute the BPEL_USER.AR_PR_MNG.POST_TRX API. An error occurred while preparing and executing the BPEL_USER.AR_PR_MNG.POST_TRX API. Cause: java.sql.SQLException: ORA-20005: integrity constraint (AR.NLN_PNO_FK) violated - child record found ORA-06512: at "WMSYS.WM_ERROR", line 342 ORA-06512: at "WMSYS.WM_ERROR", line 368 ORA-06512: at "AR.LT_AD_41", line 27 ORA-04088: error during execution of trigger 'AR.LT_AD_41' ORA-06512: at "WMSYS.LT", line 4962 ORA-06512: at "AR.PR_MNG", line 118 ORA-06512: at "BPEL_USER.AR_PR_MNG", line 15 ORA-06512: at line 1

It looks like bug in WM, it tries to delete parent record before child record.
Now worskpace is stacked, it can't be remowed and any ddl operations with envolved table can't be done.

Does any way exist to avoid this situation in future?

Edited by: user7023410 on 2012.17.10 23:46

Edited by: user7023410 on 2012.18.10 00:08

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points