Import to PST for a Vault Store doesn't work and generates constraint violation error Events 13405 & 6796.

book

Article ID: 100053997

calendar_today

Updated On:

Description

Error Message

A Dtrace collected on StorageArchive at the time of import to PST will show following snippets:

(StorageArchive)    <14064>    EV:L    {StorageQueueDBAdapter::FinishSaveset:#291} Information: Failed items  need to be deleted at time of post processing. SavesetTID = [A12199CC37B6CB249CFEA2B198EF72F1]

(StorageArchive)    <14064>    EV~E    Event ID: 13405 A constraint violation error was detected while accessing the Vault Database 'EVVSMailboxVS_1' (Internal reference: {CADODataAccess::ExecuteSQLCommand} [d:\builds\16_\ev\v-m-s\sources\source\common\adointerface\adodataaccess.cpp, lines {1326,1328,1347,1365}, built Oct  9 11:34:22 2019]): |Description:  |Enterprise Vault top level Stored Procedure : usp_FinishSavesetInsert0, Error Procedure: dbo.uspci_WatchFile, Line 12, Error 2627, Level 14, State 1, Message: Violation of UNIQUE KEY constraint 'UN_WatchFile_SavesetIdentity'. Cannot insert duplicate key in object 'dbo.WatchFile'. The duplicate key value is (61044).| | |SQL Command: | usp_FinishSavesetInsert0| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Driver for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002627 |HRESULT|0x80040e14| |

(StorageArchive)    <14064>    EV~E    Event ID: 6796 A COM exception has been raised. |A constraint violation error was detected while accessing the Vault Database.          (0xc004346b) |Internal reference |{VaultStoreDatabase::StoredProcedureAutoExecute::Execute} [d:\builds\16_\ev\v-m-s\sources\source\storage\storagedatabase\storedprocedures.cpp, lines {64,66,67,68,69,70}, built Oct  9 11:35:32 2019] | |An exception is raised when a process encounters an unexpected fault. |

Cause

If an item being archived is not backed up and post processed then it can lead to generation of Events 13405 & 6796.

Resolution

In order to post process the item, make sure that required partition is backed up and cleared out of backup mode.

Issue/Introduction

Import to PST for a Vault Store doesn't work and generates constraint violation error Events 13405 & 6796.