Event ID: 13363
The SQL database server detected a deadlock while accessing the Vault Database 'EnterpriseVaultDirectory'| |
Description: | |Transaction (Process ID 210) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.|
Additional Microsoft supplied information:|
Source: Microsoft OLE DB Driver for SQL Server
Number: 0x80004005
SQL State: 40001
Native Error: 00001205
HRESULT 0xc0043433
SQL Command: SELECT DISTINCT ElasticIndexIdentity,ElasticIndexUUID,ElasticIndexName,IndexedItems,IndexSizeInMB,IndexStatus,IndexSourceType,ShardsDetailsXML FROM ElasticIndexView WHERE ElasticIndexUUID = ?
This issue is caused due to the missing non-clustered index on the "ElasticIndex" table present in EV Directory database.
This issue has been addressed in Enterprise Vault 14.2.3 which is available from Downloads.
SQL server deadlock is seen intermittently while updating the 'ElasticIndex' table from Enterprise Vault (EV) Directory database while items are being indexed.
JIRA: CFT-4912