Hello,
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.
Code:
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