Hi,
I am trying to install our application into a runtime environment for the first time. Apex 18.2.
I do not want to export and import the workspace from the development environment, the name is not appropriate and I do not need the users either. I created a workspace as seen in the doc
BEGIN
APEX_INSTANCE_ADMIN.ADD_WORKSPACE (
p_workspace_id => 8675309,
p_workspace => 'MY_WORKSPACE',
p_primary_schema => 'SCOTT',
p_additional_schemas => 'SCOTT' );
END;
(using different names of course).
After that I exported the plugins and the application from the development. I try to run the install script as APEX_180200 in the uat runtime, the plugins install fine, but the application import dies with a
ORA-02291: integrity constraint (APEX_180200.WWV_FLOWS_FK) violated - parent key not found
ORA-06512: at "APEX_180200.WWV_FLOW_API", line 4046
ORA-06512: at line 2
The instruction is
begin
wwv_flow_api.create_flow(
p_id=>wwv_flow.g_flow_id
,p_display_id=>nvl(wwv_flow_application_install.get_application_id,101)
,p_owner=>nvl(wwv_flow_application_install.get_schema,'CEB')
,p_name=>nvl(wwv_flow_application_install.get_application_name,'EasyBEC')
,p_alias=>nvl(wwv_flow_application_install.get_application_alias,'101')
,p_page_view_logging=>'YES'
,p_page_protection_enabled_y_n=>'Y'
,p_checksum_salt=>'23C5D02151B896ADF9B103D487CB768070FC71ED44B64952977C0193D1705ABA'
,p_bookmark_checksum_function=>'SH1'
,p_compatibility_mode=>'5.1'
,p_flow_language=>'en'
,p_flow_language_derived_from=>'FLOW_PRIMARY_LANGUAGE'
,p_allow_feedback_yn=>'Y'
,p_date_format=>'DD-MM-YYYY'
,p_direction_right_to_left=>'N'
,p_flow_image_prefix => nvl(wwv_flow_application_install.get_image_prefix,'')
,p_documentation_banner=>'Application created from create application wizard 2018.11.19.'
,p_authentication=>'PLUGIN'
,p_authentication_id=>wwv_flow_api.id(19497679835912767)
,p_application_tab_set=>0
,p_logo_image=>'TEXT:EasyBEC'
,p_public_user=>'APEX_PUBLIC_USER'
,p_proxy_server=>nvl(wwv_flow_application_install.get_proxy,'')
,p_no_proxy_domains=>nvl(wwv_flow_application_install.get_no_proxy_domains,'')
,p_flow_version=>'Release 0.0.0.1'
,p_flow_status=>'AVAILABLE_W_EDIT_LINK'
,p_flow_unavailable_text=>'This application is currently unavailable at this time.'
,p_build_status=> 'RUN_ONLY'
,p_exact_substitutions_only=>'Y'
,p_browser_cache=>'N'
,p_browser_frame=>'D'
,p_runtime_api_usage=>'T'
,p_rejoin_existing_sessions=>'N'
,p_csv_encoding=>'Y'
,p_auto_time_zone=>'N'
,p_substitution_string_01=>'APP_NAME'
,p_substitution_value_01=>'EasyBEC'
,p_last_updated_by=>'HK'
,p_last_upd_yyyymmddhh24miss=>'20190212160026'
,p_file_prefix => nvl(wwv_flow_application_install.get_static_app_file_prefix,'')
,p_files_version=>3
,p_ui_type_name => null
);
end;
/
The failing constraint is
ALTER TABLE APEX_180200.WWV_FLOWS ADD (
CONSTRAINT WWV_FLOWS_FK
FOREIGN KEY (SECURITY_GROUP_ID)
REFERENCES APEX_180200.WWV_FLOW_COMPANIES (PROVISIONING_COMPANY_ID)
ON DELETE CASCADE
ENABLE VALIDATE);
How to set this up right, what am I missing?
Thanks for the help.
Krisztian