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 translations Article translations
Close Close
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.

CAUSE

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

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 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 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 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.

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.

MORE INFORMATION

For more information about the deployment of MDS, visit the following MSDN website:
General information about the deployment of MDS
For more information about domain-based attributes for MDS, visit the following MSDN website:
General information about domain-based attributes for MDS

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

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