Lotus Domino Journaling task error 41026: "There was an error processing an item in a database."

Article:TECH173787  |  Created: 2011-11-07  |  Updated: 2013-06-10  |  Article URL http://www.symantec.com/docs/TECH173787
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Environment

Issue



Lotus Domino Journaling task error 41026:

There was an error processing an item in a database.
......
Error: Exception from HRESULT: 0xC0041BA2

With a 13360 error:

Violation of PRIMARY KEY constraint 'PK_WatchSISPartFile'. Cannot insert duplicate key in object 'dbo.WatchSISPartFile'.


Error



 Type : Error
Date : 11/1/2011
Time : 09:20:13 AM
Event : 13360
Source : Enterprise Vault 
Category : Lotus Domino Journaling Task
User : N/A
Computer : EVServer.Domain
Description:
An error was detected while accessing the Vault Database 'EVVSDatabaseName' (Internal reference: CADODataAccess::ExecuteSQLCommand .\ADODataAccess.cpp [lines {1407,1409,1424,1442}], built Mar 14 10:54:54 2011): 
Description:  
Violation of PRIMARY KEY constraint 'PK_WatchSISPartFile'. Cannot insert duplicate key in object 'dbo.WatchSISPartFile'.
 
SQL Command:
uspi_Saveset
 
Additional Microsoft supplied information:
Source:       Microsoft OLE DB Provider for SQL Server
Number:       0x80040e2f
SQL State:    23000
Native Error: 00002627
HRESULT 0x80040e2f
 
 
Type : Error
Date : 11/1/2011
Time : 09:20:14 AM
Event : 41206
Source : Enterprise Vault 
Category : Lotus Domino Journaling Task
User : N/A
Computer : EVServer.Domain
Description:
There was an error processing an item in a database. The task will process the item again on the next archiving run.
 
Task: Messaging Journaling Task
 
Database: Dom/Forest\Journal.nsf
 
NoteID: 10d7ba
 
Subject: Subject of E-mail
 
Error: Exception from HRESULT: 0xC0041BA2
 
Trace:    at KVS.EnterpriseVault.Store.StoreAccessor.InsertItem(Item item, Boolean forceMsgSize, Int32 indexBufferSize)
   at KVS.EnterpriseVault.LotusDomino.Common.NoteArchiveInserter.InsertItem(String archiveId, String retentionCategory, IndexMetadata indexMetadata, AddressLookupOptions addrLookupOptions, NoteLocationList locationList, String& itemURN, String& savesetId, DateTime& archivedDate)
   at KVS.EnterpriseVault.LotusDomino.Journaling.DominoItemProcessor.StoreItem(WorkQItem workItem)
   at KVS.EnterpriseVault.LotusDomino.Journaling.DominoItemProcessor.ArchiveNote(WorkQItem workItem)
   at KVS.EnterpriseVault.LotusDomino.Journaling.DominoItemProcessor.ProcessAQueuedItem(WorkQItem workItem)
 
 
 
