Event 13360 Enterprise Vault storage service will not start post upgrade

Article:TECH150186  |  Created: 2011-01-25  |  Updated: 2013-04-05  |  Article URL http://www.symantec.com/docs/TECH150186
Article Type
Technical Solution


Issue



After upgrading the binaries of Enterprise Vault (EV) the storage service will not start generating event 13360 indicating there is a missing index from the database.


Error



Event ID: 13360
Event Category: Storage Server
Description: An error was detected while accessing the Vault Database '' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand)
Description: Could not find any index named 'IX_Vault_ArchivePointIdentity' for table 'dbo.Vault'.
 

SQL Command:

IF NOT EXISTS (select * from dbo.sysindexes where name = 'IX_Vault_ArchivePointIdentity' and origfillfactor = 80)
BEGIN
CREATE INDEX [IX_Vault_ArchivePointIdentity] ON
[dbo].[Vault]([ArchivePointIdentity]) WITH FILLFACTOR = 80, PAD_INDEX,
DROP_EXISTING ON [PRIMARY]
END
 

Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: 0x80040e14
SQL State: 37000
Native Error: 00007999
HRESULT 0x80040e14
V-437-13360
 


Cause



The primary key index IX_Vault_ArchivePointIdentity is missing from a vault store (VS) database. To complete the requested upgrade this index must exist in each VS database. This is applicable for both File System Archiving and Exchange related VSs.
 


Solution



Create the IX_Vault_ArchivePointIdentity index in the database and restart the storage service to complete the upgrade. The index is located in the [VS Database] | Tables | dbo.Vault | Indexes.
 

1. Ensure the storage service has stopped
 

2. Run the following script against the affected VS in Microsoft SQL Server Management Studio to create the missing index:


    IF NOT EXISTS (select * from dbo.sysindexes where name = 'IX_Vault_ArchivePointIdentity' and origfillfactor = 80)
        BEGIN
            CREATE INDEX [IX_Vault_ArchivePointIdentity] ON [dbo].[Vault]([ArchivePointIdentity]) WITH FILLFACTOR = 80, PAD_INDEX ON [PRIMARY]
            print 'index created'
        END
    else
        BEGIN
            print 'index exists'
        END


3. Start the storage service and monitor the progress via event viewer messaging.


Supplemental Materials

SourceEvent ID
Value13360
Description

Description: An error was detected while accessing the Vault Database '' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand)
Description: Could not find any index named 'IX_Vault_ArchivePointIdentity' for table 'dbo.Vault'.

SQL Command:

IF NOT EXISTS (select * from dbo.sysindexes where name = 'IX_Vault_ArchivePointIdentity' and origfillfactor = 80)
BEGIN
CREATE INDEX [IX_Vault_ArchivePointIdentity] ON
[dbo].[Vault]([ArchivePointIdentity]) WITH FILLFACTOR = 80, PAD_INDEX,
DROP_EXISTING ON [PRIMARY]
END



Article URL http://www.symantec.com/docs/TECH150186


Terms of use for this information are found in Legal Notices