0 Replies Latest reply on Aug 9, 2018 9:55 PM by AndyH

    Error importing 18.1 workspace

    AndyH

      I have an 18.1 installation (upgraded from 4.2) running on an 11g database.

       

      I have a second 18.1 installation on a 12.2 database.

       

      I exported a workspace from the 11g database using the APEX administration tool.

       

      When I try to import into the 12.2 database I get the following error:

       

      Execution of the statement was unsuccessful. ORA-02291: integrity constraint (APEX_180100.WWV_FLOW_FND_GU_INT_G_FK) violated - parent key not found 
      begin wwv_flow_fnd_user_api.create_fnd_user (
         p_user_id                      => '1296001321801907',
         p_user_name                    => 'ANDY',
         p_first_name                  => 'Andy',
         p_last_name                    => 'Hardy',
         p_description                  => '',
         p_email_address                => 'andy@hardyfamily.org.uk',
         p_web_password                => '0FDFDFD740282741266104E5244EB9A8',
         p_web_password_format          => '3;1;',
         p_group_ids                    => '1760312063204924:1760422769204936:1760545087204937:',
         p_developer_privs              => 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
         p_default_schema              => 'SCOUTS',
         p_account_locked              => 'N',
         p_account_expiry              => to_date('201007040000','YYYYMMDDHH24MI'),
         p_failed_access_attempts      => 0,
         p_change_password_on_first_use => 'N',
         p_first_password_use_occurred  => 'N',
         p_allow_app_building_yn        => 'Y',
         p_allow_sql_workshop_yn        => 'Y',
         p_allow_websheet_dev_yn        => 'Y',
         p_allow_team_development_yn    => 'Y',
         p_allow_access_to_schemas      => ''); end;
      

       

      From the constraint name I assume that the issue is related to the group ids for the user? On the source instance this user is associated with the 'usual' built-in groups e.g. Oauth, SQL Developer, etc.

       

      Any ideas on how to complete the import?