Same error as: https://forums.oracle.com/ords/apexds/post/ords-failing-with-http-status-code-572-recoverable-database-8182
but different and very confusing circumstances.
APEX 24.2.13 on an OCI ADB.
I created a “Workflow Console” page via the wizard. When I try to open the modal form page, I get this error:
When I want to look at the page in the Application Builder, the page does not completely load:
It seems to be a problem on my instance. When I export/import the application to another ADB instance, everything works.
I have the same issue in every workspace on this instance. The original problem arose in a workspace where I was experimenting with workflows, i.e. I created workflows, created some wf instances, etc. At first, the form page worked fine; I don't know at what point it stopped working.
Even if I create an empty application in a previously empty workspace, only create the two “My Workflows” pages with the wizard, I have the same issue. When I do the exact same thing on a different ADB, I have no problem.
When trying to debug the Application Builder session:
This is the instance where the page loads:
And this is where it does not load:
No error in any of the debugs.
Also no application error.
Is it possible that corrupt entries in apex_workflow in one workspace could influence other workspaces?
How could I purge everything in apex_workflow?
Additional info:
- I have the same problem with My Workflows and Admin Workflows
- I tried modal and normal form page, same issue for both
- I did not do any direct updates in the workflow tables; I only used the APEX_WORKFLOW API.
I don't know what else I could try…
Thanks for ideas on how to solve this problem!
Reto