Goldengate on SQL Server Issue
Anyone seen the Database CDC capture job fail on duplicate row insert rejection in SQL Server?
Cannot insert duplicate key row in object 'cdc.OracleGG_1435932983_CT' with unique index 'OracleGG_1435932983_CT_clustered_idx'. The duplicate key value is (0x00e7102d0000c8d40006, 1, 0x00e7102d0000c8d40005, 3).
The extract said running but the time was the time of the error above. Meanwhile the PMSRVR and JAGENT processes went nuts consuming most of the server CPU by afternoon. I stopped the PSRVR and JAGENT. CPU dropped from 100% to 49% and staryed there after restart. The CDC Capture job restarted without issue (though a manual restart is required vs Ms provided SP).
HTH -- Mark D Powell --