Unable to delete some archived email from Journal archive. Getting Error’s on EV 9.0.1

 

Description

Unable to delete some archived email from Journal archive. Getting Error’s on EV 9.0.1

 

Platform

 

Storage – Backup – Enterprise Vault – Email Archiving

Enterprise Vault 9.0.1

 

Resolution  Summary

 

1. Taken the full backup of EV environment and confirm  taken EV backup’s are fine

 

2. Uninstalled TEST DA from the DA server

 

3. Done  Clean up the holddata, Holdgroup, holdconsumer and holdsaveset tables in the Vault Store Database.

 

4. Detached EVConfig database and Discovery databases

 

5. USE VaultStoreDatabase

TRUNCATE TABLE HoldSaveset

GO TRUNCATE TABLE HoldData

GO TRUNCATE TABLE HoldGroup

GO TRUNCATE TABLE HoldConsumer

 

6. Truncate the VaultInterest table.

use EnterpriseVaultDirectory

Truncate table vaultinterest

 

 

Ø  Now user able to do archive and able to delete Journaling mails and its working fine.

 

 

CONCLUSION: -

 

After truncating Hold Data / Hold Groups/ Hold Consume tables from SQL database now user able to delete the mails from journaling archive.