Forum Discussion
SQL 2022 mds issue
Hi Everyone,
Im having an issue whereby in mds we are unable to view attributes and we can add attributes. When i try add attributes it just loads no errors. I did restore a copy of mds database of a working database that mds was working and still experience the same issue.
2 Replies
- MW_DEVBrass Contributor
Hi, This looks very similar to a known issue affecting Master Data Services in recent SQL Server 2022 cumulative updates. Microsoft has officially acknowledged in the CU27 release notes (KB5104824) that certain MDS operations, including creating attributes, creating entities, and loading hierarchies in Explorer, may fail or not load correctly.
Could you check which SQL Server 2022 build you're currently running? Please execute
SELECT @@VERSIONIf you're running CU26 or CU27, you may be experiencing this known issue.
Microsoft is investigating a fix. There is also a related Microsoft Q&A thread reporting that CU26 breaks the MDS web application while leaving the database intact. This would explain why restoring a working MDS database didn't help.
Official Microsoft documentation:
https://support.microsoft.com/en-au/servicing/sql/sql-server-2022/cumulative-update/kb5104824-cu27
Related Microsoft Q&A discussion:
https://learn.microsoft.com/en-us/answers/questions/5993516/master-data-services-web-app-renders-empty-after-s
I would recommend checking the installed build and opening a Microsoft support case before attempting any rollback or manual replacement of MDS application files.
- rmx1Copper Contributor
Hi MW_DEV
thanks for the help and feedback. I didnt see the issue on the cu's before maybe it was updated afterwards.
I will further have a look on myside maybe i can try uninstall the patch and install the old one that worked before also as a fallback create a vmware snapshot of the serve before change that way i can revert if need be . Last resort log a case with microsoft if its still not working.