Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

View Errors that Occur During the Staging Process (Master Data Services)

In Master Data Services, you can view errors that occur during the staging process. In the Master Data Services database, there are two views that show errors:

  • stg.viw_name_MemberErrorDetails for leaf or consolidated member updates.

  • stg.viw_name_RelationshipErrorDetails for hierarchy relationship updates.

To perform this procedure:

  • In the Master Data Services database, you must have SELECT permissions to either the stg.viw_name_MemberErrorDetails or stg.viw_name_RelationshipErrorDetails view.

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

To view staging errors

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

  2. Open a new query.

  3. Type the following text, replacing name with the name of your staging table, for example, viw_Product_MemberErrorDetails.

    SELECT * FROM stg.viw_name_MemberErrorDetails

  4. Excecute the query. Error details are displayed in the ErrorDescription field.

For more details on error messages, see Staging Process Errors (Master Data Services).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.