CDC Error - NULL Source Schema and Source Table - Error msg on both enable and disable table
1
vote
1
answer
638
views
Today I re-enabled CDC on the primary node of an availability group. When the jobs were created the cleanup job failed with the following error:
> Could not delete change table entries made obsolete by a change in one or more low water marks for capture instances of database DB1. The failure occurred when executing the command 'delete top( @p1 ) from [cdc].[dbo_Table1_CT] where __$start_lsn Disable:
>
>Change data capture instance 'dbo_Table1' has not been enabled for the source table 'dbo.Table1'.
>Enable:
>
>Could not create a capture instance because the capture instance name 'dbo_Table1' already exists in the current database.
I'm at a loss on how to get this either removed from CDC or updated so the NULLs don't appear.
Asked by JoeDBA18
(11 rep)
May 31, 2023, 01:48 PM
Last activity: Feb 7, 2025, 06:00 AM
Last activity: Feb 7, 2025, 06:00 AM