Forum Stats

  • 3,875,203 Users
  • 2,266,862 Discussions
  • 7,912,106 Comments

Discussions

APEX 22.1 - Application Export fails

13»

Answers

  • Jande87
    Jande87 Member Posts: 7 Red Ribbon
    edited Aug 23, 2022 10:29AM

    @Patrick Wolf-Oracle

    With your query (except the last line in where) I have found two lov definitions with no number definition, I have deleted it and now I can export the app via the builder—Tnx man.

    This was a problem.


    I have a generator that I made myself to generate pages through the APEX API.

    I usually generate whole forms with fields, buttons, and also lov's.

    It is possible that I did not provide a definition and a name for these lov's at the time of creation.

  • Steve Muench-Oracle
    Steve Muench-Oracle Member Posts: 5,468 Employee

    Thanks for confirming you were able to export the app after locating those two anomalous LOV definitions.

    Jande87
  • Gussay
    Gussay Member Posts: 223 Bronze Badge

    Hi ,

    We are having a similar issue. We are running on the Autonomous DB and the patch level of APEX is 22.1.4

    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.

    A big issue for us 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 thread and checked all of the suggested fixes. None of them work.

    Our errors differ though in that they are FLOW_SECURITY errors.

    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
    

    We set the NLS_LANG and the nls_numeric_characters

    --before call to SQLcl
    export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
    --inside SQLcl script
    DEFINE APP_ID = &1
    -- APEX Application Export Failing With the Error ORA-08177: can't serialize access for this transaction After Upgrade to 22.1 (Doc ID 2893264.1)
    alter session set nls_numeric_characters='.,';
    commit;
    apex export &APP_ID
    exit
    

    I have ran the query that @Patrick Wolf-Oracle suggested and there are no LOV definitions hanging with missing IDs as per @Jande87

    Any ideas?

    Gussay