Upgrade of EnterpriseVaultDirectory database fails. Event IDs 13407 and 13400.

book

Article ID: 100010777

calendar_today

Updated On:

Description

Error Message

DTrace of DirectoryService shows the following:

3823 13:24:56.370 [2864] (DirectoryService) <2912> EV~I Event ID: 13399 Database: EnterpriseVaultDirectory|Starting to execute the following SQL Script:|C:\Program Files (x86)\Enterprise Vault\DirectoryDB_10_Updates2.sql| |

3824 13:24:56.526 [2864] (DirectoryService) <2912> EV:L Script LogComment Identified

3825 13:24:56.604 [2864] (DirectoryService) <2912> EV:L Script LogComment Identified

3826 13:24:58.647 [2864] (DirectoryService) <2912> EV:H {CADODataAccess::ExecuteSQLCommand} HRXEX fn trace : Error [0x80040e14], ref(1): [ESC14], [.\ADODataAccess.cpp, lines {1317,1319,1335,1372}, built Jul 10 17:51:36 2013].

3827 13:24:58.647 [2864] (DirectoryService) <2912> EV~W Event ID: 13407 The Vault Database 'EnterpriseVaultDirectory' is in SINGLE USER Mode and can only have one user at a time. (Internal reference: {CADODataAccess::ExecuteSQLCommand} [.\ADODataAccess.cpp, lines {1317,1319,1335,1372}, built Jul 10 17:51:36 2013]): |Description:  |Database 'EnterpriseVaultDirectory' is already open and can only have one user at a time.| | |SQL Command: | |EXEC CleanupColumnVariableData| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00000924 |HRESULT|0x80040e14| |

3828 13:24:58.647 [2864] (DirectoryService) <2912> EV~I Event ID: 13400 Database: EnterpriseVaultDirectory|Completed execution of the following SQL Script:|C:\Program Files (x86)\Enterprise Vault\DirectoryDB_10_Updates2.sql| |

3829 13:24:58.647 [2864] (DirectoryService) <2912> EV:L DirectoryService: STARTUP: UpdateDatabase: Failed to obtain connection or set single user mode |

 

Cause

Antivirus software on the SQL server is preventing EV from successfully upgrading the EnterpriseVaultDirectory database.

 

Resolution

Disable all antivirus software on the SQL server for the duration of the EV upgrade.

Issue/Introduction

Upgrade of the EnterpriseVaultDirectory database fails when starting the Enterprise Vault Directory database after an Enterprise Vault upgrade.