Neal Waterstreet

Archives for February 2018

MDSERR400038

by Leave a Comment

I had just finished deploying a model between environments and tried to validate when I got this message:

MDSERR400038|Unpublished business rules exist. Apply the business rules before running Business Rules or Validation again.

The error message on this one is pretty straightforward. I had a list of business rules to publish and tried to set them all as active with a SQL update instead of using Master Data Manager. It didn’t work. I updated the business rules manually and was then able to process the model.

MDS: Issue with upgrading server

by Leave a Comment

We recently upgraded a clustered server to MDS 2016. I went to go verify the upgrade and ran into this strange error when viewing all of the entities:

After troubleshooting for a while, the cause became painfully obvious. It turned out that I needed to clear the cache in IE since it still had the previous 2012 version in cache.

I hope this saves someone some time.

Speaking at SQLSaturday #699 Tampa 2018

by Leave a Comment

On Saturday, February 24th, I’m speaking at SQLSaturday #699 Tampa 2018! I’m presenting my session “Master Data Management with SQL Server 2016 MDS”.

Want to know the position Master Data Management and MDS play in an organization’s overall data strategy? We’ll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We’ll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.