Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enable Change Tracking for cloud databases #840

Open
kristofferwebmind opened this issue Oct 7, 2024 · 0 comments
Open

Enable Change Tracking for cloud databases #840

kristofferwebmind opened this issue Oct 7, 2024 · 0 comments

Comments

@kristofferwebmind
Copy link

Issue description

Cms 13.4.1
Forms 13.2.4
Deploy 13.2.1

Request: Enable Change Tracking for the cloud databases

If Change Tracking is enabled, it allows us to inspect the history of the database transactions which in some cases are necessary to understand when a collision error has occured.

Background / Motivation

We have a situation where there are multiple collision errors that we can not track the origin of due to the nature of the error.
The error is that duplicates of doctypes are stored in the schema, one for a value stored only in the database and one for a value stored only on uda-file, like so:

image

For the first reference:
image
For the second reference:
image

For the value stored in the database (first reference above) there is no correlating uda-file.
A git command looking for the supposedly deleted file yields no results:

image

The only way I can think of to find out what happened and/or when it happened would be if we could see the timestamp on the value in the database.

If Change Tracking had been enabled for the database, I believe we could have seen that.

More about Change Tracking: https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server?view=sql-server-ver16

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant