Hotfix for Enterprise Vault Compliance Accelerator and Discovery Accelerator 2007, Build 3945, Search(s) hung in 'Accepting'.

Article:TECH55461  |  Created: 2007-01-12  |  Updated: 2007-01-13  |  Article URL http://www.symantec.com/docs/TECH55461
Article Type
Technical Solution


Environment

Issue



Hotfix for Enterprise Vault Compliance Accelerator and Discovery Accelerator 2007, Build 3945, 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 2007, Build 3945
Enterprise Vault Discovery Accelerator 2007, Build 3945


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 Etrack1139388.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 Etrack1139388.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 2007 Service Pack 1 (SP1), Build 4181.

Symantec Enterprise Vault Discovery Accelerator 2007 Service Pack 1 (SP1), Build 4181.

Attachments

ETrack1139388_294059.zip (1 kBytes)

Supplemental Materials

SourceETrack
Value1139388
DescriptionDA Searches are stuck in Accepting Mode...

SourceETrack
Value1155504
DescriptionCA Searches are stuck in Accepting Mode...

SourceEvent ID
Value287
DescriptionViolation of PRIMARY KEY constraint 'PK_tblSearchVaultsArchived'. Cannot insert duplicate key in object 'dbo.tblSearchVaultsArchived'.


Legacy ID



294059


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


Terms of use for this information are found in Legal Notices