Export (0) Print
Expand All

Troubleshooting the Staging Process (Master Data Services)

SQL Server 2008 R2

In Master Data Manager, in the Integration Management functional area, on the Import page, in the Unbatched Staging Records pane, the model may not be available in the Model list.

You must be a model administrator to import data for a model. For more information, see Administrators (Master Data Services).

On the Import page, in the Unbatched Staging Records pane, the version may not be available in the Version list.

Model versions with a status of Committed are not available. Ensure that you are importing into an Open or Locked version.

On the Import page, in the Unbatched Staging Records pane, the number of records available for import may not match the number of records you expected to retrieve from the staging tables in the Master Data Services database.

  • In the staging tables, ensure that the UserName field for each record contains your user name in the format Domain\user_name, computer\user_name, or that the field is NULL.

  • In the staging tables, ensure that the value in the Batch_ID field for each record is NULL and that the Status_ID field is 0.

  • In the staging tables, ensure that the value in the ModelName field matches the name of the model exactly. The name should be the same case as the model name in Master Data Manager.

The batch may be queued to run but it does not process. In Master Data Manager, on the Import page, in the Unbatched Staging Records pane, the status remains Queued to Run.

Ensure that Service Broker is enabled. For more information, see How to: Activate Service Broker Message Delivery in Databases (Transact-SQL).

If the batch takes longer than usual to complete, the statistics on the Master Data Services database may need to be updated. For more information, see:

If errors occur during the staging process, the error code listed in the staging table ErrorCode field for each record provides more detailed information. For a complete list of error codes, success codes, and warnings, see Staging Error Messages (Master Data Services).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft