FIX: “Unclosed quotation mark after the character string” error in the MDS explorer when you try to add a new member to an entity in SQL Server

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Symptoms


Assume that you use Master Data Services (MDS) in SQL Server 2017. If you create too many business rules on a single entity, and then you try to add a new member to the entity, you receive an error message that resembles the following:

Resolution


This problem is fixed in the following update for SQL Server:

Cumulative Update 9 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 standard terminology Microsoft uses to describe software updates.