Event 41533 - EVDatabaseUpgrader failed - Arithmetic overflow error converting expression to data type int

Event 41533 - EVDatabaseUpgrader failed - Arithmetic overflow error converting expression to data type int

Article: 100013978
Last Published: 2015-03-31
Ratings: 0 0
Product(s): Enterprise Vault

Problem

While upgrading to EV 11  the EVDatabaseUpgrader fails while processing the directory database.  Error states "Failed to upgrade Directory database" and the DB_Upgrade_Log.txt specifies an exception stating "Arithmetic overflow error converting expression to data type int".  

Error Message

Event : 41533
Source : Enterprise Vault
Category : Database Upgrader
Description:
EVDatabaseUpgrader failed.
Failed to upgrade Directory database. Database:[EnterpriseVaultDirectory] Server:[<SERVER_NAME>].

Failed to execute command. Script: [D:\Program Files (x86)\Enterprise Vault\DirectoryDB_11_Migrate.sql] Line: [163] Command: [/*****************************
V-437-41533

**Event may also contain contents of SQL Update Script**

Cause

This issue occurs when PST Migrations is in use and the sum of all the PST file sizes associated with a single user/computer exceeds 2 Terra Bytes in size.

Solution

 Confirm that the issue is present using the steps below

  1. Collect the DB_Upgrade_Log.txt from the following location "<EnterpriseVault_Install_Path>\Reports"
     
  2. Open the file and search for "EXCEPTION:"
  3. Confirm the exception states the following

    "{DIRECTORYDB.EN_US} EXCEPTION: Failed to upgrade Directory database. Database:[EnterpriseVaultDirectory] Server:[sqlserver].
    Veritas.EnterpriseVault.EVDatabaseUpgrader.ExecuteCommandException: Failed to execute command. Script: [D:\Program Files (x86)\Enterprise Vault\DirectoryDB_11_Migrate.sql] Line: [163] Command:"

  4. Confirm that further down in the error that the following text is present

    System.Data.SqlClient.SqlException: Arithmetic overflow error converting expression to data type int.
    Arithmetic overflow error converting expression to data type int.
    The statement has been terminated.
    Warning: Null value is eliminated by an aggregate or other SET operation.
    The statement has been terminated.
    Warning: Null value is eliminated by an aggregate or other SET operation.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Veritas.EnterpriseVault.EVDatabaseUpgrader.ScriptExecutor.ExecuteCommand(ScriptCommand command)
    --- End of inner exception stack trace ---
    at Veritas.EnterpriseVault.EVDatabaseUpgrader.ScriptExecutor.ExecuteCommand(ScriptCommand command)
    at Veritas.EnterpriseVault.EVDatabaseUpgrader.ScriptExecutor.RunScript(String scriptPath, String scriptName)
    at Veritas.EnterpriseVault.EVDatabaseUpgrader.DirectoryDB.DoLatestUpdates(DBSchema& directoryDBSchemaVersion)
    at Veritas.EnterpriseVault.EVDatabaseUpgrader.DirectoryDB.UpdateDirectoryDB()"

  5. If the exact error is present, contact Technical Support referencing this article

 

This issue has been addressed in the following release:

Enterprise Vault 11.0.1 – Release Details
https://www.veritas.com/docs/DOC8024
 


References

Etrack : 3593659 Etrack : 41533

Was this content helpful?