web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Unable to enable chang...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Unable to enable change tracking to custom entity in Production

(0) ShareShare
ReportReport
Posted on by ShruthiKrishnaswamy 20

Hi, 

When we try to enable change tracking in a custom entity, we are getting the below message:

Change tracking cannot be enabled or disabled on the specified data entity as the underlying tables are currently in use. It is recommended to perform this operation when there is no activity on the data entity and the underlying tables.
This behavior occurs only in Production, it is working fine in UAT and Multi-tier Test Boxes. There aren't any data projects using the entity. We tried deleting it and refreshing the entity list as well, dint work. 
Thanks in Advance.
Regards,
Shruthi
I have the same question (0)
  • vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,332 on at

    Hi Shruti,

    Was this entirely new data entity created and pushed to Prod for the first time or it was already used and some latest changes are pushed to prod?

  • ShruthiKrishnaswamy Profile Picture
    ShruthiKrishnaswamy 20 on at

    Hi Vinit,

    The entity was created long back, it is being used in Pre-Prod and UAT. However it was only recently pushed to Prod. Also, we updated our UAT with Prod DB yesterday, We were not able to reproduce the issue. Looks like it is behaving so only in Production.

  • Suggested answer
    vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,332 on at

    Hi Shruti,

    Try deleting the entity from the entity list and refresh the entity list from Framework parameters -> Entity settings -> Refresh entity list.

    Please check the table AIFSQLCTTRIGGERS in DB if there is any record already for the data entity. If this is not reproducible in UAT then I suggest creating a ticket with Microsoft support because we can't do much on Production as we don't have access to it.

  • ShruthiKrishnaswamy Profile Picture
    ShruthiKrishnaswamy 20 on at

    Hi Vinit,

    Yes we tried that already  (deleting and refreshing the entity list), it did not help.

    I will check the AIFSQLCTTRIGGERS in UAT as the PROD was restored to it.

    But yeah, its not reproducible in UAT, and we have created a ticket with MS.

    Thanks for all your help.

  • vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,332 on at

    Hi Shruti,

    Ok, Please let us know about you findings.

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,032 on at

    browsing the table would show if the data entity has created any triggers

    AIFSQLCTTRIGGERS

  • Suggested answer
    ShruthiKrishnaswamy Profile Picture
    ShruthiKrishnaswamy 20 on at

    Hi Rahul,

    We checked the table AIFSQLCTTRIGGERS, there weren't any records related to the entity there. However funnily, the issue got resolved this morning. We are unsure of the root cause and the MS support executive did not get back to us yet with his findings.

  • ShruthiKrishnaswamy Profile Picture
    ShruthiKrishnaswamy 20 on at

    Hi Vinit,

    We checked the table AIFSQLCTTRIGGERS, there weren't any records related to the entity there. However, the issue got resolved this morning. We are unsure of the root cause and the MS support executive did not get back to us yet with his findings.

  • vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,332 on at

    Hi Shruti,

    Were you able to find if this entity was used in any processing group? Any batch jobs finished the execution?  Please let us know about your findings.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans