Event ID 21071 occurs in Office Communications Server 2007 R2

Article translations Article translations
Article ID: 978375 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You have a computer that is running Microsoft Office Communications Server 2007 R2. The following event is logged in the Office Communications Server log:

Event Type: Error
Event Source: OCS Address Book Server
Event Category: (1008)
Event ID: 21071
Date: Date
Time: Time
User: N/A
Computer: ComputerName
Description: Failed to upload contact to address book database

Contact Id:ContactID
User Id: UserID
Exception:
Microsoft.Rtc.ABServer.RtcAbBulkInsertException: Failed to bulk insert address book contacts ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_AbAttributeValueIdx'. Cannot insert duplicate key in object 'dbo.AbAttributeValue'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at Microsoft.Rtc.ABServer.RtcAbBulkInsert.BulkInsert()
--- End of inner exception stack trace ---
at Microsoft.Rtc.ABServer.RtcAbBulkInsert.BulkInsert()
at Microsoft.Rtc.ABServer.RtcAb.UploadAbContacts(RtcAbDataFile abDataFile)

This issue occurs if you have two or more values in the proxyAddresses attribute that are identical, except for differences in accents. For example, the attribute has the values helene@vdomain.com and hélène@vdomain.com.

Note This issue only affects Microsoft Office Communicator Mobile 2007 R2 users.

CAUSE

In a Microsoft SQL Server database, index comparisons are made by using the Latin1_General_CI_AI collation. Because the rules for this collation are case-insensitive and accent-insensitive, values that contain accented characters will be indexed without these accents. For example, the value hélène@vdomain.com will be indexed as helene@vdomain.com. However, when the attribute also has the value helene@vdomain.com, this value will also be indexed as helene@vdomain.com. Because of these duplicate indexes, SQL Server throws an exception.

RESOLUTION

To fix this problem, apply the following update:
977345 Description of cumulative update for Office Communications Server 2007 R2: January, 2010

WORKAROUND

To work around this issue, you can remove values from the proxyAddresses attribute that are identical, except for differences in accents. In the example that is provided in the "Symptoms" and "Cause" sections, you might remove hélène@vdomain.com from the proxyAddresses attribute.

Properties

Article ID: 978375 - Last Review: January 7, 2010 - Revision: 1.1
APPLIES TO
  • Microsoft Office Communications Server 2007 R2 Enterprise Edition
  • Microsoft Office Communications Server 2007 R2 Standard Edition
  • Microsoft Office Communicator Mobile (2007 Release)
Keywords: 
kbqfe kbexpertiseinter kbsurveynew kbprb KB978375

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com