The StorageArchive process can fail with multiple errors following a repair of EVSVR QueuedItems
Article ID: 100044411
Updated On:
Description
Error Message
Each affected item will generate a couple of errors 6796 and 13405 multiple times
Error 6796
Log Name: Veritas Enterprise Vault
Source: Enterprise Vault
Date: 11/5/2018 6:10:44 AM
Event ID: 6796
Task Category: Storage Archive
Level: Error
Keywords: Classic
User: N/A
Computer: EVServer1.ev.local
Description:
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\14\ev\v-m-s\sources\source\storage\storagedatabase\storedprocedures.cpp, lines {64,66,67,68,69,70}, built Mar 18 14:29:02 2018]
An exception is raised when a process encounters an unexpected fault.
Error 13405
Log Name: Veritas Enterprise Vault
Source: Enterprise Vault
Date: 11/5/2018 6:10:44 AM
Event ID: 13405
Task Category: Storage Archive
Level: Error
Keywords: Classic
User: N/A
Computer: evarch1.ev.local
Description:
A constraint violation error was detected while accessing the Vault Database 'EVVSExchangeMailboxStore_1' (Internal reference: {CADODataAccess::ExecuteSQLCommand} [d:\builds\14\ev\v-m-s\sources\source\common\adointerface\adodataaccess.cpp, lines {1326,1328,1347,1365}, built Mar 18 14:28:31 2018]):
Description:
Enterprise Vault Stored Procedure : usp_FinishSavesetInsertXML, Line 216, Error 2627, Level 14, State 1, Message: Violation of PRIMARY KEY constraint 'PK_Saveset_SISPart'. Cannot insert duplicate key in object 'dbo.Saveset_SISPart'. The duplicate key value is (18474, 20588, 11).
SQL Command:
usp_FinishSavesetInsertXML
Cause
A repair of EVSVR QueuedItems will recreate the JournalArchive records for all items which may results in the post processing process to enter duplicate records for items with attachments in the Saveset_Sispart table
Resolution
This issue has been fixed in:
Enterprise Vault 12.4.0, 12.4.1, and 12.5.0
Issue/Introduction
Items that have been repaired using EVSVR QueuedItems can generate multiple errors during post processing during the execution of the usp_FinishSavesetInsert1, usp_FinishSavesetInsert5 or usp_FinishSavesetInsertXML SQL Stored Procedure which may fail with the Cannot insert duplicate key in object 'dbo.Saveset_SISPart' error.
Those errors will be generated regularly as the items that fail are automatically retried.
Additional Information
JIRA: CFT-1682
JIRA: CFT-1387
JIRA: CFT-1650
Was this article helpful?
Yes
No
Powered by
