Storage Service fails to start after an Upgrade OR Migration from previous version of Enterprise Vault (EV) server, Events 6875 and 13360 generates during startup.

book

Article ID: 100012918

calendar_today

Updated On:

Description

Error Message

Log Name: Enterprise Vault
Source: Enterprise Vault
Event ID: 6875
Task Category: Storage Server
Level: Error
Keywords: Classic
User: N/A
Computer: EVserver1.domain.com
Description:
An error occurred attempting to update Storage database
Reason: The SQL database server detected a deadlock while accessing the Vault Database '#2' Description: #1 Additional Microsoft supplied information: Source: #3 Number: #4 SQL State: #5 Native Error: #6 HRESULT #7 SQL Command: #8 (0xc0043433)
Reference: UVSDBs/uvsdb
Script File: C:\Program Files (x86)\Enterprise Vault\VaultStoreDB_X_Updates.sql
Vault Store: Domino Vault Store
Vault Store Id: 1234EVSERVER
Database Name: EVVSVaultStore_1
DSN: EVVSVaultStore_1

V-437-6875

Log Name: Symantec Enterprise Vault
Source: Enterprise Vault
Event ID: 13360
Task Category: Storage Server
Level: Error
Computer: computername.domain.com
Description: An error was detected while accessing the Vault Database 'Provider=SQLOLEDB;Server=EVSQLSERVER;Database=EVVSVaultStore_1;Integrated Security=SSPI' (Internal reference: CC1):
Description:[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
SQL Command: N/A
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80004005
SQL State: 08001
Native Error: 00000014
HRESULT  0xc0043433

V-437-13360

Cause

ODBC had "Dynamically determine port" enabled on EV databases.

Resolution

  1. Open Data Sources (ODBC) on the Enterprise Vault Server from the command prompt. The location is the Windows directory and \SysWOW64 and the odbcad32.exe.
    Note: you cannot open from the GUI because it will open the 64 bit version and not have anything to configure.
  2. Select System DSN tab.
  3. Select the EnterpriseVaultDirectory entry.
  4. Select the Configure button.
  5. Run through the Wizard:
  6. Verify the settings for the SQL Server and click next.
    Click on the Client Configuration button and then uncheck the "Dynamically determine port" option and specify the port used by the SQL Server.
     
  7. Move through the rest of the settings by verifying and clicking next, at the end, click on Finish and apply the changes.
    Repeat Steps 3 through 6 for each Enterprise Vault database that resides on the new SQL server.

Issue/Introduction

The start of the Directory Service seems to work fine. The Storage Service tries to start and shuts down after 1-2 minutes with Events 6875 and 13360 in EV Event log.