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

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

Article: 100031674
Last Published: 2015-12-11
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 lenght 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?