Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX 22.1 - Application Export fails

NiallAug 15 2022 — edited Aug 16 2022

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
This post has been answered by Niall on Aug 22 2022
Jump to Answer

Comments

Post Details

Added on Aug 15 2022
#apex, #apex-discussions
24 comments
1,220 views
4 mentions