View Errors that Occur During Staging (Master Data Services)
Applies To: SQL Server 2016
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).
Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.
Open a new query.
Type the following text, replacing name with the name of your staging table, for example, viw_Product_MemberErrorDetails.
SELECT * FROM stg.viw_name_MemberErrorDetails
Excecute the query. Error details are displayed in the ErrorDescription field.
For more details on error messages, see Staging Process Errors (Master Data Services).