Event ID 13360, "Arithmetic overflow occurred", error thrown attempting to apply Legal Holds in Symantec Enterprise Vault (EV) Discovery Accelerator (DA).

Article:TECH182409  |  Created: 2012-02-27  |  Updated: 2013-12-17  |  Article URL http://www.symantec.com/docs/TECH182409
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Environment

Issue



Legal holds fail to be applied, with the error below thrown into the Symantec Enterprise Vault Event Log on the Symantec Discovery Accelerator (DA) Server.

 


Error



Event ID: 13360
Event Type: Error
Description:

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
occurred.

SQL Command: uspi_SavesetHold

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


Environment



- Symantec Enterprise Vault 9.0 SP2 or 9.0 SP3 on Microsoft Windows Server 2008 R2.
- Symantec Discovery Accelerator 9.0 SP2 or 9.0 SP3 on Microsoft Windows Server 2008 R2 with 30 Discovery Customers.


Cause



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.

WORKAROUND:
Stop Storage Expiry from running against any archives with this issue until the fix can be obtained and applied.


Solution



This issue has been addressed in the following release:
 

Hotfix for Enterprise Vault Discovery Accelerator 9.0 SP3 - Cannot apply any new Legal Holds against a specific Vault Store as the HoldIdentity value of the HoldSaveset table has nearly reached its maximum value.
http://www.symantec.com/docs/TECH190697

Enterprise Vault 9.0.4
http://www.symantec.com/docs/TECH147785

Enterprise Vault 10.0.2
http://www.symantec.com/docs/TECH147789


Supplemental Materials

SourceEvent ID
Value13360
Description

An error was detected while accessing the Vault
Database 'EVVaultStore' (Internal reference:
CADODataAccess::ExecuteSQLCommand .\ADODataAccess.cpp [lines
{1407,1409,1424,1447}], built Mar 14 10:54:54 2011):

Description:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow
occurred.

SQL Command:
uspi_SavesetHold

Additional Microsoft supplied information:

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: 0x80040e21
SQL State: 01000
Native Error: 00003606
HRESULT 0x80040e21


SourceETrack
Value2697016
Description

DA: Cannot apply any new Legal Holds against a specific Vault Store as the HoldIdentity value of the HoldSaveset table has nearly reached its maximum value.

 


SourceETrack
Value2919945
Description

DA: Cannot apply any new Legal Holds against a specific Vault Store as the HoldIdentity value of the HoldSaveset table has nearly reached its maximum value.  (For DA 9.0 SP4 CHF1)

 



Article URL http://www.symantec.com/docs/TECH182409


Terms of use for this information are found in Legal Notices