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 for:
Enterprise Vault Compliance Accelerator 2007 Service Pack 1 (SP1), Build 4181
Enterprise Vault Compliance Accelerator 2007 Service Pack 2 (SP2), Build 5053


What issue does this hotfix resolve?
When adding a new employee or when employee synchronization runs the following error can appear in the Compliance application:

Exception of type 'System.Web.HttpUnhandledException' was thrown. - Cannot
insert duplicate key row in object 'dbo.tblAddressUser' with unique
index 'IX_tblAddressUser_EmployeeID'. Error inserting Target Transaction count
after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is
missing. Previous count = 1, current count = 0. The statement has been
terminated.


A corresponding error will appear in the event log:

Type: Error
Date: 2/1/2008
Time: 1:51:34 AM
Event: 28
Source: Accelerator AD Synchronizer
Category: None
User: N/A
Computer: SERVER
Description:
The description for Event ID ( 28 ) in Source ( Accelerator AD Synchronizer  )
could not be found. It contains the following insertion string(s): .
APP AT - Customer ID: 13 - An error occured in
EmployeeSynchroniser::SynchroniseGroupMembers.
System.Data.SqlClient.SqlException: Cannot insert duplicate key row in
object 'dbo.tblAddressUser' with unique index 'IX_tblAddressUser_EmployeeID'.
Error inserting Target
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION
statement is missing. Previous count = 2, current count = 0.
Error Adding a Target During synchronization


Which SQL Stored Procedure(s) does this hotfix affect?

sp_Target_Upd


How to install this hotfix:
1. Backup the existing sp_Target_Upd by scripting a copy:
   
   Sql 2000:
   a. Navigate to and highlight Stored Procedures under the customer database.
   b. Locate sp_Target_Upd
   c. Right click > All Tasks > Generate Sql Script
   d. In the 'Generate SQL Scripts' dialogue window, click OK.  
   e. Provide a File name and save it.

   Sql 2005:
   a. Under the customer database, navigate to: Programmability > Stored Procedures
   b. Locate sp_Target_Upd
   c. Right click > Script Stored Procedure as > CREATE To > File
   d. Provide a File name and save it.

NOTE: The .sql file created in Step 1 will provide as a means to uninstall the hotfix provided in this article.

3. Stop the Enterprise Vault Accelerator Manager Service

4. Download Etrack1199222.sql from the 'Download Now' link below and copy to the Sql server.

5. For Sql 2000, open Query Analyzer, Select File > Open and browse to the file obtained in step 2.    For Sql 2005, open Sql Server Management Studio, Select File > Open > File and browse to the file obtained in step 2.

6. Verify the Compliance customer database is selected in the 'Available Databases' drop down box.  

7. Execute the query

8. Repeat steps 3-5 for any additional Compliance customer databases.

9. Start the Enterprise Vault Accelerator Manager Service


How to uninstall this hotfix:
Sql 2000:

1. Stop the Enterprise Vault Accelerator Manager service.

2. Open Sql Query Analyzer.

3. File > Open

4. Browse to and open the .sql file created in Step 1 in the installation section above.

5. Verify the customer database is selected in the 'Available databases' drop down box.

6. Execute the script.

7. Repeat steps 5 and 6 for any remaining customer databases.

8. Start the Enterprise Vault Accelerator Manager service.


Sql 2005:

1. Stop the Enterprise Vault Accelerator Manager service.

2. Open Microsoft Sql Server Management Studio

3. File > Open > File

4. Browse to and open the .sql file created in Step 1 in the installation section above.

5. Verify the customer database is selected in the 'Available databases' drop down box.

6. Execute the script.

7. Repeat steps 5 and 6 for any remaining customer databases.

8. Start the Enterprise Vault Accelerator Manager service.