Database upgrades complete with warnings.

book

Article ID: 100048226

calendar_today

Updated On:

Description

Error Message

From the Enterprise Vault Management Shell:

Warning: Some databases could not be upgraded:

,: Could not be upgraded. Database remains on version '9.10.4.4.0'. One of the dependent databases failed. 

: Could not be upgraded. Database remains on version '12.0.0.64.0'. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Cause

This issue can be due to an inordinately large number of items in the HoldData table. This issue has been seen when there are over 1 billion items in this table. 

To determine the number of items in the HoldData table please run the following query against the vault store database that is failing to upgrade:

SELECT db_name(), name, rows FROM sys.sysindexes WITH (NOLOCK)
WHERE name IN ('PK_HoldData_1');

 

Resolution

In some situations this issue can be worked around by increasing or doubling the default timeout value of the

-CommandTimeoutSeconds and -ScriptTimeoutSeconds switches for the Start-EVDatabaseUpgrade cmdlet.

Please see the following for more information:

https://www.veritas.com/content/support/en_US/doc/96069939-137825825-0/v114669302-137825825

In cases where this is still not sufficient or may take longer than then maintenance window please call into Enterprise Vault Support and report the issue. 

Issue/Introduction

When upgrading Enterprise Vault from 11.x to 12.x the Start-EVDatabaseUpgrade cmdlet will complete with warnings and errors. One of more vault store databases will fail to upgrade.