1 Reply Latest reply on Jun 24, 2014 7:37 PM by Ben Speckhard-Oracle

    Workspace Manager -  ResolveConflicts error



        We are using Oracle Database 11g Enterprise Edition Release  version. I am getting conflict error when I try to merge child workspace to parent. so i executed the following statements to resolve the conflict


      EXECUTE DBMS_WM.BeginResolve ('PREVIOUS');

      EXECUTE  DBMS_WM.ResolveConflicts ('PREVIOUS', 'table name', 'table _primary_key = 11865109', 'child');


      EXECUTE DBMS_WM.CommitResolve ('PREVIOUS');


      and i getting thwe following error


      EXECUTE  DBMS_WM.ResolveConflicts ('PREVIOUS', 'table name', 'table _primary_key = 11865109', 'child');Error report -

      ORA-29875: failed in the execution of the ODCIINDEXINSERT routine

      ORA-20232: unique constraint (MGFEE.MI_34_IDXB$) violated

      ORA-06512: at "MGFEE.OVM_INSERT_782", line 4

      ORA-04088: error during execution of trigger 'MGFEE.OVM_INSERT_782'

      ORA-06512: at "WMSYS.LT", line 8588

      ORA-06512: at line 1

      29875. 00000 -  "failed in the execution of the ODCIINDEXINSERT routine"

      *Cause:    Failed to successfully execute the ODCIIndexInsert routine.

      *Action:   Check to see if the routine has been coded correctly.


      Could you please advise how to fix this issue. Thanks for your help.