Oracle Database 12.2.0
RHEL 7.4
Hello Team,
kindly note that I am getting error below from ggserror.log. I see the number of records on target is higher than that on source
source:
select count(*) from CBS_CORE.CB_SUBS_OFFER_DETAILS;
636311
target:
select count(*) from cbsogg.CB_SUBS_OFFER_DETAILS;
636314
CBSOGG.CB_SUBS_OFFER_DETAILS
WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unhandled error (ORA-26786: A row with key ("ACCOUNT_LINK_CODE_N", "OFFER_CODE_V") = (16222608, O160206) exists but has conflicting column(s) "END_DATE_D" in table CBSOGG.CB_SUBS_OFFER_DETAILS
EXTRACT PXDWN is 00:00:00 (checkpoint updated 00:00:05 ago).
2019-07-10T13:33:08.546+0400 WARNING OGG-02544 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unhandled error (ORA-26786: A row with key ("ACCOUNT_LINK_CODE_N", "OFFER_CODE_V") = (23488643, O161510) exists but has conflicting column(s) "END_DATE_D" in table CBSOGG.CB_SUBS_OFFER_DETAILS
ORA-01403: no data found) while processing the record at SEQNO 72, RBA 67899777 in Integrated mode. REPLICAT will retry in Direct mode.
There is another table (WF_TODOITEM_HISTORY) which is returning error below. But for this table, I see the number of rows tally.
Unhandled error (ORA-01422: exact fetch returns more than requested number of rows
ORA-01403: no data found) while processing the record at SEQNO 72, RBA 19238450 in Integrated mode. REPLICAT will retry in Direct mode.
Please advise.
Regards,
Joe