We're migrating a FOEX application to Apex 19.2 (FOEX v4.2) and seeing this in the Debug log. Since it was an Ajax call, I wondered if it was caused by a FOEX call?
Versions:
- This is a new installation of Apex 19.2 and FOEX 4.2.
- That's including the Hotfix HFXP-4434, installed from Feb 2, 2021 version (which seems to be the same source as your latest March 22, 2021 version).
The application displays this error:
Ajax call returned server error ORA-06502: PL/SQL: numeric or value error for .
When I clicked the link for that error in the browser console, it showed the attached Apex debug page.
The full debug messages, showing the context of the error are:
| ... sentry+verification success |
| ...Session ID 13640088631470 can be used |
| < APEX_APPLICATION_AUTH aeo_web_security <-- Our custom Authentication Schema |
| ...Setting session time_zone to -04:00 |
| ...Check for session expiration: |
| ......Validate item page affinity |
| Decrypted value does not start with space: "¿¿C¿¿8¿tID" |
| Error: Ajax call returned server error ORA-06502: PL/SQL: numeric or value error for . |
| - is_internal_error: true |
| - is_common_runtime_error: false |
| - apex_error_code: APEX.AJAX_SERVER_ERROR |
| - ora_sqlcode: -6502 |
| - ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APEX_190200.WWV_FLOW_CRYPTO", line 227
ORA-06512: at "APEX_190200.WWV_FLOW_SECURITY", line 2763
ORA-06512: at "APEX_190200.WWV_FLOW_SECURITY", line 3283
ORA-06512: at "APEX_190200.WWV_FLOW", line 2881 |
| - error_backtrace: ORA-06512: at "APEX_190200.WWV_FLOW_CRYPTO", line 227
ORA-06512: at "APEX_190200.WWV_FLOW_SECURITY", line 2763
ORA-06512: at "APEX_190200.WWV_FLOW_SECURITY", line 3283
ORA-06512: at "APEX_190200.WWV_FLOW", line 2881
ORA-06512: at "APEX_190200.WWV_FLOW", line 3083 |
I also noticed some console errors (see smaller attachment).
Any ideas would be greatly appreciated.
Stew
