FIX: Error occurs when you delete a record in an entity that has "Approval Required" permission enabled in SQL Server 2017 MDS

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Symptoms


Assume that you log on to SQL Server 2017 Master Data Services (MDS) by using a browser, and then enable "Approval Required" permission in an entity. When you delete a record in the entity, the record will be deleted, but you will receive an error message that resembles the following:

"Correlation ID: Correlation ID: The entity requires approval for leaf member changes"

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 11 for SQL Server 2017

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.