The Enterprise Vault Directory service fails to upgrade the Directory database with event ID 8557: "The statistics 'MessageClass' is dependent on column 'MessageClass'."
Article ID: 100025992
Updated On:
Description
Error Message
An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: {CADODataAccess::ExecuteSQLCommand} [.\ADODataAccess.cpp, lines {1407,1409,1424,1461}, built Nov 11 21:02:49 2011]):
Description: The statistics 'MessageClass' is dependent on column 'MessageClass'.
SQL Command:
IF EXISTS(SELECT * FROM syscolumns WHERE name = 'MessageClass' AND length = 2*127 AND id IN (SELECT id FROM sysobjects WHERE name = 'ExchangeManagedContentSetting' AND xtype = 'U'))
BEGIN
ALTER TABLE [dbo].[ExchangeManagedContentSetting] ALTER COLUMN [MessageClass] nvarchar(MAX) NOT NULL
END
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80040e14
SQL State: 42S03
Native Error: 00005074
HRESULT 0x80040e14
V-437-8557
Cause
There is a third-party statistic attached to the SQL table ExchangeManagedContentSetting, with a constraint that prevents the Directory service from completing required alterations on the MessageClass column
Note: There may be other tables with similar third-party statistics. Each will generate a similar error, and will need to be identified one at a time.
Resolution
The upgrade must be permitted to perform alterations of tables and columns in the Directory database. Third-party statistics that have been added to the Directory database which restrict alterations will need to be removed.
Issue/Introduction
