We have just upgraded one of our OCI ATP DBs to 23ai, and with APEX 24.2.0 when we try to open the About Oracle APEX dialog we now get a ‘Bad Request’ error shown in the iFrame.
Looking in apex_debug_messages I see the following error:
Error: Error during rendering of region "About &PRODUCT_NAME.".
- Additional info:
- 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.REGION.UNHANDLED_ERROR
- SQL code: -6502
- SQL error: ORA-06502: PL/SQL: value or conversion error: character string buffer too small
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 1962
ORA-06512: at "APEX_240200.WWV_FLOW_DISP_PAGE_PLUGS", line 1706
ORA-06512: at "APEX_240200.WWV_FLOW_DISP_PAGE_PLUGS", line 940
ORA-06512: at "APEX_240200.WWV_FLOW_DISP_PAGE_PLUGS", line 1706
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 155
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2757
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_MLE_DEV", line 278
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_MLE_DEV", line 278
ORA-06512: at line 1
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2240
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2717
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 130
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 300
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC", line 312
ORA-06512: at "APEX_240200.WWV_FLOW_~
- Backtrace: ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_MLE_DEV", line 278
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_MLE_DEV", line 278
ORA-06512: at line 1
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2240
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2717
ORA-06512: at "APEX_240200.WWV_FLOW_PAGE", line 1962
ORA-06512: at "APEX_240200.WWV_FLOW_DISP_PAGE_PLUGS", line 1706
ORA-06512: at "APEX_240200.WWV_FLOW_DISP_PAGE_PLUGS", line 940
ORA-06512: at "APEX_240200.WWV_FLOW_DISP_PAGE_PLUGS", line 1706
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 155
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2757
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_MLE_DEV", line 278
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_MLE_DEV", line 278
ORA-06512: at line 1
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2240
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200", line 812
ORA-06512: at "APEX_240200.W~
- Statement: declare function x return CLOB is begin return wwv_flow_code_exec_mle_dev.get_about_html;
return null; end; begin APEX_240200.wwv_flow_exec_api.g_value.clob_value := x; end;
- Component: APEX_APPLICATION_PAGES About &PRODUCT_NAME. (4350000000009)
This DB was upgraded as a clone from a 19c DB. No grants have been done to any schemas for anything MLE related, but the error appears to be coming from MLE related packages.
The error does not appear on our other environments running 19c DB and APEX 24.2.0.
Kind Regards,
Cj