Good Day
This is regarding bi-directional replication b/w Oracle databases 11.2.0.4.x/Linux x86-64. we didn't configure CDR yet.
Due to same record update/commit at source and target database (during testings) at near same moment the subject error occurred (which was expected).
---- ggserr.log related content
2017-09-18 16:39:11 WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, xxxx.prm: Unhandled error (ORA-26787: The row with key ("xxxME", "xxxYPE", "USERID") = (POTS, POTS, legend) does not exist in table xxxxxxSER.UxxxxS
ORA-01403: no data found) while processing the record at SEQNO 0, RBA 39905062 in Integrated mode. REPLICAT will retry in Direct mode.
2017-09-18 16:39:11 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, xxxx.prm: SQL error 1403 mapping xxxx.xx to xxxx.xx OCI Error ORA-01403: no data found, SQL <UPDATE "xxxx"."xxx" x SET x."ID" = :a0,x."DATETIME" = :a4,x."USERID" = :a5,x."SxxxPE" = :a6,x."xxAME" = :a7 WHERE x."UxxID" = :b0 AND x."xxxYPE" = :b1 AND x."xxxME" = :b2>.
2017-09-18 16:39:11 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, xxxxb.prm: Error mapping from xxxx.xxxx to xxxx.xxxx.
2017-09-18 16:39:16 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, xxxx.prm: PROCESS ABENDING.
-----
That will be great if we discuss below related points -
1. what is the workaround to resolve above conflict and able to restart abended Replicat process as soon as possible ?
2. what should be your suggested CDR mapping/rules as we don't have timestamp datatype col in tables ?
Thanks
Regards,
Muhammad Ahmad