Hotfix for Symantec Enterprise Vault (EV) for Microsoft Exchange 10.0.1, Build 1171, Unable to post process the watchfile items due to abnormally large backlog in Watchfile

Article:TECH191119  |  Created: 2012-06-15  |  Updated: 2013-02-19  |  Article URL http://www.symantec.com/docs/TECH191119
Article Type
Technical Solution


Environment

Issue



Unable to post process the watchfile items due to abnormally large backlog in Watchfile


Error



Event: 13344 An error was detected while accessing the Vault Database {CADODataAccess::ExecuteSQLCommand} [.\ADODataAccess.cpp, lines (14) Not enough storage is available to complete this operation.


Cause



When StorageFileWatch queried a Vault Store database for savesets and SIS parts to be verified, the result set returned could be very large. In some cases, the result set could not be processed due to its size.


Solution



Description of solution
=======================
The query will be broken up into batches. StorageFileWatch will iterate through the whole range until all the entries are processed, skipping 'empty' batches if needed.


Files updated
=============
StorageFileWatch.exe 10.0.1.1190

New files
=========
2756210.sql
Undo 2756210.sql


Installation instructions
===========================
On each Enterprise Vault server running an Enterprise Vault Storage service:
1. Stop the Enterprise Vault Storage service.
2. Once the Storage service has stopped, take a backup copy of "StorageFileWatch.exe", locatable in the Enterprise Vault installation folder (which by default is "C:\Program Files (x86)\Enterprise Vault").
3. Copy the updated "StorageFileWatch.exe", packaged in this hotfix, to the Enterprise Vault installation folder, replacing the original.

On the SQL server:
4. Run the script [2756210.sql] against each Vault Store database.

On each Enterprise Vault server running an Enterprise Vault Storage service:
5. Start the Enterprise Vault Storage service.


Note: If a new Vault Store is subsequently created, [2756210.sql] will need to be run against the corresponding Vault Store database to apply the fix to that Vault Store.


Uninstallation instructions
===========================
On each Enterprise Vault server running an Enterprise Vault Storage service:
1. Stop the Enterprise Vault Storage service.
2. Once the Storage service has stopped, replace the hotfixed version of "StorageFileWatch.exe" with the backup copy taken during installation of this hotfix.

On the SQL server:
3. Run the script [Undo 2756210.sql] against each Vault Store database.

On each Enterprise Vault server running an Enterprise Vault Storage service:
4. Start the Enterprise Vault Storage service.


Attachments

EV_10.0.1_HF_ET_2756210-SFW batch processing of SISParts.zip
EV_10.0.1_HF_ET_2756210-SFW batch processing of SISParts.zip (672 kBytes)

Supplemental Materials

SourceETrack
Value 2756210
Description

SFW does not process in timely manner when processing the large Backlog on Watchfile


SourceEvent ID
Value13344
Description

An error was detected while accessing the Vault Database {CADODataAccess::ExecuteSQLCommand} [.\ADODataAccess.cpp, lines (14) Not enough storage is available to complete this operation.


SourceUMI
ValueV-437-13344
Description

An error was detected while accessing the Vault Database {CADODataAccess::ExecuteSQLCommand} [.\ADODataAccess.cpp, lines (14) Not enough storage is available to complete this operation.



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


Terms of use for this information are found in Legal Notices