CDR fails with WARNING OGG-01923 Conflict resolution failed with SQL error 1 on original conflict with SQL error 1,403
(Doc ID 2119777.1)
Last updated on APRIL 27, 2021
Applies to:
Oracle GoldenGate - Version 12.1.2.1.5 and laterInformation in this document applies to any platform.
Symptoms
Implemented CDR for one table called CARD.
CDR failed with the below error message:
2016-03-02 20:40:58 WARNING OGG-00869 OCI Error ORA-01403: no data found (status = 1403), SQL <SELECT ROWNUM FROM "XXXX"."CARD" WHERE "CARDID" = :b0 FOR UPDATE >.
2016-03-02 20:40:58 WARNING OGG-02044 Grouped transaction was aborted, most likely to use an Oracle workspace to handle a transient primary-key duplicate. Check for additional messages.
2016-03-02 20:40:58 WARNING OGG-01154 SQL error 1 mapping XXXX.CARD to XXXX.CARD OCI Error ORA-00001: unique constraint (XXXX.CARD_CARDNUM_UIDX) violated (statu
s = 1), SQL <INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "XXXX"."CARD" ("CARDID","PERSONID","CARDNUM","BILLINGADDRESSID","SHIPPINGADDRESSID","SECURITYCODE","DATEISSUED",
"ACTIVATIONDATE","TERMINATIONDATE","EXPDATE","FNAME","MNAME","LNAME","CARDDESIGNID","CARDSTATUSID","PINOFFSET","SHIPPINGID","ISVIRTUAL","ACTIVATIONMETHODID","LINE4EMBOS
SING","CARDREASONCODEID","CREATEDBY","CREATEDATE","LASTUSER","LASTUPDATE","SHIPTOID","GIFTFROM","BATCHSUBORDID","NEXTEXPDATE","UPC","PINRESETREQ","REISSUEDATE","EMBOSSI
NGFIELD3A","EMBOSSINGFIELD3B","ISPERSONALIZEDREISSUED","LOCATIONID","CHIPCARDFLAG") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,:a15,:a16,:
a17,:a18,:a19,:a20,:a21,:a22,:a23,:a24,:a25,:a26,:a27,:a28,:a29,:a30,:a31,:a32,:a33,:a34,:a35,:a36)>.
2016-03-02 20:40:58 WARNING OGG-01923 Conflict resolution failed with SQL error 1 on original conflict with SQL error 1,403.
Configured exception table, because of this replicat does not abend (nothing in the discard file), but we see failed resolutions for CDR:
From Table XXXX.CARD to XXXX.CARD:
# inserts: 0
# updates: 0
# deletes: 0
# discards: 6
# CDR conflicts : 6
# CDR resolutions failed : 8
# CDR UPDATEROWMISSING conflicts: 3
From Table XXXX.CARD to XXXX_EXCEP_CDR.CARD:
# inserts: 6
# updates: 3
# deletes: 0
# discards: 0
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |