O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Errors in the staging process

If after invoking the staging process, it fails to complete successfully, the most common scenario is that the MDS database is not enabled for Service Broker. This means that any batches in the queue will never get processed. We can enable Service Broker on the MDS database using the following syntax:

-- Enable Service Broker:
ALTER DATABASE [Database Name] SET ENABLE_BROKER;

If the staging process completes successfully, but not all of your updates or additions appear in MDS as you would expect, it's possible that some of the rows failed to load. As shown in our previous examples of invoking the staging process using T-SQL, we can review the staging tables looking in particular for any rows that have a Status_ID ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required