5
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (