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

Article translations Article translations
Article ID: 979105
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'.

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.

Resolution

To resolve this issue, apply the following update:
977338 Update package for Office Communications Server 2007 R2 Group Chat Server: January 2010

Properties

Article ID: 979105 - Last Review: June 21, 2014 - Revision: 2.0
Keywords: 
kbqfe kbexpertiseinter kbsurveynew kbprb KB979105

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com