Question:

When pulling a report, why are there sequential gaps between document IDs of Vault documents?

Answer:

When Vault begins the process of creating a document, the next available Document ID is assigned to that specific create document transaction.

If a document creation fails for any reason, the Document ID that is assigned to that transaction can never be used again for any future document create transactions.

This can cause gaps in Document ID sequences. Although Document IDs are created in sequential order, there could be another process running in parallel that failed to create a document. Thus, a gap in Documents IDs is the result of the document creation failure.