We are running on the Autonomous DB and the patch level of APEX is 22.1.6
Since the upgrade to Apex 22.1 , we are experiencing the following random error.
Exporting Application 111
APEX: Unable to process request. Verify specified options:
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_SECURITY", line 858
ORA-06512: at "APEX_220100.WWV_FLOW_SECURITY", line 906
ORA-06512: at "APEX_220100.WWV_FLOW_SECURITY", line 2912
ORA-06512: at "APEX_220100.WWV_FLOW_EXPORT_INT", line 88
ORA-06512: at "APEX_220100.WWV_FLOW_EXPORT_API", line 59
ORA-06512: at line 2
Disconnected from Oracle Database 19c Enterprise Edition Release 220.127.116.11.0 - Production
Using Azure Devops, we run a pipeline to export 7 apps and it is random which apps will fail, looping round the same function. This has been working faultlessly for a couple of years now.... until the 22.1 Apex Upgrade. There doesn't seem to be any pattern to the failures either, 1 export could fail or any number could fail... or they could all export successfully. We've recently had a week of no errors, but now they are back.
A big issue for us is that when it fails, it fails silently according to the pipeline. We cannot transfer the error back from SQLcl to our command line call.
I have read through this post apex-22-1-application-export-fails and checked all of the suggested fixes. None of them work.
Any ideas? Thanks in advance