Refresh Entity List error: Change Tracking is not enabled on the database

(0) Share

Report

Posted on by Pete Alberts

3,542

Hi all

When I try to refresh the Data Entity list I get an error "Change Tracking is not enabled on the database: SQL Server Change Tracking".

Screenshot-2019_2D00_08_2D00_08-at-09.41.50.png

I got this about a week ago and then it magically disappeared again after a while.

How do I fix this? I am aware of change tracking & data entities. But this seems like something went wrong in SQL Server Management?

Thanks for reading

Categories:

Data Integration

Development / Customization / SDK

I have the same question (0)

All responses (7)

Answers (1)

Pete Alberts 3,542 on at

Like (0)

Report

RE: Refresh Entity List error: Change Tracking is not enabled on the database

Well it went away again after a project build (no changes).

Was this reply helpful? Yes No
Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: Refresh Entity List error: Change Tracking is not enabled on the database

May be full build of package and sync will help you.

Was this reply helpful? Yes No
Ajit 8,755 on at

Like (1)

Report

RE: Refresh Entity List error: Change Tracking is not enabled on the database

Did this happened after restoring DB?

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

RE: Refresh Entity List error: Change Tracking is not enabled on the database

Mr Sherlock Holmes - we have missed you :) You are correct!

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

RE: Refresh Entity List error: Change Tracking is not enabled on the database

Could you explain why this happens? I haven't done a DB restore recently, so haven't been able to confirm your suspicion. But I am reasonably sure that both times I got the error were soon after a DB restore.

I hope I did not seem rude with my previous response. I was truly very impressed.

Was this reply helpful? Yes No
Verified answer

Ajit 8,755 on at

Like (1)

Report

RE: Refresh Entity List error: Change Tracking is not enabled on the database

No not at all :) I am not sure about the exact root cause but could be because if other environment has more or less entities and tables involved like DMFEntities and all are messed up. Did this issue resolved by running full build and DB Sync?

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

RE: Refresh Entity List error: Change Tracking is not enabled on the database

Makes sense!

It went away after a project build. I am currently working with data entities... So I guess when an entity or two got synced DMFEntities sorted itself out.

Thanks!

Was this reply helpful? Yes No