Hotfix for Enterprise Vault 2007 Service Pack 3 (SP3), Build 2138 and Enterprise Vault Compliance Accelerator 2007 SP3, build 5169, transaction resolver functioning very slow.

Article:TECH68105  |  Created: 2009-01-20  |  Updated: 2010-01-21  |  Article URL http://www.symantec.com/docs/TECH68105
Article Type
Technical Solution

Product(s)

Environment

Issue



Hotfix for Enterprise Vault 2007 Service Pack 3 (SP3), Build 2138 and Enterprise Vault Compliance Accelerator 2007 SP3, build 5169, transaction resolver functioning very slow.

Solution



To which version of Symantec Enterprise Vault (tm) can this hotfix be applied?
This hotfix can only be applied to the following version of Enterprise Vault:
Enterprise Vault 2007 SP3, build 2138

What issue does this hotfix resolve?
Statistical random sampling process does not complete due to slow performance of usps_SavesetIdentifiers  Stored Procedure(SP) in the vaultStore database resolving the saveset ids for the items to be added to the review.  The slow performance of the stored procedure has only been observed in SQL 2000 SP4 server.

Below is a sample of what will show on the dtrace of the Accelerator Service:
117449 09:20:10.083 [6324] (AcceleratorService) <Transaction Resolver:4804> EV-M {Vaults} {C5} Fetching unresolved transactions starting with VaultItem > 0...
117464 09:20:10.129 [6324] (AcceleratorService) <Transaction Resolver:4804> EV-M {TransactionResolver} {C5} Looking up 500 unresolved transactions...
117471 09:20:10.192 [6324] (AcceleratorService) <4804> EV:L CAutoStorageOnline::GetSaveSetIDs (Entry) |
117472 09:20:10.192 [6324] (AcceleratorService) <4804> EV:M CAutoStorageOnline::GetSaveSetIDs|Getting SSIDs : 2
1505370 10:58:50.734 [6324] (AcceleratorService) <4804> EV:M CAutoStorageOnline::GetSaveSetIDs (Exit) |Success  [0] |
1505739 10:58:52.062 [6324] (AcceleratorService) <Transaction Resolver:4804> EV-M {TransactionResolver} {C5} Resolved 500 of 500 transactions.

What files does this hotfix replace?
A new SQL script "753-0309 usps_SavesetIdentifiers.sql" has been created to update the usps_SavesetIdentifiers SP in the vault store database.

How to intall this hotfix:
1.  Backup the vault store databases.
2.  Run sql script "753-0309 usps_SavesetIdentifiers.sql" against each vault store database.

How to uninstall this hotfix:
1.  Restore the backup copy of the vault store database.

Note:  This issue has been addressed as part of the following release:
Enterprise Vault 2007 Service Pack 5 (SP5)
 http://entsupport.symantec.com/docs/308963


Supplemental Materials

SourceETrack
Value1458867
DescriptionEscalation document tracking the investigation of the issue.

Legacy ID



319967


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


Terms of use for this information are found in Legal Notices