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
Article Type
Technical Solution


Issue



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)
 

 


Error



 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)
 


Environment



The following Enterprise vault versions are affected:

  • EV 9.0.x 
  • EV 10.0.x 

 


Cause



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

 


Solution



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

 


Supplemental Materials

SourceETrack
Value2720572
Description

 Failed to delete surplus record when vault id exists in any of the journal table.



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


Terms of use for this information are found in Legal Notices