Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
toni_lajsner
Contributor III
Contributor III

Issue with Metadata for source table

Hi

 

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 

Labels (2)
1 Solution

Accepted Solutions
Steve_Nguyen
Support
Support

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.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

3 Replies
Steve_Nguyen
Support
Support

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.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
toni_lajsner
Contributor III
Contributor III
Author

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 ?

Steve_Nguyen
Support
Support

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. 

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!