2 Replies Latest reply: Apr 16, 2014 1:10 PM by user1364530 RSS

    Error Messages when importing workspace to QA database

    user1364530

      Hi,

      We are importing workspace sql into our QA environment using sql developer.  We are on ORacle APEX version 4.2.1.  When we perform the import we are receiving the following error:

       

      WORKSPACE 2171032608309747

      Creating workspace SUPPXDEV...

      Rollback

       

      Error starting at line : 47 in
      command -

      begin

      wwv_flow_fnd_user_api.create_company(

      p_id =>2171116505309806

      ,p_provisioning_company_id =>2171032608309747

      ,p_short_name => 'SUPPXDEV'

      ,p_display_name => 'SUPPXDEV'

      ,p_first_schema_provisioned=> 'ZEUS_DB'

      ,p_company_schemas =>'ZEUS_DB'

      ,p_account_status =>'ASSIGNED'

      ,p_allow_plsql_editing => 'Y'

      ,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_to_be_purged_yn => 'Y'

      ,p_allow_restful_services_yn=> 'Y'

      ,p_source_identifier => 'SUPPXDEV'

      ,p_path_prefix =>  'SUPPXDEV'

        ,p_workspace_image => wwv_flow_api.g_varchar2_table

      );

      end;

      Error report -

      ORA-06502: PL/SQL: numeric or value error

      ORA-06512: at  "SYS.OWA_UTIL", line 356

      ORA-06512: at "SYS.HTP", line 1368

      ORA-06512: at "SYS.HTP", line 1443

      ORA-06512: at "SYS.HTP", line 1735

      ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 154

      ORA-20987: User  requires ADMIN privilege to perform this operation.

      ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 613

      ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 903

      ORA-06512: at "APEX_040200.WWV_FLOW_FND_USER_API", line 207

      ORA-06512: at "APEX_040200.WWV_FLOW_FND_USER_API", line 1373

      ORA-06512: at line 2

      06502. 00000 -  "PL/SQL: numeric or value error%s"

      I would appreciate your guidance with this issue.

      Thanks

      Don