You are currently offline, waiting for your internet to reconnect

FIX: Attribute value does not update during validation when two business rules update the same attribute to a certain value in SQL Server 2012 MDS

Symptoms
Consider the following scenario:
  • You have an entity that has four attributes in Microsoft SQL Server 2012 Master Data Services (MDS). For example, the attributes for the entity are A1, A2, A3, and F. Attribute A3 is a domain-based attribute. 
  • You have two business rules. One rule tries to set the value of F to A1. The second rule tries to set the value of F to A2 when A3 is set to a certain value. 
  • You publish and apply the two business rules.

In this scenario, the value of F is not updated.

Note The expected operation is that attribute A3 dictates F to be updated to the value of A2. Instead, the value of F stays blank.
Resolution

Cumulative update information

Cumulative update 2 for SQL Server 2012 Service Pack 1 (SP1)

The fix for this issue was first released in Cumulative Update 2. For more information about how to obtain this cumulative update package for SQL Server 2012 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
2790947 Cumulative update package 2 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 Service Pack 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: 2800355 - Last Review: 01/24/2013 18:04:00 - Revision: 1.0

Microsoft SQL Server 2012 Service Pack 1

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2800355
Feedback
r varAutoFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" s="ng-binding" id="language-es-py">Paraguay - Español
Venezuela - Español
display: none; " src="https://c1.microsoft.com/c.gif?DI=4050&did=1&t=">ng = 1; var Route = "76500"; var Ctrl = ""; document.write(" ')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >>