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 |
Antivirus software on the SQL server is preventing EV from successfully upgrading the EnterpriseVaultDirectory database.
Disable all antivirus software on the SQL server for the duration of the EV upgrade.