Export (0) Print
Expand All

How to: Reactivate a Member or Collection by Using tblStgMemberAttribute (Master Data Services)

SQL Server 2008 R2

In Master Data Services, you can use the staging process to reactivate leaf members, consolidated members, or collections that have been deleted.

  • Reactivate a member to restore the member's attributes and its membership in hierarchies and collections.

  • Reactivate a collection to restore the collection and its structure.

In the Master Data Services database, each member and collection has an attribute named MDMMemberStatus. When you delete a member or collection, the value of this attribute changes from Active to De-Activated and the code is changed to a 32-character GUID.

To reactivate a member or collection, you must change the MDMMemberStatus attribute value back to Active.

To perform this procedure:

  • You must have permission to insert data into the mdm.tblStgMemberAttribute table in the Master Data Services database.

  • You must have permission to view the mdm.viw_SYSTEM_SCHEMA_ENTITY view and the table that contains the deactivated member. For more information, see Database Object Security (Master Data Services).

  • In Master Data Manager, you must have permission to access the Integration Management functional area.

  • You must be a model administrator. For more information, see Administrators (Master Data Services).

To reactivate a member or collection

  1. Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.

  2. Expand the Master Data Services database, expand Views, and open the mdm.viw_SYSTEM_SCHEMA_ENTITY view. Find the name of the entity that contains the deleted member or collection. Note the value in the EntityTable column.

  3. Open the table that was listed in the EntityTable field. Find the name of the member or collection and note the value in the Code column. The code should be a 32-character GUID.

  4. Prepare the members or collections for import into the mdm.tblStgMemberAttribute table in the Master Data Services database. For any member or collection that you want to reactivate, use MDMMemberStatus for AttributeName, Active for AttributeValue, and the code from step 3 for MemberCode. For more information and an example, see Attributes Staging Table (Master Data Services).

  5. Import the data into mdm.tblStgMemberAttribute. For information about importing data into a database by using SQL Server Integration Services, see How to: Run the SQL Server Import and Export Wizard.

  6. After you successfully import the data, in Master Data Manager, click Integration Management.

  7. In the Unbatched Staging Records pane, from the Model list, select the model that contains records you want to import.

  8. From the Version list, select a version. The version must have the Status of Open or Locked.

  9. Confirm that the displayed number of records matches the number of records you plan to import. If it does not, see Troubleshooting the Staging Process (Master Data Services).

  10. Click Process unbatched data. In the Staging Batches pane, the value in the Status column changes to Queued to Run.


    The staging queue runs automatically at intervals based on the Staging batch interval set in Master Data Services Configuration Manager. For more information, see System Settings (Master Data Services).

  11. The import is complete when the value in the Status column is Not Running. You can refresh the page to view the updated status by clicking Import on the menu bar.

Community Additions

© 2014 Microsoft