Error Log Shows Execute Permission Was Denied on the Object 'Fngetsitenumber'
SummaryResolve the execute permission error being thrown.
SymptomsIn 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'.
CauseThis appears to be a database permissions issue on the SCCM database.
WorkaroundTo 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 InformationThis issue is being tracked internally as Issue #IOA-000124115