topic Re: Issue with Metadata for source table in Qlik Replicate

Issue with Metadata for source table

toni_lajsner — Fri, 07 Oct 2022 12:12:01 GMT

I am getting following massage:

The metadata for source table 'dbo.tablename' is different than the corresponding MS-CDC Change Table. The table will be suspended. (sqlserver_mscdc.c:776)

Is this issue located on "source" side or can we rerun the task in qlik to solve the problem ?

//Toni

Re: Issue with Metadata for source table

Steve_Nguyen — Fri, 07 Oct 2022 13:20:01 GMT

this issue the source side issue :

This means the structure of the MS-CDC Change Table does not match the base table , probably because the table has been altered (e.g. new column added) after configuring MS-CDC, please make sure MS-CDC is configured correctly and engage Microsoft support if you need help in that area. The issue is external to Qlik Replicate.

Re: Issue with Metadata for source table

toni_lajsner — Mon, 10 Oct 2022 12:40:02 GMT

Hi Steve
If Qlik do not have full access to the server, is it possible to circumvent the issue but not loading newly added columns ?

Re: Issue with Metadata for source table

Steve_Nguyen — Mon, 10 Oct 2022 15:10:48 GMT

Hi Steve
If Qlik do not have full access to the server, is it possible to circumvent the issue but not loading newly added columns ?

ans : could not work for CDC on this table.