View Errors that Occur During Staging (Master Data Services)
Applies To: SQL Server 2016 Preview
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
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).