Enterprise Vault - SQL Query to find number of items awaiting indexing

SELECT Count(*) FROM JournalArchive WHERE IndexCommited = '0'

 

Note: it should be ran on the Vault Database

Enterprise vault Indexing problem – event id 41021

Problem:

Enterprise Vault v10.0.2.

We noticed getting the event id 41021:

Log Name:      Symantec Enterprise Vault

Source:        Enterprise Vault

Date:          7/22/2013 11:32:37 AM

Event ID:      41021

Task Category: Monitoring

Level:         Warning

Keywords:      Classic

User:          N/A

Computer:      VAULTSERVER.MYDOMAIN.com

Description:

There are 524628 archived items in Vault Store 'VAULTNAME' that are waiting to be indexed.

There may be a problem with Enterprise Vault indexing.

You can use the System Status feature in the Administration Console to help you resolve this issue.

For more information, see Help and Support Center at http://entced.symantec.com/entt?product=ev&language=english&version=10.0.2.0&build=10.0.2.1112&error=V-437-41021

All Indexes appear to be Healthy and Online.

Synchronizing the Index in question was looping.

Solution:

By looking into the earlier events (1 week earlier) – we noticed Index Failure events for the most recent volume of the Index in question.  Even though at the time of the event id 41021 the index volume appear to be healthy, it apparently was not.

We started “rebuild” just the most recent volume of the index and it completed with 12 hours and all problems got cleared.

How to change type of messages in the mailbox (Useful for dealing with Symantec Enterprise Vault)

DocMessageClass Utility allows changing type of messages from IPM.Note.PendingArchive (or PendingArchivePart) to IPM.Note (ie. normal message).  http://www.plustech.co.uk/Products/downloads/DocMessageClass.zip

I used it many times and found very useful. 

HOWTO reactivate the employee in Enterprise Vault Compliance Accelerator v9sp3

Find the AddressOwnerID of the reactivated employee by running following query on the customer DB: SELECT AddressOwnerID, DisplayName FROM tblAddressUser WHERE Surname='Last Name' After findng AddressOwnerID, supply it into the following query and run on the customer DB: UPDATE tblAddressUser SET Deactivated=0 WHERE AddressOwnerID=AddressOwnerID from the query above

Symantec Enterprise Vault v9.0.x and Microsoft clustering

Failing over to the second node of Microsoft Cluster does not work if you use Enterprise Vault v.9.0.2. To fix this problem must upgrade to Enterprise Vault v.9.0.3.