You are currently offline, waiting for your internet to reconnect

Event ID 21071 occurs in Office Communications Server 2007 R2

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: 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
Feedback