Event 13360 - During a Collection run a conflict occur when deleting database references

book

Article ID: 100029038

calendar_today

Updated On:

Description

Error Message

Errors from Event Viewer :

Event Type: Error
Event Source: Enterprise Vault
Event Category: Storage File Watch
Event ID: 13360
Description: An error was detected while accessing the Vault Database 'EVExchangeMBXVaultStore' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1390,1392,1407,1425}] built Nov 2 19:40:47 2009):

Description:
[Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK_CollectionIdentity_Collection". The conflict occurred in database "EVExchangeMBXVaultStore", table "dbo.Saveset", column 'CollectionIdentity'.

SQL Command: EVManageCollections

Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: 0x80040e14
SQL State: 23000
Native Error: 00000547
HRESULT 0x80040e14
​V-437-13360

Event Type: Error
Event Source: Enterprise Vault
Event Category: Storage File Watch
Event ID: 13360
Description:
An error was detected while accessing the Vault Database 'EVExchangeMBXVaultStore' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1390,1392,1407,1425}] built Nov 2 19:40:47 2009): 

Description: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

SQL Command: EVManageCollections

Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: 0x80040e14
SQL State: 01000
Native Error: 00003621
HRESULT 0x80040e14
V-437-13360

Dtrace logging against the StorageFileWatch process shows the corresponding Event Viewer error :

20684 10:00:05.851 [5656] (StorageFileWatch) <12280> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVExchangeMBXVaultStore' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1390,1392,1407,1425}] built Nov 2 19:40:47 2009): |Description: |[Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK_CollectionIdentity_Collection". The conflict occurred in database "EVExchangeMBXVaultStore", table "dbo.Saveset", column 'CollectionIdentity'.| | |SQL Command: | EVManageCollections| | |Additional Microsoft supplied information:| |Source: Microsoft OLE DB Provider for ODBC Drivers |Number: 0x80040e14 |SQL State: 23000 |Native Error: 00000547 |HRESULT|0x80040e14| |

 

Cause

The issue occurs after Storage Expiry runs, and due to Sparse Collection being used the CAB files are deleted from disk, but for some unknown reason the SQL references could not be deleted. The conflict is due to records still present in the Saveset table for the saveset items which have been deleted with the CAB.

 

Resolution

  1. Run EVSVR first in Verify operation with Complete option on the affected Vault Store partition.
  2. This will detect all the Collection Identities in question.
  3. Then run EVSVR in Repair operation with DatabaseLinkages option.
  4. Next run EVSVR in Repair operation with DatabaseReferences option.
  5. Note: Ensure that the Check collection counts checkbox is selected.
  6. Finally run EVSVR in Repair operation with DeleteSurplusReferences option.

Issue/Introduction

During a Collection run an error condition is returned suggesting a conflict when deleting database references associated with CAB files that have been deleted from disk.
Powered by Wolken Software