Hello,
I'm using VB Studio to export an apex application from dev and import into our test apex instance. I was able to generate the source file for example f100.sql like using sqlcl.
=============================
apex export -applicationid 100 -exptype application_source -skipExportDate -expOriginalIds -dir code.
=============================
In my case both dev and test have same workspace names and same user.
When I try to import that into test apex instance using another sqlcl step, I get ORA-02291: integrity constraint (APEX_220200.WWV_FLOWS_FK) violated - parent key not found error.
This is my import step with sqlcl.
=====================================
begin
apex_application_install.set_application_id(100);
apex_application_install.generate_offset;
apex_application_install.set_application_alias( 'F' || apex_application_install.get_application_id );
end;
/
@f100.sql
========================================
Please let me know what I'm doing wrong.
Thanks
Prasad
here is the log
==================================================================
Error starting at line : 81 File @ /data/cibuild/5da036f2-4dbb-48bb-8845-96493cce5d8f/workspace/f100.sql
[2023-01-16 19:47:58] In command -
[2023-01-16 19:47:58] begin
[2023-01-16 19:47:58] wwv_flow_imp.create_flow(
[2023-01-16 19:47:58] p_id=>wwv_flow.g_flow_id
[2023-01-16 19:47:58] ,p_owner=>nvl(wwv_flow_application_install.get_schema,'WKSP_DEMO')
[2023-01-16 19:47:58] ,p_name=>nvl(wwv_flow_application_install.get_application_name,'Amt Rules')
[2023-01-16 19:47:58] ,p_alias=>nvl(wwv_flow_application_install.get_application_alias,'AMT-RULES')
[2023-01-16 19:47:58] ,p_page_view_logging=>'YES'
[2023-01-16 19:47:58] ,p_page_protection_enabled_y_n=>'Y'
[2023-01-16 19:47:58] ,p_checksum_salt=>'C560EDEE80AEBED98E6183987F8AC050F8495ED1C5E926B73667838FA733B35E'
[2023-01-16 19:47:58] ,p_bookmark_checksum_function=>'SH512'
[2023-01-16 19:47:58] ,p_compatibility_mode=>'21.2'
[2023-01-16 19:47:58] ,p_flow_language=>'en'
[2023-01-16 19:47:58] ,p_flow_language_derived_from=>'FLOW_PRIMARY_LANGUAGE'
[2023-01-16 19:47:58] ,p_allow_feedback_yn=>'Y'
[2023-01-16 19:47:58] ,p_date_format=>'DS'
[2023-01-16 19:47:58] ,p_timestamp_format=>'DS'
[2023-01-16 19:47:58] ,p_timestamp_tz_format=>'DS'
[2023-01-16 19:47:58] ,p_direction_right_to_left=>'N'
[2023-01-16 19:47:58] ,p_flow_image_prefix => nvl(wwv_flow_application_install.get_image_prefix,'')
[2023-01-16 19:47:58] ,p_authentication=>'PLUGIN'
[2023-01-16 19:47:58] ,p_authentication_id=>wwv_flow_imp.id(9128928567289070)
[2023-01-16 19:47:58] ,p_application_tab_set=>1
[2023-01-16 19:47:58] ,p_logo_type=>'T'
[2023-01-16 19:47:58] ,p_logo_text=>'Amt Rules'
[2023-01-16 19:47:58] ,p_proxy_server=>nvl(wwv_flow_application_install.get_proxy,'')
[2023-01-16 19:47:58] ,p_no_proxy_domains=>nvl(wwv_flow_application_install.get_no_proxy_domains,'')
[2023-01-16 19:47:58] ,p_flow_version=>'Release 1.0'
[2023-01-16 19:47:58] ,p_flow_status=>'AVAILABLE_W_EDIT_LINK'
[2023-01-16 19:47:58] ,p_exact_substitutions_only=>'Y'
[2023-01-16 19:47:58] ,p_browser_cache=>'N'
[2023-01-16 19:47:58] ,p_browser_frame=>'D'
[2023-01-16 19:47:58] ,p_runtime_api_usage=>'T'
[2023-01-16 19:47:58] ,p_security_scheme=>wwv_flow_imp.id(9334709634289487)
[2023-01-16 19:47:58] ,p_rejoin_existing_sessions=>'N'
[2023-01-16 19:47:58] ,p_csv_encoding=>'Y'
[2023-01-16 19:47:58] ,p_auto_time_zone=>'N'
[2023-01-16 19:47:58] ,p_substitution_string_01=>'APP_NAME'
[2023-01-16 19:47:58] ,p_substitution_value_01=>'Amt Rules'
[2023-01-16 19:47:58] ,p_last_updated_by=>'DEMO'
[2023-01-16 19:47:58] ,p_last_upd_yyyymmddhh24miss=>'20230108201409'
[2023-01-16 19:47:58] ,p_file_prefix => nvl(wwv_flow_application_install.get_static_app_file_prefix,'')
[2023-01-16 19:47:58] ,p_files_version=>4
[2023-01-16 19:47:58] ,p_print_server_type=>'NATIVE'
[2023-01-16 19:47:58] ,p_is_pwa=>'Y'
[2023-01-16 19:47:58] ,p_pwa_is_installable=>'N'
[2023-01-16 19:47:58] );
[2023-01-16 19:47:58] end;
[2023-01-16 19:47:58] Error report -
[2023-01-16 19:47:58] ORA-02291: integrity constraint (APEX_220200.WWV_FLOWS_FK) violated - parent key not found
[2023-01-16 19:47:58] ORA-06512: at "APEX_220200.WWV_FLOW_IMP", line 1843
[2023-01-16 19:47:58] ORA-06512: at line 2
[2023-01-16 19:47:58] 02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
[2023-01-16 19:47:58] *Cause: A foreign key value has no matching primary key value.
[2023-01-16 19:47:58] *Action: Delete the foreign key or add a matching primary key.