FIX: "A column named 'AttributeName' already belongs to this DataTable" error when you open an entity in Master Data Manager in SQL Server 2008 R2 MDS

Article ID: 2592060 - View products that this article applies to.
Microsoft distributes Microsoft SQL 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2008 R2 update release.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario:
  • You create a Master Data Services (MDS) website on computer that has Microsoft SQL Server 2008 R2 MDS installed and configured.
  • You create a domain-based attribute for a leaf member and a domain-based attribute for a consolidated member. The attributes have the same domain entity for the MDS website.

    Note The security permissions for the current user are applied at the entity or member level.
  • You open the entity in the Explorer area in Master Data Manager.
In this scenario, you might receive an error message that resembles the following:
A column named 'AttributeName' already belongs to this DataTable.
Back to the top | Give Feedback

CAUSE

This issue occurs because of errors in the following functions that are used in the Explorer area in Master Data Manager:
  • udfMetadataAttributeGetIdentifiersXML
  • udfMetadataAttributeGetDetailsXML

Back to the top | Give Feedback

RESOLUTION

Cumulative update information

The fix for this issue was first released in cumulative update package 3. For more information about how to obtain this cumulative update package for SQL Server 2008 R2 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
2591748
(http://support.microsoft.com/kb/2591748/ )
Cumulative update package 3 for SQL Server 2008 R2 Service Pack 1
Note Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2008 R2 Service Pack 1 update release. We recommend that you consider applying the most recent update release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2567616
(http://support.microsoft.com/kb/2567616/ )
The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released

Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top | Give Feedback

MORE INFORMATION

To reproduce this issue, follow these steps:
  1. Deploy the data for the Product sample model. To do this, run the Model Deployment Wizard from the gettingstarted.aspx page of the MDS website, and then locate the Product_en.pkg file that contains the data for the Product sample model.

    Note The Product_en.pkg file is located at the following path:
    %programfiles%\Microsoft SQL Server\Master Data Services\Samples\Packages
  2. Access the System Administration page, edit the product entity, and then create the ProductSubCategory consolidated attribute by setting the domain entity to the ProductSubCategory entity.

    Note The domain entity for the ProductSubCategory leaf attribute is set to the ProductSubCategory entity.
  3. Give a user account the following Model permissions for the Explorer area:
    • Set the Read-only permission for the Product model
    • Set the Update permission for the Product entity
    • Set the Read-only permission for the Supply Chain attribute group

  4. Use the user account to log on to the MDS website.
  5. Select the Product model, and then click Explorer.
  6. Click the Entities list, and then select the Product entity.
  7. Click the Marketing attribute group tab.

Back to the top | Give Feedback

MORE INFORMATION

For more information about the deployment of MDS, visit the following MSDN website:
General information about the deployment of MDS
(http://msdn.microsoft.com/en-us/library/ee633748.aspx)
For more information about domain-based attributes for MDS, visit the following MSDN website:
General information about domain-based attributes for MDS
(http://msdn.microsoft.com/en-us/library/ff487058.aspx)

Back to the top | Give Feedback

Properties

Article ID: 2592060 - Last Review: October 17, 2011 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2592060
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top

Article Translations