Microsoft KB Archive Search

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.

  1. Home
  2. Error "creating procedure RtcResetAbAttributes" when you run "Install-CsDatabase" for rtcab database in Lync Server 2013

Error "creating procedure RtcResetAbAttributes" when you run "Install-CsDatabase" for rtcab database in Lync Server 2013

View products that this article applies to.

Symptoms

Consider the following scenario:
  • You install the Absconfig tool in a Microsoft Lync Server 2013 environment.
  • You run Absconfig.exe on Lync Server 2013 front-end servers that have the Address Book Service enabled to change an address book attribute.
  • You run the Update-CsUserDatabase cmdlet to start a new replicator sync cycle.
  • You apply either the October 2013 or the January 2014 cumulative update for Lync Server 2013.
  • You run the following command to update the rtcab database:
    Install-CsDatabase -ConfiguredDatabases -SqlServerFqdn <FQDN>
In this situation, you receive an error message that states the RtcResetAbAttributes procedure fails. For example, you may receive the following error message:
Error creating procedure RtcResetAbAttributes:

sql error code = 547, error message = The DELETE statement conflicted with the REFERENCE constraint "FK_AbAttrValue_AbAttribute". The conflict occurred in database "rtcab", table "dbo.AbAttributeValue", column 'AttrId'., line number = 26 sql error code = 3621, error message = The statement has been terminated., line number = 26

↑ Back to the top

Cause

This issue occurs because the rtcab.RtcResetAbAttributes stored procedure deletes rows from the AbAttributes table. That violates the foreign key constraint in the AbAttributeValues table. Therefore, the Install-CsDatabase cmdlet fails.

↑ Back to the top

Resolution

To resolve this issue, install the following cumulative update:
2937310 August 2014 Cumulative Update 5.0.8308.738 for Lync Server 2013 (Front End Server and Edge Server)

↑ Back to the top

More Information

For more information about the October 2013 cumulative update for Lync Server 2013, click the following article number to view the article in the Microsoft Knowledge Base:
2881684 Description of the cumulative update 5.0.8308.556 for Lync Server 2013 (Front End Server and Edge Server) : October 2013
For more information about the January 2014 cumulative update for Lync Server 2013, click the following article number to view the article in the Microsoft Knowledge Base:
2905048 Description of the cumulative update 5.0.8308.577 for Lync Server 2013 (Front End Server and Edge Server): January 2014

↑ Back to the top

Keywords: kb, kbexpertiseinter, kbsurveynew, kbqfe, kbfix

↑ Back to the top

Article Info
Article ID : 2967626
Revision : 2
Created on : 5/20/2020
Published on : 5/20/2020
Exists online : False
Views : 315