A synchronization operation between the Active Directory directory service and Office Communications Server 2007 R2 Group Chat Server fails

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

Expand all | Collapse all

SYMPTOMS

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:[121] Violation of PRIMARY KEY constraint 'pktblPrincipalMembers'. Cannot insert duplicate key in object 'dbo.tblPrincipalMembers'.

Back to the top

CAUSE

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.

Back to the top