MDS — Neal Waterstreet

MDS Error: “200085: The attribute cannot be saved. The input mask is not valid.”

March 4, 2019 by neal Leave a Comment

During a recent deployment, I received an error that I’d never seen before. It’s always fun to get these.

“200085: The attribute cannot be saved. The input mask is not valid.”

My initial thought was that someone had modified an attribute and created a conflict. The model was new and sparsely populated, so I was able to view the data. It didn’t appear to be data related.

It turned out to be a custom input mask was not included in the deployment. The mask was created in a lower environment but never migrated. Once that update was made the deployment completed successfully.

MDS Features in SQL Server 2019 CTP 2.2

January 11, 2019 by neal Leave a Comment

I finally downloaded a copy of CTP 2.2 and installed it to check out MDS and DQS for any new features and make sure they’re both still included. The preview only allows new installs, so I wasn’t able to upgrade from an older version. Hopefully I can try an upgrade in an upcoming release.

The HTML5 interface seems a little more reactive than Silverlight. Here are some screenshots with MDS running in Chrome on Windows Server 2019:

Here’s the main screen, which looks almost the same.

MDS Explorer.

Editing a member.

I haven’t compared the 2019 database to an older version yet but will do so and report in another post.

Changing The Case Of An Object in MDS

October 22, 2018 by neal Leave a Comment

One question that comes up from time to time is how to change the case of an object once it is created in MDS. This can be done for a variety of reasons and it’s really easy to do.

In this example we’ll change “Sampleattribute” to “SampleAttribute”.

1. Select the attribute and click “Edit”.

2. The “Sampleattribute” is displayed on the right.

3. Simply rename the “Name” and “DisplayName” to something different and click “Save”.

4. Change the “Name” and “DisplayName” to the correct value and click “Save”.

5. Now the attribute has the correct case.

The product version and database version are not compatible.

August 11, 2018 by neal Leave a Comment

This isn’t a very comforting message the first time you see it:

It’s pretty simple to resolve though. The problem is that the MDS application (product) and repository (database) are on different versions and the repository needs to be upgraded. This is usually the result of a service pack being deployed to SQL Server.

1. RDP to the MDS application server and select “Master Data Services Configuration Manager”.