You are currently offline, waiting for your internet to reconnect

Event ID 21071 occurs in Office Communications Server 2007 R2

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
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 and hélè

Note This issue only affects Microsoft Office Communicator Mobile 2007 R2 users.
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è will be indexed as However, when the attribute also has the value, this value will also be indexed as Because of these duplicate indexes, SQL Server throws an exception.
To fix this problem, apply the following update:
977345 Description of cumulative update for Office Communications Server 2007 R2: January, 2010
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è from the proxyAddresses attribute.

Article ID: 978375 - Last Review: 01/07/2010 18:02:34 - Revision: 1.1

  • Microsoft Office Communications Server 2007 R2 Enterprise Edition
  • Microsoft Office Communications Server 2007 R2 Standard Edition
  • Microsoft Office Communicator Mobile (2007 Release)
  • kbqfe kbexpertiseinter kbsurveynew kbprb KB978375