A DTrace of the 'EvLotusDominoJournalTask' will show:
  • SIS Part XML: <EnterpriseVault><SISPart FPVer="1" DistByte="72" HashP1="-1234567890" TID="A12345B6-C789-D01E-F234-56A789012BC3" UqId="0" CCDisp="197" Secured="0" AttachId="0" PartitionId="1" VaultStoreIdentity="1" StoreId="evroot/4B9B80C7528CCF47BD718AC6890B9A07/2011/Nov/01/bd80c126-cb55-420f-a54d-b7f0df8bf953/19_20_41/00011" ArchivedDateUTC="2011-11-01 19:21:00" LargeFile="0"/><SISPart FPVer="1" DistByte="183" HashP1="-543192255" TID="A12345B6-C789-D01E-F234-56A789012BC3" UqId="0" CCDisp="197" Secured="0" AttachId="2" PartitionId="1" VaultStoreIdentity="1" StoreId="evroot/4B9B80C7528CCF47BD718AC6890B9A07/2011/Nov/03/bd80c126-cb55-420f-a54d-b7f0df8bf953/19_20_41/00004" ArchivedDateUTC="2011-11-01 19:21:00" LargeFile="0"/><SISPart FPVer="1" DistByte="245" HashP1="-1998032749" TID="A12345B6-C789-D01E-F234-56A789012BC3" UqId="0" CCDisp="197" Secured="0" AttachId="3" PartitionId="1" VaultStoreIdentity="1" StoreId="evroot/4B9B80C7528CCF47BD718AC6890B9A07/2011/Nov/03/bd80c126-cb55-420f-a54d-b7f0df8bf953/19_20_41/00006" ArchivedDateUTC="2011-11-01 19:21:00" LargeFile="0"/><SISPart FPVer="1" DistByte="59" HashP1="-1521466868" TID="A12345B6-C789-D01E-F234-56A789012BC3" UqId="0" CCDisp="197" Secured="0" AttachId="5" PartitionId="1" VaultStoreIdentity="1" StoreId="evroot/4B9B80C7528CCF47BD718AC6890B9A07/2011/Nov/03/bd80c126-cb55-420f-a54d-b7f0df8bf953/19_20_41/00008" ArchivedDateUTC="2011-11-01 19:21:00" LargeFile="0"/><SISPart FPVer="1" DistByte="245" HashP1="-1998032749" TID="A12345B6-C789-D01E-F234-56A789012BC3" UqId="0" CCDisp="197" Secured="0" AttachId="6" PartitionId="1" VaultStoreIdentity="1" ArchivedDateUTC="2011-11-01 19:21:00" LargeFile="0"/></EnterpriseVault>|
  • {CVaultStoreDB::GenerateXMLForSISParts} (Exit) Status: [Success]
  • CADODataAccess::ExecuteSQLCommand - HRXEX fn trace : Error 0x80040e2f ref[1]: ESC12, .\ADODataAccess.cpp [lines {1407,1409,1424,1442}], built Mar 14 10:54:54 2011.
  • Event ID: 13360 An error was detected while accessing the Vault Database 'EVVSDatabaseName' (Internal reference: CADODataAccess::ExecuteSQLCommand .\ADODataAccess.cpp [lines {1407,1409,1424,1442}], built Mar 14 10:54:54 2011): |Description:  |Violation of PRIMARY KEY constraint 'PK_WatchSISPartFile'. Cannot insert duplicate key in object 'dbo.WatchSISPartFile'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e2f |SQL State:    23000 |Native Error: 00002627 |HRESULT|0x80040e2f| |
  • Event ID: 13360 An error was detected while accessing the Vault Database 'EVVSDatabaseName' (Internal reference: CADODataAccess::ExecuteSQLCommand .\ADODataAccess.cpp [lines {1407,1409,1424,1442}], built Mar 14 10:54:54 2011): |Description:  |The statement has been terminated.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e2f |SQL State:    01000 |Native Error: 00003621 |HRESULT|0x80040e2f| |
  • CVaultStoreDB::AddSaveset - HRXEX fn trace : Error 0x80040e2f, .\VaultStoreDB.cpp [lines (49){...,2501,2502,2503,2504,2505,2506,2507,2508,2509,2510,2511,2519}], built Mar 14 10:56:32 2011.
  • CSavesetSISManager::AddItemToVaultStoreDB _com_error exception. hr=The specified identifier already exists.      (0xc0041ba2)
  • {CSavesetSISManager::AddItemToVaultStoreDB} (Exit) Status: [The specified identifier already exists.      (0xc0041ba2)]
  • CSavesetSISManager::StoreSaveset _com_error exception. hr=The specified identifier already exists.      (0xc0041ba2)
  • ...............
  • Event ID: 41206 There was an error processing an item in a database. The task will process the item again on the next archiving run.|Task: Domino Journaling Task|Database: Dom/Forest\Journal.nsf|NoteID: 912|Subject:  Subject of E-mail|Error: Exception from HRESULT: 0xC0041BA2|Trace:    at KVS.EnterpriseVault.Store.StoreAccessor.InsertItem(Item item, Boolean forceMsgSize, Int32 indexBufferSize)|   at KVS.EnterpriseVault.LotusDomino.Common.NoteArchiveInserter.InsertItem(String archiveId, String retentionCategory, IndexMetadata indexMetadata, AddressLookupOptions addrLookupOptions, NoteLocationList locationList, String& itemURN, String& savesetId, DateTime& archivedDate)|   at KVS.EnterpriseVault.LotusDomino.Journaling.DominoItemProcessor.StoreItem(WorkQItem workItem)|   at KVS.EnterpriseVault.LotusDomino.Journaling.DominoItemProcessor.ArchiveNote(WorkQItem workItem)|   at KVS.EnterpriseVault.LotusDomino.Journaling.DominoItemProcessor.ProcessAQueuedItem(WorkQItem workItem)
 

 


Environment



 Enterprise Vault 9.0.2

Vault Store Partition configured with a Hitachi Content Platform (HCP) as a Streamer


Cause



When a message contains two attachments that are identical and these are sent to a Streamer partition, such as a Hitachi Content Platform, the 'StoreId' is not populated for the duplicate attachment.  However when these items are attempted to be inserted into the 'WatchSISPartFile' table the 'StoreIdentifier' column is passed as 'Distinct', and thus a PRIMARY KEY violation occurs.


Solution



This issue has been addressed as part of the following release:


Enterprise Vault 9.0.3 - Release Details
http://www.symantec.com/docs/TECH147782


Enterprise Vault 10.0.1 - Release Details
http://www.symantec.com/docs/TECH147787


Supplemental Materials

SourceETrack
Value2354237
Description

 Storage Archive reports a PRIMARY KEY SQL violation when archiving a specific set of items



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


Terms of use for this information are found in Legal Notices