If you find a situation where there are numerous rows in a replication queue, but they are not going anywhere, here is a checklist of things to do:
-
Check the transaction error mode.
-
Check if there were any apply errors either in the log or in Connect CDC MonCon. They can result from:
-
Distribution key conflicts- too many/few errors in the target table.
-
Trying to send an invalid value to the target column.
-
The SQL statement fails at the target.
-
Check the target Connect CDC Listeners.