APEX 24.2
Using Social Sign-In with OpenId.
Sign-In works without issues, but on logging out, the user sees the message:
Error processing request.
Contact your application administrator.
Return to application.
The URL showing in their browser is of the form:
https://myapp.mydom.com/myords/apex_authentication.logout?p_app_id=123@p_session_id=12345678
which looks good to me.
Turned on extra debugging, which shows:
Debug Row 1
APEX Version=24.2.10
Patch Version=5
SID=241
USER=APEX_PUBLIC_USER
ECID=hki4buuE0QYQM5V-UhgmYw
PROXY_USER=ORDS_PUBLIC_USER
INSTANCE=1
The callstack for the above shows:
%ERROR.debug_error:1868
%ERROR.exec_error_handling_callback:950
%ERROR.internal_get_error:1064
%ERROR.internal_add_error:1124
%ERROR.raise_internal_error:1608
%SECURITY.unhandled_error:4134
%SECURITY.final_exception_handler:4156
%AUTHENTICATION.execute_logout:3326
%AUTHENTICATION_API.logout:165 :2
Debug Row 2
CGI: PATH_INFO = /apex_authentication.logout?p_app_id=110&p_session_id=7495063535644
Debug Row 3
GET https://myapp.mydom.com/myords
REMOTE_USER=APEX_PUBLIC_USER
ORDS_VERSION=24.2.0.r1692208
REFERER=https://myapp.mydom.com/myords/f?p=110:10:7495063535644
Debug Row 4
Error: Error processing request.
- Additional info: Contact your application administrator.
- Display location: ON_ERROR_PAGE
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: true
- Common runtime error: false
- APEX error code: APEX.UNHANDLED_ERROR
- SQL code: -6502
- SQL error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APEX_240200.WWV_FLOW_UTILITIES", line 5841
ORA-06512: at "APEX_240200.WWV_FLOW_AUTHENTICATION_SOCIAL", line 1256
ORA-06512: at "APEX_240200.WWV_FLOW_AUTHENTICATION_NATIVE", line 463
ORA-06512: at "APEX_240200.WWV_FLOW_AUTHENTICATION_NATIVE", line 1350
ORA-06512: at "APEX_240200.WWV_FLOW_PLUGIN", line 4736
- Backtrace: ORA-06512: at "APEX_240200.WWV_FLOW_UTILITIES", line 5841
ORA-06512: at "APEX_240200.WWV_FLOW_AUTHENTICATION_SOCIAL", line 1256
ORA-06512: at "APEX_240200.WWV_FLOW_AUTHENTICATION_NATIVE", line 463
ORA-06512: at "APEX_240200.WWV_FLOW_AUTHENTICATION_NATIVE", line 1350
ORA-06512: at "APEX_240200.WWV_FLOW_PLUGIN", line 4736
ORA-06512: at "APEX_240200.WWV_FLOW_AUTHENTICATION", line 3296
- Statement:
- Component: APEX_APPLICATION_AUTH MYAUTHN (26548243713281800)
The home URL is: f?p=&APP_ID.:1:&SESSION.
The logout URL is: f?p=&APP_ID.:LOGIN_DESKTOP:&SESSION.
Page 101 has the alias of login_desktop.
Any ideas?