Hotfix for Enterprise Vault Compliance and Discovery Accelerator 7.0 Service Pack 2 (SP2), Build 1031, Search(s) hung in 'Accepting'.
| Article:TECH55465 | | | Created: 2007-01-12 | | | Updated: 2007-01-13 | | | Article URL http://www.symantec.com/docs/TECH55465 |
Problem
Hotfix for Enterprise Vault Compliance and Discovery Accelerator 7.0 Service Pack 2 (SP2), Build 1031, Search(s) hung in 'Accepting'.
Error
Event 287 - Violation of PRIMARY KEY constraint 'PK_tblSearchVaultsArchived'. Cannot insert duplicate key in object 'dbo.tblSearchVaultsArchived'.
Solution
To 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:
Enterprise Vault Compliance
Accelerator 7.0 SP2, Build 1031
Enterprise Vault Discovery
Accelerator 7.0 SP2, Build 1031
What issue does this hotfix resolve?
Search(s) may hang in an
'Accepting' status. The following event error may
also be seen:
Type:
Error
Event:
287
Source:
Accelerator Service Processor
Category:
None
Description:
The
description for Event ID ( 287 ) in Source ( Accelerator Service
Processor )
could
not be found. It contains the following insertion string(s):
.
APP
AT - Customer ID: 1 - Error accepting a Search: Accepted Search Thread -
worker
thread (0)
Search
ID: 2086
Number
of tries: 5
Cause:Violation
of PRIMARY KEY constraint 'PK_tblSearchVaultsArchived'. Cannot
insert
duplicate key in object 'dbo.tblSearchVaultsArchived'.
The
statement has been terminated.
What table(s) does this hotfix modify?
This
hotfix replaces an index on tblIntDiscoveredItems
How to install this hotfix:
Compliance Accelerator Server
1. Stop the Enterprise
Vault Accelerator Manager Service.
2. Backup the Compliance
Accelerator customer database.
3. Download provided zip
file using the 'Download Now' link.
4. Open Query Analyzer and
run Etrack1139393.sql against the Compliance Accelerator
customer database.
5. Restart the Enterprise
Vault Accelerator Manager Service
Discovery Accelerator Server
1. Stop the Enterprise
Vault Accelerator Manager Service.
2. Backup the Discovery
Accelerator customer database.
3. Download provided zip
file using the 'Download Now' link.
4. Open Query Analyzer and
run Etrack1139393.sql against the Discovery Accelerator
customer database.
5. Restart the Enterprise
Vault Accelerator Manager Service
How to uninstall this hotfix:
Compliance Accelerator
Server
1. Stop the Enterprise
Vault Accelerator Manager Service.
2. Restore the Compliance
Accelerator customer database.
3. Start the Enterprise
Vault Accelerator Manager Service.
Discovery Accelerator
Server
1. Stop the Enterprise
Vault Accelerator Manager Service.
2. Restore the Discovery
Accelerator customer database.
3. Start the Enterprise
Vault Accelerator Manager Service.
Note: This issue has been addressed as part of the following releases:
Symantec Enterprise Vault Compliance Accelerator 7.0 Service Pack 3 (SP3), Build 5030
http://entsupport.symantec.com/docs/293745
Symantec Enterprise Vault Discovery Accelerator 7.0 Service Pack 3 (SP3), Build 5030
http://entsupport.symantec.com/docs/293744
Symantec Enterprise Vault Compliance Accelerator 2007 Service Pack 1 (SP1), Build 4181
http://entsupport.symantec.com/docs/292998
Symantec Enterprise Vault Discovery Accelerator 2007 Service Pack 1 (SP1), Build 4181
http://entsupport.symantec.com/docs/292999
Attachments
|
|
| Source | ETrack |
| Value | 1139393 |
| Description | DA Searches are stuck in Accepting Mode... |
| Source | Event ID |
| Value | 287 |
| Description | Violation of PRIMARY KEY constraint 'PK_tblSearchVaultsArchived'. Cannot insert duplicate key in object 'dbo.tblSearchVaultsArchived'. |
Related Articles
Legacy ID
294063
Article URL http://www.symantec.com/docs/TECH55465
Terms of use for this information are found in Legal Notices
Thank you.