Symptoms
Assume that you have some models that have multiple versions in SQL Server 2008 R2 Master Data Services (MDS). When you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS or SQL Server 2014 MDS, the business rules that make references to Domain-Based Attributes (DBAs) are modified during the upgrade process, and the DBA reference is removed.
Resolution
This problem was first fixed in the following cumulative update of SQL Server.
Cumulative Update 3 for SQL Server 2014 /en-us/help/2984923
Cumulative Update 1 for SQL Server 2012 SP2 /en-us/help/2976982
Cumulative Update 10 for SQL Server 2012 SP1 /en-us/help/2954099
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
If you have already upgraded to SQL Server 2012 RTM or a later version that does not include this hotfix, follow these steps to resolve this problem.
Note This fix assumes that you have the original SQL Server 2008 R2 database backup.
-
Upgrade the SQL Server 2008 R2 MDS instance to SQL Server 2012 MDS. (Wait to run the MDS Database Upgrade Wizard until step 4.)
-
Upgrade the SQL Server 2012 MDS instance to SQL Server 2012 SP1.
-
Upgrade the SQL Server 2012 SP1 MDS instance to SQL Server 2012 SP1 Cumulative Update 10.
-
Run the MDS Database Upgrade Wizard in the Master Data Services Configuration Manager.
Note If you do not have the original SQL Server 2008 R2 database backup or if you cannot afford to lose the work on the existing SQL Server 2012 database, you must add the missing DBA manually.
To verify that the hotfix works after the upgrade is complete, go to the Business Rules page to check whether any business rule that originally had DBA reference still has the DBA reference.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
