Share
Report
6,414Hello,
I try to run the job 1060 "Staff" after making some changes on Employee.
The Job fails with the following error message:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Change tracking is not enabled on table 'RETAILCDXDATASTORECHANNEL'.
INSERT INTO tempdb."DBO".t21250BatchEMPDEV661_41704_AFDFED5F2F3B41DD8F43223E6083984B (REFTABLEID, NODEID, SYS_CHANGE_OPERATION, REFRECID, PARTITION) SELECT 6824, -1, CT.SYS_CHANGE_OPERATION, t.RECID, 5637144576 FROM CHANGETABLE(CHANGES [RETAILCDXDATASTORECHANNEL], 94) AS CT INNER JOIN [RETAILCDXDATASTORECHANNEL] AS t ON (t.[RECID]=CT.[RECID]) WHERE (CT.SYS_CHANGE_OPERATION = 'I' AND CT.SYS_CHANGE_CREATION_VERSION <= 95) AND t.[PARTITION] = 5637144576;
I have enabled the change tracking for 'RETAILCDXDATASTORECHANNEL' and restarted Services.
However the job still fails.
Did you have same problem before? How to resolve it?
Thanks.
All responses (
Answers (
