SQL Deadlocks can occur between different processes executing the usp_SavesetFinishInsert5 stored procedure during Archiving or Journaling
This issue has been addressed in the following release:
Enterprise Vault 12.2
Note: For information on how to obtain latest Enterprise Vault see: Enterprise Vault Download portal
During Mailbox Archiving or Journaling, SQL Deadlocks can occur between different processes (SPIDs) of the execution of the usp_SavesetFinishInsert5 stored procedure.
The deadlock can occur when 2 different processes start within microseconds of each other to process different messages containing the same attachments
The deadlock occurs at the following section:
UPDATE @tbSISParts
SET [SISPartIdentity] = sis.[SISPartIdentity]
FROM SISPart sis
INNER JOIN @tbSISParts tsis
ON tsis.[FPHashPart1] = sis.[FPHashPart1] AND tsis.[FPDistinctionByte] =
sis.[FPDistinctionByte]
AND sis.[FileTransactionId] = tsis.[FileTransactionId] AND tsis.[UniqueId]
= sis.[UniqueId]
AND sis.[IdPartition] = tsis.[IdPartition] AND sis.[VaultStoreIdentity] =
tsis.[VaultStoreIdentity
ETrack: 3907137