I have an application which I develop on one APEX service running in OCI, and deploy to another APEX service in a different tenancy in OCI. This worked successfully with our last few deployments, the most recent being about 3 weeks ago. We've made some updates to the application (nothing I'd consider “wild” or “unsupported”, just rearranging page items, setting some serverside conditions, etc) and need to deploy those changes to our “prod” instance.
Trying to do so results in this error:
From Workspace Utilities > Monitor Activity > Application Errors I found this:
Error: Error processing validation.
- 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.VALIDATION.UNHANDLED_ERROR
- SQL code: -20987
- SQL error: ORA-20987: Error at line 1, col 1: Unexpected character "<"
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 304
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 608
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 946
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 970
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 1547
ORA-06512: at line 1
ORA-06512: at "APEX_230200.WWV_FLOW_REMOTE_DEPLOY_DEV", line 134
ORA-06512: at "APEX_230200.WWV_FLOW_REMOTE_DEPLOY_DEV", line 134
ORA-06512: at line 8
ORA-06512: at line 10
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 304
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC", line 376
ORA-06512: at "APEX_230200.WWV_FLOW_VALIDATION", line 421
ORA-06512: at "APEX_230200.WWV_FLOW_VALIDATION", line 907
ORA-06512: at "A~
- Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 608
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 946
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 970
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 1547
ORA-06512: at line 1
ORA-06512: at "APEX_230200.WWV_FLOW_REMOTE_DEPLOY_DEV", line 134
ORA-06512: at "APEX_230200.WWV_FLOW_REMOTE_DEPLOY_DEV", line 134
ORA-06512: at line 8
ORA-06512: at line 10
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 304
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 608
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 946
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 970
ORA-06512: at "APEX_230200.WWV_FLOW_JSON", line 1547
ORA-06512: at line 1
ORA-06512: at "APEX_230200.WWV_FLOW_REMOTE_DEPLOY_DEV", line 134
ORA-06512: at "AP~
- Statement: declare function x return varchar2 is begin begin
if nvl(:P4905_EMPTY_CREDENTIAL,'N') = 'Y' then
wwv_flow_credential.set_session_credentials(
p_credential_id => :P4905_CREDENTIAL_ID,
p_client_id => :P4905_CLIENT_ID,
p_client_secret => :P4905_CLIENT_SECRET );
end if;
return wwv_flow_remote_deploy_dev.validate_deployment_server(p_server_id => :P4905_SERVER_ID);
end;
return null; end; begin wwv_flow.g_computation_result_vc := x; end;
- Component: APEX_APPLICATION_PAGE_VAL Validate Remote Server (11601005038734806)
Both instances are on 23.2.0. I confirmed the credentials are good, and the endpoint and other settings are unmodified since last time this would have been deployed. I was able to export and import individual pages and copy them into my application as a workaround.
How can I get this working again? Any suggestions are welcome, I miss this feature!