3 Replies Latest reply: Aug 7, 2013 5:11 AM by Fanny__ RSS

    apex_application_install : ORA-02291: integrity constraint (APEX_040100.WWV_FLOWS_FK) violated

    Fanny__

      Hello,

       

      My current version : Apex 4.1.1.00.23 ; with OHS.

      I'm using the apex_application_install package for a long time.

      Here I'm trying to import an application which I've modified in another instance. Source application Id : 2126 ;  target application Id : 2201.

       

      begin
      apex_application_install.set_application_id( 2201);
      apex_application_install.set_offset( p_offset => 8977032305205669 );
      apex_application_install.set_application_name('APP_TST');
      apex_application_install.set_application_alias( 'F2201');
      apex_application_install.set_schema( 'SCH_TST' );
      end;
      /
      @f2126
      

       

      First I get an error cause the target application was not deleted yet. So I deleted both of it (2126 and 2201). But now :

       

      APPLICATION 2126 - APP_DEV
      Set Credentials...
      Check Compatibility...
      Set Application ID...
      begin
      *
      ERROR at line 1:
      ORA-02291: integrity constraint (APEX_040100.WWV_FLOWS_FK) violated - parent
      key not found
      ORA-06512: at "APEX_040100.WWV_FLOW_API", line 679
      ORA-06512: at line 3
      

       

       

      Add a 'generate_offset' instead of the 'set_offset..' doesn't resolve anything.

       

      So I've 2 questions :

      1) How can I import this application

      2) If I must delete the target application before the import, how can I keep metadata, I mean saved interactive reports each user have created for each application ?

       

      Many thanks for your help.

       

      Fanny