1 Reply Latest reply on Nov 14, 2018 4:34 PM by Justin Warwick

    Application install fails on error ORA-02291: integrity constraint (APEX_180100.WWV_PLUG_WEB_SRC_MODULE_FK)

    Justin Warwick

      While deploying an application from one environment to another, essentially identical (same db version, apex software version, same workspace ID and everything), one particular application fails during installation with this error:

      ApEx 18.1 on DB 12.2.0.1

      ERROR at line 1:

      ORA-02291: integrity constraint (APEX_180100.WWV_PLUG_WEB_SRC_MODULE_FK)

      violated - parent key not found

      ORA-06512: at "APEX_180100.WWV_FLOW_API", line 13425

      ORA-06512: at "APEX_180100.WWV_FLOW_API", line 13915

      ORA-06512: at line 27

       

      This occurs from Builder web ui as well as via sqlplus-based install (executing as parsing schema). Reproduced on 18.2 as well, via sqlplus. Could not finish attempt to reproduce on apex.oracle.com as the application install timed out.

      Has anyone run into this strange issue? How did you resolve?

      Other interesting details: according to log spool, it is indeed failing on the one page with an IR (not an IG) that has a websource as its source. Moreover, this page was created as a copy from another, neighboring application. The application export file was generated by the java-based apexexport tool.

      I do have an active SR open, I just wanted to see if anyone had run into it or had any insights.