Hi,
Received the following error from my replicat.
---
2016-03-09 18:49:59 INFO OGG-06506 Oracle GoldenGate Delivery for Oracle, rnddev_a.prm: Wildcard MAP resolved (entry sample.*): Map "sample"."REPORT_TOTALS", Target sample."REPORT_TOTALS".
2016-03-09 18:49:59 INFO OGG-06511 Oracle GoldenGate Delivery for Oracle, rnddev_a.prm: Using following columns in default map by name: PARTICIPANT_ID_S, PARTICIPANT_ID_R, TRANSACTION_TYPE, TOTAL_TRANSACTIONS, TOTAL_SUCCESSFUL, REPORT_MONTH, LAST_RUN_TOTAL, LAST_RUN_SUCCESSFUL, LAST_RUN_DATE, PREVIOUS_RUN_TOTAL.
2016-03-09 18:49:59 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, rnddev_a.prm: Using the following key columns for target table sample.REPORT_TOTALS: PARTICIPANT_ID_S, PARTICIPANT_ID_R, TRANSACTION_TYPE, REPORT_MONTH.
2016-03-09 18:49:59 WARNING OGG-01151 Oracle GoldenGate Delivery for Oracle, rnddev_a.prm: Error mapping from sample.REPORT_TOTALS to sample.REPORT_TOTALS.
2016-03-09 18:49:59 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rnddev_a.prm: Repositioning to rba 2791 in seqno 8.
2016-03-09 18:50:00 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rnddev_a.prm: Error mapping from sample.REPORT_TOTALS to sample.REPORT_TOTALS.
2016-03-09 18:50:04 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rnddev_a.prm: PROCESS ABENDING.
---
I did some digging and the only thing I can find out of place is that I did not enable supplemental logging for that table. This table does have the same PK on both source and target. If someone sees something else wrong, please speak up though.
I did the 'add trandata ...' on the source but the replicat still abends because of it does not have the supp logging.
What are my options? Can I add the suppl logging on the target somehow? Do I have to skipp all those transactions until the trandata is pumped over?
Thanks.