-
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
-
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)