Skip to Main Content

APEX 22.1 - Application Export fails

NiallAug 15 2022 — edited Aug 16 2022

Since our move to APEX 22.1 on ADB, we've been experiencing an error with our nightly exports of our applications using apex_export.get_application.
~It appears to be one (very large) application that is provoking this error. Other applications export correctly.~ This behaviour started about 10 days ago.
Has anyone else experienced a similar issue? Is it a bug? Is there a workaround?
This is 100% reproducible on our DB.
v_files apex_t_export_files;
v_files := apex_export.get_application (p_application_id => rec_apps.application_id);

Error message stack:
ORA-08177: can't serialize access for this transaction
ORA-06512: at "APEX_220100.WWV_FLOW_EXPORT_API", line 143
ORA-06512: at "APEX_220100.WWV_FLOW_GEN_API2", line 10218
ORA-06512: at "APEX_220100.WWV_FLOW_GEN_API2", line 7395
ORA-06512: at "APEX_220100.WWV_FLOW_GEN_API2", line 7395
ORA-06512: at "APEX_220100.WWV_FLOW_GEN_API2", line 10035
ORA-06512: at "APEX_220100.WWV_FLOW_EXPORT_INT", line 1234
ORA-06512: at "APEX_220100.WWV_FLOW_EXPORT_API", line 81

This post has been answered by Niall on Aug 22 2022
Jump to Answer
Post Details
Added on Aug 15 2022