topic Re: Error message showing CDC is not enabled at table level though we have enabled at database level in SQL server in Qlik Replicate

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

desmondchew — Tue, 25 Apr 2023 04:06:54 GMT

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.

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

kng — Tue, 25 Apr 2023 04:13:02 GMT

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-REPLICATION-is-not/ta-p/2051544

Hopes this helps.

Regards,
Shivananda

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

SwathiPulagam — Fri, 28 Apr 2023 16:40:51 GMT

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:

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

Thanks,

Swathi

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

SwathiPulagam — Fri, 28 Apr 2023 16:43:13 GMT

Hi @desmondchew ,

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

Thanks,

Swathi

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

dhina — Mon, 24 Jul 2023 15:22:52 GMT

Hello Swathi,

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

Thanks,

Dhina

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

SushilKumar — Tue, 25 Jul 2023 01:10:51 GMT

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