Problem
After upgrading to Enterprise Vault (EV) 12.4, an administrator decommissions an EV server, successfully removing all of its Tasks and Services, and attempts to delete it from the Vault Administration Console (VAC). The deletion fails.
Error Message
The following error dialog appears in the VAC:
---------------------------
Enterprise Vault
---------------------------
Failed to delete computer 'EV03' from the Directory.
NULL
---------------------------
OK
---------------------------
The following error appears in the Event Viewer:
Type : Error
Date : 5/1/2019
Time : 5:12:09 PM
Event : 13405
Source : Enterprise Vault
Category : Directory Service
User : N/A
Computer : ev02.ev.local
Description:
A constraint violation error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: {CADODataAccess::ExecuteSQLCommand} [d:\builds\16_\ev\v-m-s\sources\source\common\adointerface\adodataaccess.cpp, lines {1326,1328,1347,1365}, built Nov 1 13:10:58 2018]):
Description:
The DELETE statement conflicted with the REFERENCE constraint "FK_ServerAuditInfo_ComputerEntry". The conflict occurred in database "EnterpriseVaultDirectory", table "dbo.ServerAuditInfo", column 'ComputerIdentity'.
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
For more information, see Help and Support Center at http://telemetry.community.veritas.com/entt?product=ev&language=english&version=12.2.0.0&build=12.2.1.1485&error=V-437-13405
Cause
The new centralized auditing feature in EV 12.4 adds some tables to the EnterpriseVaultDirectory database. The deletion routine that removes an EV server from the VAC does not handle the references to the server in these new tables before attempting to remove the server's record. Therefore a constraint violation occurs and the deletion fails.
Solution
This issue has been addressed in the following release:
Enterprise Vault 12.4.2
Enterprise Vault 12.5
The release is available from the Veritas Support Download Center available here.
Notes:
- You must be logged into the Veritas Support Download Center with an account that has download permissions for Enterprise Vault in order to download the release