FIX: Business rule does not work when a member code contains special characters in MDS in SQL Server 2012

Article translations Article translations
Article ID: 2819383 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

Consider the following scenario:
  • You create a business rule in Microsoft SQL Server 2012 Master Data Services (MDS).
  • The business rule is set up so that a notification email message is sent if a member is flagged as invalid.
  • The value of the member code contains one of the following special characters:
    • &
    • <
    • >
    • "
    • '
  • You run the business rule against members in an entity.

In this scenario, the notification email message is not sent as expected.

Resolution

Cumulative update information

Cumulative Update 3 for SQL Server 2012 Service Pack 1 (SP1)

The fix for this issue was first released in Cumulative Update 3. For more information about how to obtain this cumulative update package for SQL Server 2012 SP 1, click the following article number to view the article in the Microsoft Knowledge Base:
2812412 Cumulative update package 3 for SQL Server 2012 Service Pack 1
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 SP 1 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2772858 The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1 was released

Status

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


Properties

Article ID: 2819383 - Last Review: April 12, 2013 - Revision: 2.0
Applies to
  • Microsoft SQL Server 2012 Service Pack 1
  • Microsoft SQL Server 2012 Analysis Services
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2819383

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com