An EVSVR DirectoryArchives Repair operation can generate "Error deleting surplus Vault record" errors
|Article:TECH210128|||||Created: 2013-08-30|||||Updated: 2014-02-21|||||Article URL http://www.symantec.com/docs/TECH210128|
EVSVR is used to help in repairing Enterprise Vault (EV) SQL Database Inconsistencies, for example following a Disaster Recovery scenario involving a restore of an older version of the SQL Database.
The DirectoryArchives repair option helps in synchronizing the Archive (ArchivePoint) and ArchiveFolder (Vault) records between the EnterpriseVaultDirectory and VaultStore Databases.
The DirectoryArchives repair consists of several steps, and the last step of the repair is Delete surplus Vault Store database Vault records.
This step deletes Vault records that are not needed as part of the repair. For example, ArchiveFolders containing 0 items. E.g.
Deleted surplus Vault record, ArchiveFolder EntryId: 1A35DEE0B03655F45A436A35AEB2823F21110000EVPROD002 ( 50)
Deleted surplus Vault record, ArchiveFolder EntryId: 1B8BAF768139B3F4FAB3631F7B058F98A1110000EVPROD002 ( 52)
Deleted surplus Vault record, ArchiveFolder EntryId: 13FAA255570557C49BB1FA39116B6D0C81110000EVPROD002 ( 49)
Deleted surplus Vault record, ArchiveFolder EntryId: 1E4A6B3242DA964488072B9DCBBDA158C1110000EVPROD002 ( 53)
Deleted surplus Vault record, ArchiveFolder EntryId: 1B522D7328C816A49A09841F0695DFCA21110000EVPROD002 ( 54)
Deleted surplus Vault record, ArchiveFolder EntryId: 10166C584314B8E46BDFB3E9EC18F333B1110000EVPROD002 ( 41)
The following error is logged in the EVSVR repair log at Step 12 - Delete surplus Vault Store database Vault records, only for records that could not be deleted
Step 12 - Delete surplus Vault Store database Vault records
Error deleting surplus Vault record, ArchiveFolder EntryId: 13CCD12347A0635949A7D077GGGQ15434A1110000EVSITE ( 14), Error: An attempt was made to delete an ArchiveFolder but the folder has outstanding journal activity associated with it. (0x80041bf3)
The following Enterprise vault versions are affected:
- EV 9.0.x
- EV 10.0.x
The deletion of the Vault record can fail if the record has associated entries in the Journal Tables (I.e. JournalArchive, JournalDelete).
This issue has no impact on the repair itself, and the only effect is the existence of unused records in the VaultStore. Manual deletion of those records is not recommended
There are currently no plans to address this issue by way of a hotfix or cumulative hotfix in the current or previous versions of the software at the present time. This issue may be resolved in a future major revision of the software at a later time. However, this particular issue is not currently scheduled for any release. If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns. For information on how to contact Symantec Sales, please see http://www.symantec.com
Failed to delete surplus record when vault id exists in any of the journal table.
Article URL http://www.symantec.com/docs/TECH210128