Navision Change Log Gaps

eparty

Hello,

I am analyzing the Navision change log and have identified gaps in the Entry_No field. The natural conclussion is that someone has been deleting the change log, however I was wondering if there maybe another explanation for this. For a period of about 10 months, there were approximately 40 gaps detected. Any input on this will be greatly appreciated!

Many thanks!!!

P.S. The Navision version is 3.70

nunomaia

Entry No. it’s not generated directly from C/AL, its used auto increment. Auto increment doesn’t guaranties that numbers are consecutive.

The numbers that are assigned will not necessarily be consecutive because:

If you delete some records from a table, the numbers that are used in these records will not be reused.

If several transactions are being performed at the same time, they will each be assigned a different number. However, if one of these transactions is rolled back, the number that it was assigned cannot be reused.

kine

Yes, exactly, there were some transactions which were rolled back...

eparty

Thank you very much for taking the time to clarify this for me!!!