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

    Workspace Manager -  ResolveConflicts error

    8dce97fb-9671-4ebb-b573-dd86b8b4bc08

      Hi,

        We are using Oracle Database 11g Enterprise Edition Release 11.1.0.7.0  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');

      COMMIT;

      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.