Hotfix for Symantec Enterprise Vault (EV) 8.0 SP4, Build 1991, 13360 An error was detected while accessing the Vault Database - "The INSERT statement conflicted with the CHECK constraint"

Article:TECH135607  |  Created: 2010-01-30  |  Updated: 2010-01-30  |  Article URL http://www.symantec.com/docs/TECH135607
Article Type
Technical Solution


Environment

Problem



Hotfix for Symantec Enterprise Vault (EV) 8.0 SP4, Build 1991, 13360 An error was detected while accessing the Vault Database - "The INSERT statement conflicted with the CHECK constraint"

Solution



Which versions of Symantec Enterprise Vault (tm) can this hotfix be applied?
This hotfix can only be applied to the following versions of Enterprise Vault for:

Enterprise Vault for Microsoft Exchange 8.0 SP4, Build 1991

What issues does this hotfix resolve?

ETrack 1737776
13360 SQL CHECK constraint conflict events logged by StorageOnlineOpns during Virtual Vault/Vault Cache synchronization when processing item meta data update requests.

Files updated?

Vault_uspu_Saveset_JournalUpdate_1737776.sql


How to Install this hotfix:

1. Place EV Services in Backup Mode

2. Backup Enterprise Vault Store Databases

3. Logon with the DB Owner role to SQL hosting EV Database and execute script Vault_uspu_Saveset_JournalUpdate_1737776.sql on every Vault Store Database,
 
4. Restore EV Services to normal operation

How to Uninstall this hotfix:

1. Stop all EV services.

2. Restore Enterprise Vault Store Databases

3. Start the EV services.


Supplemental Materials

SourceETrack
Value1737776
Description13360 An error was detected while accessing the Vault Database - "The INSERT statement conflicted with the CHECK constraint"


Legacy ID



357007


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


Terms of use for this information are found in Legal Notices