FIX: Delete operation doesn't work in an entity when you enable Approval Required permission in SQL Server 2017 Master Data Services

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

Symptoms


Assume that you log in to SQL Server 2017 Master Data Services (MDS) by using a browser, and then enable "Approval Required" permission in an entity. When the user tries to delete a record in the entity, 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 10 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.