Hotfix for Symantec Enterprise Vault for Microsoft Exchange (Journal Connector) 2007 Service Pack 2 (SP2), Build 1862 - Unable to sample IM items due to an Event ID 275 on the Enterprise Vault Journaling Task server.

Article:TECH70189  |  Created: 2009-01-01  |  Updated: 2009-01-01  |  Article URL http://www.symantec.com/docs/TECH70189
Article Type
Technical Solution

Product(s)

Environment

Problem



Hotfix for Symantec Enterprise Vault for Microsoft Exchange (Journal Connector) 2007 Service Pack 2 (SP2), Build 1862 - Unable to sample IM items due to an Event ID 275 on the Enterprise Vault Journaling Task server.

Error



Event ID: 275 - APP JC - Could not process an item with transaction id ' ...' : System.Data.ConstraintException: Column 'CaseID, AddressOwnerID, Type, Direction, RecordDate, CaptureType' is constrained to be unique. Value '... ' is already present.

Solution



To which version of Symantec Enterprise Vault (tm) can this hotfix be applied?
This hotfix can only be applied to the following versions of Enterprise Vault:
Enterprise Vault for Microsoft Exchange 2007 SP2 Build 1862

What issue does this hotfix resolve?
Compliance Accelerator message. Unable to sample IM items due to error logged as event 275 on the Enterprise Journaling Task server; Could not process an item with transaction id '<n>' : System.Data.ConstraintException: Column 'CaseID, AddressOwnerID, Type, Direction, RecordDate, CaptureType' is constrained to be unique. Value [...] is already present.

Event Type: Error
Event Source: Accelerator Manager
Event Category: None
Event ID: 275
Date: 5/31/2008
Time: 3:51:01 PM
User: N/A
Computer: EVSERVER1
Description:
APP JC - Could not process an item with transaction id '<n>' :
System.Data.ConstraintException: Column 'CaseID, AddressOwnerID, Type,
Direction, RecordDate, CaptureType' is constrained to be unique. Value
'...' is already present. at System.Data.UniqueConstraint.CheckConstraint(DataRow row,
DataRowAction action) at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs
args, DataRow eRow, DataRowAction eAction, Boolean fireEvent) at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32
proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent) at System.Data.DataRowCollection.Add(DataRow row)
at KVS.Accelerator.Sampling.UsageStatsDS.CaptureSummaryCacheDataTable.AddCaptureSummaryCacheRow(Int32 CaseID, Int32 AddressOwnerID, Int32
NumberCaptured, Int32 NumberReceived, Int32 NumberSent, Int32 NumberSenderAsRecipient, Int32 Type, Int32 Direction, DateTime
RecordDate, Int32 NumberSampled, Int32 CaptureType) at
KVS.Accelerator.Sampling.CustomerCapture.UpdateUsageStats(MsgEmployeeCases ActiveEmployeeCases, Int32 AuthorID, ArrayList RecipientIDs,
MessageType MsgType, Int32 Direction, CaptureType captureType) at KVS.Accelerator.Sampling.CustomerCapture.ConsiderMsg(XmlDocument
AuthorRecipXML, ItemPropsHelper itemprops, IndexPropHelperBase architem, Int32& ev_action) at KVS.Accelerator.Sampling.Nominator.KVS.Accelerator.Sampling.INominator3.
ProcessItem(String AuthorRecipientXML, String ItemPropsXML, Int32& ev_action, String& IndexedPropXML

Which files does this hotfix replace?
Program Files\Enterprise Vault\KVS.Accelerator.Sampling.dll

How to install this hotfix:

On each of the Enterprise Vault Journaling servers running a Compliance Accelerator Journal Connector;
1. Stop the Enterprise Vault Journaling Tasks.
2. Take a copy of the existing KVS.Accelerator.Sampling.dll in the Enterprise Vault installation directory,
and put it in a folder not under 'Program Files'.
3. Copy the KVS.Accelerator.Sampling.dll supplied in this patch into the Enterprise Vault installation directory.
4. Start the Enterprise Vault Journaling Tasks.

How to uninstall this hotfix:

On each of the Enterprise Vault Journaling servers running a Compliance Accelerator Journal Connector;
1. Stop the Enterprise Vault Journaling Tasks.
2. Overwrite the KVS.Accelerator.Sampling.dll in the Enterprise Vault installation directory with the
original KVS.Accelerator.Sampling.dll supplied with CA 2007SP2.
3. Start the Enterprise Vault Journaling Tasks.

Note: This issue has been address as part of the following release:
Enterprise Vault 2007 Service Pack 4 (SP4) http://entsupport.symantec.com/docs/308768



Supplemental Materials

SourceETrack
Value1284055
DescriptionDetails investigation and findings for this issue

Legacy ID



323965


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


Terms of use for this information are found in Legal Notices