AX-CRM Connector Error: Change Tracking Version (AifSqlCtVersion).

Question Status

Suggested Answer
axSinha asked a question on 14 May 2015 4:15 AM


Hi,

I am getting the below error in AIF exception log while syncing the data from Dynamic CRM

“Cannot select a record in Change Tracking Version (AifSqlCtVersion). Change Tracking Version: 0.
Deadlock, where one or more users have simultaneously locked the whole table or part of it.”

 

Kindly suggest a solution ….

 

Thanks and Regards

Reply
Suggested Answer
Chris Hetzler responded on 18 May 2015 5:18 PM

Has your AX database recently been upgraded?  There are know issues with AifServices and change tracking that can occur during upgrade that might be causing this.  I strongly encourage you to open a support ticket on this issue.

Reply
Suggested Answer
Sujit responded on 22 Dec 2016 2:45 AM

Hi,

I am getting same error. We did not upgrade any thing. I just installed a hotfix for SEPA

Please suggest

Regards,

Sujit

Reply
Suggested Answer
Chris Hetzler responded on 18 May 2015 5:18 PM

Has your AX database recently been upgraded?  There are know issues with AifServices and change tracking that can occur during upgrade that might be causing this.  I strongly encourage you to open a support ticket on this issue.

Reply
Suggested Answer
Sujit responded on 22 Dec 2016 2:45 AM

Hi,

I am getting same error. We did not upgrade any thing. I just installed a hotfix for SEPA

Please suggest

Regards,

Sujit

Reply