Event 13360 and 6796 Error converting data type varchar to datetime

Problem

An attempt to archive an item into Enterprise Vault (EV) fails. The associated events 13360 and 6796 are placed in the event viewer. Review of the description illustrates an 'Error converting data type varchar to datetime'.

Error Message

Event ID 13360
Category: Storage Archive
An error was detected while accessing the Vault Database 'EVEVAULT01' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand)
Description: Error converting data type varchar to datetime.

SQL Command: uspi_Saveset

Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80040e07
SQL State: 22018
Native Error: 00008114
HRESULT 0x80040e07
V-437-13360

Event ID 6796
Category: Storage Archive
A COM exception has been raised. <0x80040e07> Internal reference .\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset)
An exception is raised when a process encounters an unexpected fault.
V-437-6796

Cause

A mismatch of the EV components could have occurred because of a partial or failed upgrade. Any differences, for whatever the reason, will result in loss of functionality within the product. There are three components in total, EV Binary Version, EV Directory Database Version and EV VaultStore Database Version and they must be in alignment.

Solution

Query and align, if necessary, the three components of EV.  Refer to 000038374 for a listing of each component version.

1. Login to SQL Server with an administrative privileged account.
2. Open SQL Management Studio
3. Execute the EV Directory Database Schema Version using the following SQL query:

USE EnterpriseVaultDirectory
SELECT SchemaVersion
FROM DirectoryEntry

    4. Execute the EV VaultStore Database Schema Version using the following SQL query:

USE EnterpriseVaultDirectory
SELECT SchemaVersion
FROM VaultStoreEntry

 5. Confirm the version of the installed binaries on a server:

1. Open the Vault Administration Console.
2. Right click on Enterprise Vault, found under Console Root.
3. Click on About.

OR

The EV binaries version can be found in the registry:

[HKEY_LOCAL_MACHINE\SOFTWARE\KVS\Enterprise Vault\Install]
"Version"=

On a 64bit OS everything is under a WOW6432Node key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\KVS\Enterprise Vault\Install]

Note: In a building blocks environment ensure all Enterprise Vault servers are running the same version. An out of step server will fail.