Error: Cannot Select - (CDC) Multiple Capture Instance Not Supported

Issue

While attempting to include tables in the connector schema, the following error appears:

Cannot select - (CDC) Multiple capture instance not supported

Environment

Connector: SQL Server

Resolution

To resolve this issue, do the following:

1. In SQL Server, list the capture instances for each table you cannot include in your connector schema by querying the cdc.change_tables table. Use the following query:

   SELECT
     OBJECT_NAME(object_id),
     OBJECT_NAME(source_object_id),
     OBJECT_SCHEMA_NAME(source_object_id),
     role_name,
     capture_instance
   FROM cdc.change_tables
   WHERE
     OBJECT_SCHEMA_NAME(source_object_id) = '<schema_name>'
     AND OBJECT_NAME(source_object_id) = '<table_name>';
   

2. From the list of results, identify unneeded capture instances, then disable them using the following command:

   USE <database_name>
   GO
     EXEC sys.sp_cdc_disable_table
     @source_schema = N'<schema_name>',
     @source_name   = N'<table_name>',
     @capture_instance = N'<capture_instance_name>'
   GO
   

Cause

We only support tables associated with a single CDC capture instance. See our SQL Server setup guide for more information. This issue occurs when you attempt to include a table associated with more than one CDC capture instance in your connector schema.