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.

Prerequisites

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.

Next Steps

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

See Also

Concepts

Importing Data (Master Data Services)

Other Resources

Troubleshooting the Staging Process (Master Data Services)