Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

"Cannot insert duplicate key row in object 'dbo.Agents'" error when adding an RGS agent to a group via an Exchange distribution list


View products that this article applies to.

Symptoms

Consider the following scenario:

  • You have a user forest and a resource forest in your Active Directory environment. The Microsoft Exchange Server and Skype for Business Server are hosted in the resource forest; Active Directory users are hosted in the user forest.
  • You create a user account in the user forest, for example, user U. The objectSID is objectSIDU.

  • You create a disabled account in the resource forest, for example, user R, and populate the msRTCSIP-OriginatorSID with objectSIDU.

  • You enable the user R in Skype for Business Server 2015 with Sip address: sip:user@contoso.com.

  • On the Exchange Server, you create a mailbox for user R with the email address: smtp:user@contoso.com and create a group, group@contoso.com, then add the user R as a member of this group.  

  • On the Skype for Business Server 2015 Control Panel, select Response Groups, click Group, then click New to create an RGS group that uses name Group A and add the agent user R.

  • You create another RGS group that uses name Group B, select Use an existing email distribution list under Agents. Input the distribution list address group@contoso.com that's created before.

In this situation, you may receive an error message that resembles the following:

205 TL_ERROR(TF_COMPONENT) [6]2AE0.12F78::[date].411.0b2bdc21 (RgsMatchMakingService,ContactCenterModel.ReportMMConfigurationFailureEvent:contactcentermodel.cs(1943))(000000000141B8B3)Update configuration failure, action=[Create], item=[Group], identifier=[IdentifierID], exception=[System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.Agents' with unique index 'IX_Agents_SipAddress'. The duplicate key value is (sip:user@contoso.com).

↑ Back to the top


Cause

This issue occurs because there's an existing entry in the agent table that's used by the response groups. The dbo.agent table will be populated with a different SID for user R (the disabled account that you created in the resource forest). Therefore, it causes the duplication.

↑ Back to the top


Resolution

To fix this issue, install the July 2018 cumulative update 6.0.9319.534 for Skype for Business Server 2015, Front End Server and Edge Server.

↑ Back to the top


Keywords: kb, kbfix, kbsurveynew, kbexpertiseadvanced, kbqfe, Cannot insert duplicate key row in object 'dbo.Agents, "Cannot insert duplicate key row in object 'dbo.Agents'" error, can't add a RGS agent to a group via an Exchange distribution list

↑ Back to the top

Article Info
Article ID : 4132314
Revision : 10
Created on : 7/26/2018
Published on : 7/31/2018
Exists online : False
Views : 198