[SOURCE_CAPTURE ]W: The metadata for source table 'dbo.table' is different than the corresponding MS-CDC Change Table. The table will be suspended. (sqlserver_mscdc.c:805)
This warning can occur from hidden columns as Qlik Replicate is not able to identify the hidden columns that exist on the SQL Server database. This will cause a mismatch between Qlik Replicate and the SQL Server's version of the metadata.
Resolution
Hidden columns need to be revealed for Qlik Replicate to include them in the metadata. Columns that are hidden will look like the following in your DDL.
[$ValidFromDTM] [datetime2](7) GENERATED ALWAYS AS ROW START HIDDEN NOT NULL,
[$ValidToDTM] [datetime2](7) GENERATED ALWAYS AS ROW END HIDDEN NOT NULL,
Example SQL queries to unhide the hidden columns:
ALTER TABLE <the table name> ALTER COLUMN [SysStartTime] drop HIDDEN;
ALTER TABLE <the table name> ALTER COLUMN [SysEndTime] drop HIDDEN;
Cause
Qlik Replicate is not able to identify the hidden columns that exist on the SQL Server database. This will cause a mismatch between Replicate and SQL Server's version of the metadata.
Internal Investigation ID(s)
QB-25470
Environment
