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

[Steve_Nguyen]

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

1. From the SQL Server Management Studio (SSMS) login to the SQL database that Qlik Replicate is using for the source endpoint.
2. 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' 
   
   
3. 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​

4. 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

Qlik Replicate  2021 and later

[SoonerWatts]

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