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 of 2 indicating failure. Any row marked as such will also be marked with a code that indicates the reason for the failure (or success). The possible codes and their meanings are shown next.