Distribution schedule, change tracking is not enabled on table

In case of following errors:
Cannot execute the required database operation.
The SQL database has issued an error.
Object Server 01:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Change tracking is not enabled on table
'INVENTSERIAL'.
Error happened during scheduler job execution. Check infolog for details.

Change tracking needs to be enabled for the specified table.
Open SQL Server Management Studio, connect to SQL server, select correct DB and in table properties enable change tracking:

Alternatively use SQL script:
use DbName;

IF NOT EXISTS (SELECT 1 FROM sys.change_tracking_tables WHERE object_id = OBJECT_ID('[dbo].[RETAILSTORELOCATORGROUPMEMBER]')) 
 BEGIN ALTER TABLE [dbo].[RETAILSTORELOCATORGROUPMEMBER] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON) END 

...
SQLQuery_ReActivateCT.txt

 

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units and "buy me a coffee" link.
Join us.

Blog Tags