A synchronization operation between the Active Directory directory service and Microsoft Office Communications Server 2007 R2 Group Chat Server fails. Therefore, users cannot access chat rooms even though the users were given the appropriate permissions to access the chat rooms. Or, users can access chat rooms even though the users were not given the appropriate permissions to access the chat rooms.
Note If this issue occurs on a computer that has the Channel Server role installed, the following error message is logged in the Channel Server log:
CRITICAL ActiveDirectoryWatch.CheckForChanges | Failed to update database with AD changes: Violation of PRIMARY KEY constraint 'pktblPrincipalMembers'. Cannot insert duplicate key in object 'dbo.tblPrincipalMembers'.
This issue occurs because of a stored procedure that is used to populate the list of changed users and groups in Active Directory. However, this stored procedure creates duplicate entries in a table that has a unique constraint. This unique constraint violation prevents changes to Group Chat Server. Therefore, these changes are not synchronized with the Group Chat database.
To resolve this issue, apply the following update:
977338 Update package for Office Communications Server 2007 R2 Group Chat Server: January 2010