Hi All,
we recently upgraded from 22.1 version to Appian 24.1 where APEX is installed on our DB server ( Physical Machine) and ORDS seats on Cloud VM.
After upgrade when we validated Application access , we are able to login as workspace admin and able to open the application in designer mode.
however when we click on SQL Workshop -→ Restful services , we are getting “Error processing authorization.” error.
Surprisingly its not happening for every workspace and affecting us only on few workspaces where Authorization schemes are created.
Same issue we are facing for all applications and their pages, when the authorization is defined.
When we are disabling the Authorization settings , these pages are working and opening successfully.
One additional interesting observation is , this issue we are facing ONLY on environment where we upgraded from 22.1 to 24.1 .
surprisingly same application & all its components are working absolutely fine on other environment where we freshly installed APEX 24.1 version. on Freshly installed APEX 24.1 version , app is not throwing any error.
Kindly assist what could be potential cause of this authorization error and how can we fix it ?
Error:
Access denied by Application security check
Technical Info (only available for developers)
- is_internal_error: true
- apex_error_code: APEX.AUTHORIZATION.ACCESS_DENIED
- component.type: APEX_APPLICATION_AUTHORIZATION
- component.id: 7416838475572336083
- component.name: APPLICATION SENTRY
- error_backtrace:----- PL/SQL Call Stack ----- object line object handle number name 0xd1334b78 1028 package body APEX_240100.WWV_FLOW_ERROR.INTERNAL_GET_ERROR 0xd1334b78 1097 package body APEX_240100.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR 0xd1334b78 1581 package body APEX_240100.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR 0x805ad790 978 package body APEX_240100.WWV_FLOW_AUTHORIZATION.IS_AUTHORIZED 0x8f4254a8 3005 package body APEX_240100.WWV_FLOW.SHOW 0xb46c27c0 173 procedure APEX_240100.F 0xe3566628 2 anonymous block