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.
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.
To fix this problem, apply the following cumulative update:
978008 Description of cumulative update for Office Communications Server 2007 R2: April, 2010
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.