Small and medium business | Business Central, N...

Gaps in change log entry

(0) Share

Report

Posted on by Can

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

All responses (2)

Answers (0)

Suggested answer

Genie Cetas 472 on at

Like (0)

Report

RE: Gaps in change log entry

Hi

Also you can check some users are using 'Delete Change Log Entries' batch job by applying certain filters.
Suggested answer

andregu on at

Like (0)

Report

RE: Gaps in change log entry

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