view-errors-that-occur-during-staging-master-data-services.md

title	View Errors that Occur During Staging
description	View Errors that Occur During Staging (Master Data Services)
author	CordeliaGrey
ms.author	jiwang6
ms.date	03/01/2017
ms.service	sql
ms.subservice	master-data-services
ms.topic	how-to
helpviewer_keywords	staging process [Master Data Services], viewing errors
ms.custom	build-2025

View Errors that Occur During Staging (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

In [!INCLUDEssMDSshort], you can view errors that occur during the staging process. In the [!INCLUDEssMDSshort] 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 [!INCLUDEssMDSshort] 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 [!INCLUDEssManStudioFull] and connect to the [!INCLUDEssDE] instance for your [!INCLUDEssMDSshort] 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. Execute 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

Overview: Importing Data from Tables (Master Data Services)