Summary
Resolve the execute permission error being thrown.
Symptoms
In the databaseCalls_Error.log file the following exception may be seen:
The EXECUTE permission was denied on the object 'fn_GetAppState', database 'CM_CAS', schema 'dbo'.
The EXECUTE permission was denied on the object 'fnGetSiteNumber', database 'CM_CAS', schema 'dbo'.
Cause
This appears to be a database permissions issue on the SCCM database.
Workaround
To workaround this issue, add the App Portal service account to the smschm_users role on the SCCM database. The smschm_users role grants Execute permission to the SCCM database.
Additional Information
This issue is being tracked internally as Issue #IOA-000124115