Error message showing CDC is not enabled at table level though we have enabled at database level in SQL server

[desmondchew]

I am setting up a new task with on premise SQL server 2019 as source endpoint. We have enabled CDC through "sp_cdc_enable_db" for database level.

Upon full load tables, error logs starts to pop up showing that some tables CDC are not enabled. Why is that so even we have enabled at database level already? Do we need to enable them at table level individually?

Error logs:

MS-REPLICATION is not enabled for table 'dbo.tableABC'. Therefore, UPDATE changes to it will not be captured. If you want UPDATE changes to be captured, either define a Primary Key for the table (if missing) or enable Microsoft CDC instead.

[kng]

Hello Desmond,

The source does not have primary key and there were Update queries coming in. Use MS-CDC or add primary key on source to resolve this issue.

Please have a look on the below article for more information

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Task-logs-a-warning-W-MS-REPL...

Hopes this helps.

Regards,
Shivananda

[SwathiPulagam · Accepted solution]

Hi @desmondchew ,

Are you using MS-Replication or MS-CDC?

If you are using MS-CDC then use the Microsoft SQL server (MS-CDC) endpoint as a source endpoint.

If you are trying to use MS-Replication then use the Microsoft SQL server as the source endpoint.

If you are trying to use the MS-CDC with a Microsoft SQL server as the source endpoint then you might see this message:

MS-REPLICATION is not enabled for table 'dbo.tableABC'. Therefore, UPDATE changes to it will not be captured. If you want UPDATE changes to be captured, either define a Primary Key for the table (if missing) or enable Microsoft CDC instead.

To overcome this message in source endpoint-->Advanced-->Internal parameters add this internal parameter "ignoreMsReplicationEnablement" and check this option.

Thanks,

Swathi

[SwathiPulagam]

Hi @desmondchew ,

For optimal guidance in setting up a new endpoint in your environment, it is advisable to collaborate with Professional Services.

Thanks,

Swathi

[dhina]

Hello Swathi,

What is the purpose of adding ' ignoreMsReplicationEnablement ' this parameter and what it'll do with DB and Task? 

Thanks,

Dhina

[SushilKumar]

Hello Team,

These Parameter just ignores the database check during the Qlik Replicate task initiation. and you would not got] W: MS-REPLICATION is not enabled for table. " However, you may face difficulties with data replication for table participating in the replicate configuration. 
kindly be informed whenever you want to prepare your database for replication with the help of replication tools. you may need to enable different option at Database end to achieve that as a part of replication pre-requisite. 

Regards,
Sushil Kumar