Unable to delete Enterprise Vault (EV) Server from Admin console, Event 13360 CONS_FK_COMPUTERENTRY_TRACEENTRY
Problem
Unable to delete an Enterprise Vault (EV) server from Vault Admin Console (VAC), Event 13360 logged with reference conflict in constraint "CONS_FK_COMPUTERENTRY_TRACEENTRY"
Error Message
Event: 13360
Source: Enterprise Vault
Category: Directory Service
Description:
An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Apr 12 00:45:28 2010):
Description:
The DELETE statement conflicted with the REFERENCE constraint "CONS_FK_COMPUTERENTRY_TRACEENTRY". The conflict occurred in database "EnterpriseVaultDirectory", table "dbo.TraceEntry", column 'ComputerEntryId'.
SQL Command: DeleteComputer
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80040e2f
SQL State: 23000
Native Error: 00000547
HRESULT 0x80040e2f
Cause
Saved traces remain for the target server.
Solution
This issue can be resolved by deleting the saved traces from Vault Admin Console.
1. Login to Enterprise Vault (EV) Server with Vault Service Account (VSA) credentials.
2. Open Vault Admin Console (VAC) and go to Tools in top menu bar.
3. Select Advanced Features
4. Refresh the console by pressing F5 at the Enterprise Vault Servers option.
5. Expand the Enterprise Vault Servers container and then <Enterprise Vault server name>
6. Select Traces
7. Remove all saved traces.
Note: If the issue persists with same event, even after removing traces from Vault Admin console, then contact Veritas Technical Support for further instructions.