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

Applies to: Lync Server 2013

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

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.

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)

More Information


To download the Absconfig tool, go to the following Microsoft website: 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