Records in the JournalDelete table referencing the storage queue may cause misleading monitoring warnings

book

Article ID: 100047949

calendar_today

Updated On:

Description

Error Message

Event 41022

There are X items that have been deleted from Vault Store Y but have not yet been deleted from the indexes.

V-437-41022

Cause

In Enterprise Vault, items are not indexed until they are in their destination partition, so records in this state are for items that were never indexed, and don't need to be removed from the index.

To check for this issue, the following SQL query can be run against the vault store database referenced in the event log warning:

select count(*)
from JournalDelete
where IdPartition = -1

Resolution

This issue has been resolved in the following release which is available from Downloads

Enterprise Vault 12.5.3 

Issue/Introduction

Misleading monitoring warnings may issue when records in JournalDelete table in a vault store database reference the storage queue. These records have IdPartition=-1 and IndexCommitted=0

Additional Information

JIRA: CFT-2953