Event ID 21071 and Event ID 21064 are logged by Office Communications Server 2007 R2

Symptoms

On a computer that is running Microsoft Office Communications Server 2007 R2, the following events are 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.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.

at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)

--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)
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)

Event Type: Error
Event Source: OCS Address Book Server
Event Category: (1008)
Event ID: 21064
Date: Date
Time: Time
User: N/A
Computer: ComputerName
Description:
Address book database upload pass encountered exception
Microsoft.Rtc.ABServer.RtcAbException: Failed to import at least one contact. Check event log for more information.
at Microsoft.Rtc.ABServer.RtcAb.ImportAbUserEntry(String filePath)
at Microsoft.Rtc.ABServer.RtcAb.ImportAddressBookDataFile(String importFile)
at Microsoft.Rtc.ABServer.RtcAb.ImportFile(String[] args, ABServer instance)
Cause: An error occurred during the upload pass

This problem occurs if the ProxyAddress field in Active Directory contains more than 256 characters and the Value of RtcAbInsertBatchSize in the ABServer.exe.config file is set to 1.

Cause

This problem occurs because Address Book Server inserts the string that is in the ProxyAddress field into OCS-BE.rtcab.dbo.AbAttributeValue field when Address Book Server synchronizes with Active Directory. This field has an attribute of nvarchar(256). When the ProxyAddress field contains more than 256 characters, Address Book Server reports an error.

Resolution

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

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.