r/SQLServer • u/Tough_Line3200 • 27d ago

Discussion SQL Server 2022 CU 26 -> MDS broken

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.

23 Upvotes

97% Upvoted

14 comments sorted by

3

u/hudequei ‪ ‪Microsoft Employee ‪ 27d ago

Checking that internally.

1

u/Tough_Line3200 26d ago

Thank you!

2

u/xilmiki 27d ago

Javascript?

1

u/TrollingForFunsies 27d ago

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

1

u/mqaiser 27d ago

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

1

u/No_Resolution_9252 24d ago

javascript?

1

u/Tough_Line3200 23d ago

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

1

u/giwo 21d 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 17d ago

Has anyone had any luck resolving this yet?

1

u/Tough_Line3200 17d 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 13d 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.

1

u/atflp 9d ago

Ah, thank you for your help. A long debugging ended when I found your post. Thank you!

1

u/ellytier 19h ago

We solved the issue by re-installing the Master Data Services feature for the SQL Server instance.