DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: replication conflict resolution

  1. #1
    Join Date
    Feb 2001
    Posts
    83

    Question

    Hello guys,

    I get the following error when i replicate. How can we solve this?? How the conflict resolution works here or how to implement conflict resolution.

    Mon Jul 23 08:52:42 2001
    Errors in file e:\admin\prod\bdump\prodSNP4.TRC:
    ORA-12012: error on auto execute of job 116
    ORA-23324: error ORA-02068: following severe error from DATA_HK_PROD
    ORA-00001: unique constraint (ACTSLAB.PK_TEST_STMNT) violated
    ORA-06512: at "ACTSLAB.TEST_STMNT$RP", line 98
    ORA-01085: preceding errors in deferred rpc to "ACTSLAB.TEST_STMNT$RP.REP_INSERT"
    ORA-02063: preceding 3 lines from DATA_HK_PROD, while creating deferror entry at "DATA_HK_PROD.WORLD" with error -1
    ORA-06512: at "SYS.DBMS_DEFER_SYS", line 901
    ORA-06512: at line 1
    with regards
    Prasanna S

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    basically, your error is :
    ORA-00001: unique constraint (ACTSLAB.PK_TEST_STMNT) violated
    look at this PK, so you'll know which data is duplicated, then look at ACTSLAB.TEST_STMNT$RP, line 98 (line 98 means 98th line from the DECLARE, without counting blank lines)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width