FIX: "The user does not have permissions or the object ID is not valid" error when you publish a member in MDS
Assume that you use the Microsoft SQL Server 2014 MDS Add-in for Excel to connect to a Master Data Services repository. When you publish a member for which the code field contains non-breaking spaces, you receive the following error message:
The user does not have permissions or the object ID is not valid.
Note This issue doesn't occur when you add or edit members in the MDS Explorer.
Cumulative update informationThe issue was first fixed in the following cumulative update of SQL Server 2014:
Recommendation: Install the latest cumulative update for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server 2014:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3132336 - Last Review: 02/22/2016 18:15:00 - Revision: 1.0
Microsoft SQL Server 2014 Service Pack 1
- kbfix kbqfe kbsurveynew kbexpertiseadvanced KB3132336