Forum Discussion

Toby Statham's avatar
Toby Statham
Brass Contributor
Mar 06, 2019
Solved

App launcher missing from from Modern Communication site collection in SharePoint 2019

The App launcher, settings cog and user profile info is missing from the nav-bar across the top of my Modern Communication & Team sites     All classic sites are just showing the settings cog ...
Modern Experience
sharepoint server
SharePoint Server 2019
  • Toby Statham's avatar
    Toby Statham
    Mar 07, 2019

    Did some further digging and found this in the logs

     

    System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'profile_GetUserProfileData', database 'SP2019_Profile', schema 'upa'.

     

    It looks like it's trying to run this sproc using the Application pool account of the Web Application. This account was not in the SPDataAccess role for the User Profile database.

     

    When I added the web application account to the SPDataAccess role for the User Profile database, voila the App launcher appeared.

    Should this account have access to the User Profile database and if so what would normally give it permission.

jcgonzalezmartin's avatar
jcgonzalezmartin
MVP
Mar 06, 2019
If I remember well, there was a problem in the Feb Update that could be the cause of this issue
Toby Statham's avatar
Toby Statham
Brass Contributor
Mar 06, 2019

Thanks jcgonzalezmartin is there anything anywhere that backs this up. Would be good to know that this is the problem and it's going to be fixed and that I don't have to keep digging through logs etc to see why it's not working.

Resources