Qlik Replicate Task logs a warning: ]W: MS-REPLICATION is not enabled for table

Steve_Nguyen — Mon, 27 Mar 2023 07:13:02 GMT

Qlik Replicate logs the following warning:

]W: MS-REPLICATION is not enabled for table 'dbo.YourTableName'. 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.

However, the table has a Primary Key and exists in an MS-Replication Publication not created by Qlik Replicate.

Resolution

From the SQL Server Management Studio (SSMS) login to the SQL database that Qlik Replicate is using for the source endpoint.
Check the Replication/Publication that the table(Article) uses, and verify that:

immediate_sync is set to 'true'
and
allow_anonymous is set to 'true'
If not true, run the below script to update the pulications.

Note: The immediate_sync option needs to be enabled prior to being able to update the allow_anonymous setting.
USE DBName DECLARE @publication AS sysname SET @publication = N'ProdArticlesNoSubs' USE DBName EXEC sp_changepublication @publication = @publication, @property = N'immediate_sync', @value = true GO USE DBName DECLARE @publication AS sysname SET @publication = N'ProdArticlesNoSubs' USE DBName EXEC sp_changepublication @publication = @publication, @property = N'allow_anonymous', @value = true GO
After making the change to the publications, stopped the tasks and then resumed them.

Cause

When the Publication is set for immediate_sync is set to 'false' and allow_anonymous is set to 'false'. This causes the table that being replicated not to register to the sys.table.

Environment

2021 and later

Re: Qlik Replicate Task logs a warning: ]W: MS-REPLICATION is not enabled for table

SoonerWatts — Thu, 21 Mar 2024 21:11:18 GMT

What if your publication does not exist but the task is still pumping data through...

article Qlik Replicate Task logs a warning: ]W: MS-REPLICATION is not enabled for table in Official Support Articles

Qlik Replicate Task logs a warning: ]W: MS-REPLICATION is not enabled for table

Resolution

Cause

Environment

Re: Qlik Replicate Task logs a warning: ]W: MS-REPLICATION is not enabled for table