Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

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.

 

Filed Under: MDS Tagged With: Error Messages, MDS

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.

Filed Under: Data, MDS Tagged With: HTML5, SQL Server 2019 CTP2.2

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.

Filed Under: MDS Tagged With: Attribute, Change 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”.

2. In the Configuration Manager, select “Database Configuration” on the left.

3.  You should see the error below in the the Database Configuration window.

 

 

 

4. Select “Upgrade Database…”.

5. Select “Next”.

6. Depending on the size of the repository, this may run for several minutes.

7. When the upgrade is complete, there will be a “Success” message under “Status”. Click “Finish”.

8. Your repository upgrade is complete.

Filed Under: MDS Tagged With: Error Messages, Oops! Something went wrong

  • 1
  • 2
  • 3
  • 4
  • Next Page »
May 2025
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Mar    

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

#SQLSatATLBI Aereo at Atlanta Microsoft BI Azure Azure DataFest Backups Batch Certification changeset Chicago Conference CrashPlan Data Modeling Data Quality DAX Deployment DVR Entity-based staging Error Messages Excel Filter Goals Headphones Healthcare Leaf Tables MDM MDS MDS Add-in for Excel Oops! Something went wrong PASS Healthcare VC Power BI Power Pivot review Roku SQLSaturday SQL Saturday 800 SQLSaturday Atlanta BI SSIS Streaming Subscription View Time Training Validation Version Flag

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2025 · Minimum Pro Theme on Genesis Framework · WordPress · Log in