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 running Install-CsDatabase for rtcab database in Skype for Business Server 2015

"Error creating procedure RtcResetAbAttributes" when running Install-CsDatabase for rtcab database in Skype for Business Server 2015

View products that this article applies to.

Symptoms

Consider the following scenario:

  • You install the Absconfig tool in a Microsoft Skype for Business Server 2015 environment.
  • You run the Absconfig.exe file on Skype for Business Server 2015 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 May 2017 or the March 2018 cumulative update for Skype for Business Server 2015.
  • 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:

Executing RtcAbDb.sql...
Database rtcab is set to multi user mode.
Error executing batch. Details: 
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 = LineNumber
sql error code = 3621, error message = The statement has been terminated., line number = LineNumber

↑ Back to the top

Cause

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

↑ 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, Core Components.

↑ Back to the top

Keywords: kb, kbfix, kbsurveynew, kbexpertiseadvanced, kbqfe, Error creating procedure RtcResetAbAttributes, when running Install-CsDatabase for rtcab database in Skype for Business Server 2015

↑ Back to the top

Article Info
Article ID : 4102006
Revision : 8
Created on : 8/2/2018
Published on : 8/2/2018
Exists online : False
Views : 223