Hi,
I am a DBA and not much an apex guy. lately I am trying to migrate non-cdb to pdb (both 19.18 version)but applications in the company are developed by APEX and APEX 22.2.4 & Ords 22.4 versions are in use.
When I do the migration, pdb is created accordingly but when we tried to connect to ords (like localhost:8080/ords) we got some error, some times we are able to login but when we try to open a page in a project, it fails again and give us debug id.
we check this debug id on apex_220200.wwv_flow_debug_messages table (via page_view_id column) there are errors like this:
APEX Version=22.2.4
Patch Version=4
SID=644
USER=APEX_PUBLIC_USER
ECID=dj1BvtMninV39GHwj3B7jw
PROXY_USER=ORDS_PUBLIC_USER
INSTANCE=1
CGI: PATH_INFO = /f?p=4000:4500:4176641553607::::FB_FLOW_ID%2CFB_FLOW_PAGE_ID:500%2C2
GET http://newdev.nnnn.com/ords
REMOTE_USER=APEX_PUBLIC_USER
APEX_LISTENER_VERSION=22.4.0.r3401044
REFERER=https://newdev.nnnn.com/
Error: Error processing request.
- additional_info: Contact your application administrator.
- display_location: ON_ERROR_PAGE
- is_internal_error: true
- is_common_runtime_error: false
- apex_error_code: APEX.UNHANDLED_ERROR
- ora_sqlcode: -6508
- ora_sqlerrm: ORA-04065: not executed, altered or dropped stored procedure APEX_220200.WWV_FLOW_JSON
ORA-06508: PL/SQL: could not find program unit being called: APEX_220200.WWV_FLOW_JSON
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 726
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 1017
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 2857
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 3157
- error_backtrace: ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 726
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 1017
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 2857
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 3157
ORA-06512: at APEX_220200.WWV_FLOW, line 3308
- component: APEX_APPLICATION_PAGES Page Designer (4000000004500)
Error painting error page: ORA-04065: not executed, altered or dropped stored procedure APEX_220200.WWV_FLOW_JSON
ORA-06508: PL/SQL: could not find program unit being called: APEX_220200.WWV_FLOW_JSON
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 726
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 1017
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 2857
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 3419
ORA-04065: not executed, altered or dropped stored procedure APEX_220200.WWV_FLOW_JSON
ORA-06508: PL/SQL: could not find program unit being called: APEX_220200.WWV_FLOW_JSON
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 726
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 1017
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 2857
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 3157
Backtrace: ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 726
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 1017
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 2857
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 3419
ORA-06512: at APEX_220200.WWV_FLOW_ERROR, line 326
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 3419
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 726
ORA-06512: at APEX_220200.WWV_FLOW_JAVASCRIPT, line 1017
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 2857
ORA-06512: at APEX_220200.WWV_FLOW_PAGE, line 3157
ORA-06512: at APEX_220200.WWV_FLOW, line 3308
there is no invalid objects on apex schema (or any other schema different than non-cdb version), APEX_220200.WWV_FLOW_JSON is valid and procedure is working (tried on plsql). I did migration few times and it points different packages like HTMLDB_UTIL or APEX_220200.WWV_FLOW_STRING etc.
again this is not a compilation issue. objects are VALID and even if we restart ords we still get same errors. I also open a thread in general section (https://forums.oracle.com/ords/apexds/post/migrate-non-cdb-to-pdb-with-apex-3153)
is there any one dealt with this? Also, as you know when you migrate non-cdb to pdb, DBID is changing so could this be the reason? should we reinstall apex and ords? thanks.