theme-sticky-logo-alt

An unexpected error has occurred when a user clicks on My Settings to access MySites

4 Comments

I was recently hit by an error that when a user clicked on “My Settings” under his username to access his MySite, he had an Unexpected Error!

An unexpected error has occurred My Settings

An unexpected error has occurred My Settings

With nothing in Event Viewer, I checked the ULS log and found this:

System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'Admin_GetPartitionProperties', database 'Profile DB', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
SqlError: 'The EXECUTE permission was denied on the object 'Admin_GetPartitionProperties', database 'Profile DB', schema 'dbo'.'    Source: '.Net SqlClient Data Provider' Number: 229 State: 5 Class: 14 Procedure: 'Admin_GetPartitionProperties' LineNumber: 1 Server: SPSQL\SharePoint1
Failure checking user access permissions for User Profile Application Proxy 'User Profile Service Application'. Exception: System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'Admin_GetPartitionProperties', database 'Profile DB', schema 'dbo'.

Following that, I found out that the account running the Web Application Pool where I had the problem didn’t have access to the User Profile Service Application “Profile” Database. I gave it the “SpDataAcces” role like in the following screenshot:


Immediately after, my top suite bar changed! The “My Settings” changed for “About Me” and I also had all the “Newsfeed SkyDrive Sites” elements added. I was then able to access MySite without problems!


That fixed my problem and I hope it will help you fix yours as well!

Leave  a comment and don’t forget to like the page on Facebook here and to follow me on Google+ here and on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content

Previous Post
SharePoint Management Shell – Exception has been thrown by the target of an invocation
Next Post
Win an Achievement Unlocked T-shirt by doing MVA classes [Canada Only]

4 Comments

  • November 17, 2014 at 5:08 am
    Thomas Radman

    I got the same Problem with a fresh sharepoint-installation (through autospinstaller)
    Is there a way to set SPDataAccess role for the webapplicationpool-account through the API (which is recommended anyway)
    I use GrantAccessToProcessIdentity for ContentDBs but this would not work for ServiceDBs.

    Reply
  • April 2, 2015 at 10:40 am
    Jorge

    How did you make your screenshots? I like them!

    Reply
  • June 11, 2019 at 12:05 pm
    Krishna

    Thank you for the post. It helped me resolving an issue in my environment SP 2019.

    Reply

Leave a Reply

15 49.0138 8.38624 1 0 4000 1 https://vladtalkstech.com 300 1