Forum Discussion
App launcher missing from from Modern Communication site collection in SharePoint 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.
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.
Just signed in to thank you!!! Toby Statham
Got into this trouble after updating to KB5002229 & KB5002230.
Many thanks!!!!
laststav13 my fix was to delete the UserProfileService Appliaction. Immediatelly (without any UserProfileServiceApplication) the elemts on the websites appeared. I recreated UserProfileService nad MySite host and so on..... this did the trick for me.
I got errors like "ProfileDBCacheService.GetUserDataInternal Exception: System.InvalidOperationException: Microsoft.Office.Server.UserProfiles.Cache.UserProfileDBCache: Ungültige gespeicherte Prozeduren. Details finden Sie im DbCache-Dokument"
or
"Unable to retrieve User Mysite Url. Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException"
- This fixed it for me to. Thank you!
