Sample Header Ad - 728x90

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