Forum Stats

  • 3,872,908 Users
  • 2,266,489 Discussions
  • 7,911,380 Comments

Discussions

APEX 22.1 - Application Export fails - ORA-08177: can't serialize access for this transaction

Gussay
Gussay Member Posts: 223 Bronze Badge
edited Nov 9, 2022 11:25AM in APEX Discussions

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 19.0.0.0.0 - Production
Version 19.17.0.1.0

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

Gussay

Tagged: