Legal holds fail to be applied, with the error below thrown into the Enterprise Vault Event Log on the Discovery Accelerator (DA) Server.
Event ID: 13360
Event Type: Error
An error was detected while accessing the Vault
Database 'EVVaultStore' (Internal reference:
CADODataAccess::ExecuteSQLCommand .\ADODataAccess.cpp [lines
Description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow
SQL Command: uspi_SavesetHold
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for ODBC Drivers
SQL State: 01000
Native Error: 00003606
The items on which the Legal Holds are to be placed reside in one or more Vault Store (VS) databases.
Each VS database contains a HoldSaveset table to contain information about each item that is on Legal Hold.
The Legal Holds are identified in this table with a HoldIdentity value that is defined as a type 'int' field.
In Microsoft SQL Server, a field of type 'int' is limited to a maximum number of 2,147,483,647.
When the HoldIdentity nears this maximum limit, Legal Holds can no longer be applied to the Vault Store contents.
Stop Storage Expiry from running against any archives with this issue until the fix can be obtained and applied.
This issue has been addressed in the following release:
- Enterprise Vault 9.0 SP2 or 9.0 SP3 on Microsoft Windows Server 2008 R2.
- Discovery Accelerator 9.0 SP2 or 9.0 SP3 on Microsoft Windows Server 2008 R2 with 30 Discovery Customers.