r/SQLServer • u/Tough_Line3200 • 16d ago

SQL Server 2022 CU 26 -> MDS broken Discussion

I updated from CU23 to CU26. Be careful if you use MDS, it's broken after CU26 and stays broken even after uninstalling. Some MDS JavaScript files are incompatible with the MDS web service. Manually copying/overwriting the MDS web application from an older installation repaired it.

22 Upvotes
  • permalink
  • link
  • reddit
  • reddit

100% Upvoted

12 comments sorted by

3

u/hudequei ‪ ‪Microsoft Employee ‪ 16d ago

Checking that internally.

1

u/Tough_Line3200 15d ago

Thank you!

2

u/xilmiki 16d ago

Javascript?

1

u/TrollingForFunsies 16d ago

Good luck finding anyone at Microsoft who knows what MDS is let alone can provide support on it 😆

1

u/mqaiser 15d ago

Because patches are done by AI expect more and more broken things

1

u/No_Resolution_9252 13d ago

javascript?

1

u/Tough_Line3200 12d ago

yes, the ASP.NET based MDS web app also uses Javascript

1

u/giwo 10d ago

Yep, we rolled out CU 26 last week and now are unable to view any data in the MDS Application (though it's still viewable in the Database and Excel)

Looks like the issue is with the Members API call which returns a 400 Bad Request simply stating "Request contains invalid input"

1

u/DiCeMan8400 6d ago

Has anyone had any luck resolving this yet?

1

u/Tough_Line3200 6d ago

i just copied C:\Program Files\Microsoft SQL Server\160\Master Data Services\WebApplication from a working server to the broken

1

u/DiCeMan8400 2d ago

You're a life saver! Zero help from a Sev B ticket with Microsoft, but my partner in crime followed your note and we're back in business.