Lotus Domino Journaling task error 41026: "There was an error processing an item in a database."
| Article:TECH173787 | | | Created: 2011-11-07 | | | Updated: 2013-03-07 | | | 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. |
Problem
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 resolved in the following release:
Enterprise Vault for 10.0.1
www.symantec.com/docs/TECH147787
|
|
| Source | ETrack |
| Value | 2354237 |
| 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
Thank you.