Announcements
Hi there
I am analysing the change log entries of one of our customers. I found a lot of gaps in the change log entries from navision. My question is how can that happen except some one deleting the rows.
Maybe because of a rollback or something? The gaps appear in the entry numbers.
Cheers
Can
Hi
Also you can check some users are using 'Delete Change Log Entries' batch job by applying certain filters.
Hi,
the Entry No. in the change log entry table has the AutoIncrement property. This means that it is the SQL server who puts in the numbers in the table. If a number is once used it will not be used again and if there are some transactions which do have a rollback, then you do have gaps.
You can check here in the docs.
https://docs.microsoft.com/en-us/dynamics-nav/autoincrement-property
Hope that helps.
Best regards
Andreas Günther
Escalation Engineer
Microsoft Dynamics NAV / Business Central
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156