GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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 --

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center