PST Locator fails with Event ID 13406 containing 'Error converting data type int to nvarchar'

Article: 100031674
Last Published: 2020-08-26
Ratings: 0 0
Product(s): Enterprise Vault

Problem

In a scenario with 100 or more Active Directory Domains the PST Locator fails with the aforementioned error

Error Message

Description:
A datatype conversion error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: {CADODataAccess::ExecuteSQLCommand} [.\ADODataAccess.cpp, lines {1317,1319,1338,1356}, built Nov 19 15:44:06 2014]):
Description: 
Error converting data type int to nvarchar

SQL Command:
GetDomainIdentity

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

Cause

When PST Locator runs for the first time the assumption is that there will be less than 100 Active Directory Domains; the issue occurs because the temp variable used for the command 'GetDomainIdentity' is defined with a maximum length of 2 digits.
 

Solution

This issue has been addressed in the following releases:
 
Enterprise Vault 11.0.1 Cumulative Hotfix 5  Release
https://www.veritas.com/docs/000106004

Enterprise Vault 12.0.1 Release
https://www.veritas.com/docs/000107756.

Enterprise Vault 12.1 Release
https://www.veritas.com/docs/000107766


 

Was this content helpful?