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 AUGUST 25, 2016

Applies to:

Oracle GoldenGate - Version 12.1.2.1.5 and later
Information 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-01919  Missing RESOLVECONFLICT for SQL error 1.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms