Hi,
I have a replicat looking like this:
MAP PURCHASE.CD_BATCH_TYP_LKP, TARGET PURCHASE.CD_BATCH_TYP_LKP &
RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, OVERWRITE)), &
RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)), &
RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
But it fails like this:
2017-04-06 17:27:33 WARNING OGG-01919 Missing RESOLVECONFLICT for SQL error 1.
2017-04-06 17:27:33 WARNING OGG-01004 Aborted grouped transaction on 'PURCHASE.CD_BATCH_TYP_LKP', Database error 1403 (OCI Error ORA-01403: no data found, SQL <UPDATE "PURCHASE"."CD_BATCH_TYP_LKP" x SET x."CD_BATCH_TYP_CD" = :a1,x."CD_BATCH_TYP_NAME" = :a2,x."CD_BATCH_TYP_DESC" = :a3,x."ACTV_FLG" = :a4,x."PRVD_FLG" = :a5,x."ACTVT_REQM_FLG" = :a6,x."SAMPLE_SPPRT_FLG" = :a7,x."DFLT_CD_FRMT_MASK_ID" = :a8 WHERE x."CD_BATCH_TYP_ID" = :b0>);
Why is it not resolving this and simply inserting the record?