Importing a page from different App and Workspace - ORA-00001: unique constraint (APEX_050100.WWV_FL

Igor Sala

Hi folks,

I'm trying to import a page from different App and Workspace but is raising an error:

• ORA-00001: unique constraint (APEX_050100.WWV_FLOW_PAGE_PLUGS_PK) violated

The command which I'm using is:

begin

    apex_application_install.set_workspace('PRODUCTION');

    apex_application_install.set_application_id(100);

   -- apex_application_install.generate_offset;

    apex_application_install.set_application_alias('APP_PRODUCTION');

end;

/

@/Users/UserX/Documents/Scripts/Apex/Pages/page_7777.sql

Could someone help me? I've been trying to find something in Google and Oracle Forum, but no success.

* Bonus: I would like to read your suggestions about manage Develop and Production environment, dev teams and submit the changes to Production environment.

Thanks.

Scott Wesley

This may be related, so try disable any JET regions and see if it replicates

https://storm-petrel.com/apex-error-code-apex-error-internal-request-plugin/

Igor Sala

Unfortunately or not it's a different problem, because I'm trying to import a single page, with one region without anything special. But thank you!

Pierre Yotti

Try to create a new Application with one Page and try to import it. Please confirm us if it works successfully

Igor Sala

Hi Alli, thank you for your awnser.

I created a new application but didn't work...

The command:

begin

    apex_application_install.set_workspace('PRODUCTION');

    apex_application_install.set_application_id(999);

   -- apex_application_install.generate_offset;

    apex_application_install.set_application_alias('IMPORT_TEST');

end;

/

@/Users/igor_sala/Documents/Natcorp/Scripts/APEX_Apps/Natcorp/f290_page_7777.sql

And the result:

Error starting at line : 44 File @ /Users/UserX/Documents/Scripts/Apex/Pages/f290_page_7777.sql

In command -

begin

wwv_flow_api.create_page(

p_id=>7777

,p_user_interface_id=>wwv_flow_api.id(9577698375291278781)

,p_name=>'Teste'

,p_page_mode=>'NORMAL'

,p_step_title=>'Teste'

,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS'

,p_first_item=>'NO_FIRST_ITEM'

,p_autocomplete_on_off=>'OFF'

,p_page_template_options=>'#DEFAULT#'

,p_dialog_chained=>'Y'

,p_overwrite_navigation_list=>'N'

,p_page_is_public_y_n=>'N'

,p_cache_mode=>'NOCACHE'

,p_last_updated_by=>'IGOR'

,p_last_upd_yyyymmddhh24miss=>'20181114141004'

);

wwv_flow_api.create_page_plug(

p_id=>wwv_flow_api.id(8440754902023618)

,p_plug_name=>'Block'

,p_region_template_options=>'#DEFAULT#:t-Region--scrollBody'

,p_plug_template=>wwv_flow_api.id(9577672378453278687)

,p_plug_display_sequence=>10

,p_include_in_reg_disp_sel_yn=>'Y'

,p_plug_display_point=>'BODY'

,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'

,p_attribute_01=>'N'

,p_attribute_02=>'HTML'

);

end;

Error report -

ORA-00001: unique constraint (APEX_050100.WWV_FLOW_PAGE_PLUGS_PK) violated

ORA-06512: at "APEX_050100.WWV_FLOW_API", line 12137

ORA-06512: at "APEX_050100.WWV_FLOW_API", line 12595

ORA-06512: at line 19

00001. 00000 -  "unique constraint (%s.%s) violated"

*Cause:    An UPDATE or INSERT statement attempted to insert a duplicate key.

           For Trusted Oracle configured in DBMS MAC mode, you may see

           this message if a duplicate entry exists at a different level.

*Action:   Either remove the unique restriction or do not insert the key.

Pierre Yotti

Take a look here. That is what you need

How to Import Page from another instance/workspace

Importing APEX pages and components | ApexNinjas

https://matthiashoys.wordpress.com/tag/exportimport-single-page/

https://stackoverflow.com/questions/16667140/apex-4-0-how-to-copy-page-from-one-application-to-another-application-in-apex

Elleuch Amin

choose (Reuse Application ID XXX From Export File) when you install your database application and click INSTALL APPLICATION

Caleb Amarfio

Facing the same issue, followed all the suggestions above. Its still not working.