Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Solutions › Topic Id: 2979 | Permalink

Illegal security group id value for this schema - g_security_group_id must be set

Topic ID: 2979
Created By: 2008-JAN-29 19:33:31 [Vitaliy]
Updated By: 2008-JAN-29 19:33:31 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
8848
2008-JAN-29 19:33:31
Moderator
 
 
Registered On: Mar 2006
Total Posts: 267
ISSUE
You are trying to import pre-packaged APEX application that you have downloaded from:
   Oracle Application Express - Packaged Applications

You've extracted the source code sql script, connected as the owner/admin 
of your workspace and received the following error:

   SQL> @YouTube_Integration_installer.sql
   APPLICATION 114 - YouTube Integration
   Set Credentials...
   Illegal security group id value for this schema.
   Check Compatibility...
   API Last Extended:20070525
   Your Current Version:20070525
   This import is compatible with version: 20070108
   COMPATIBLE (You should be able to run this import without issues.)
   Set Application ID...
   begin
   *
   ERROR at line 1:
   ORA-20001: Package variable g_security_group_id must be set.
   ORA-06512: at "FLOWS_030000.WWV_FLOW_API", line 46
   ORA-06512: at "FLOWS_030000.WWV_FLOW_API", line 238
   ORA-06512: at line 4
SOLUTION
Change g_security_group_id to a valid value for the schema name you are 
importing the application into:

   CHANGE:
      wwv_flow_api.set_security_group_id(p_security_group_id=>1150504199010437);
   TO:
      wwv_flow_api.set_security_group_id(p_security_group_id=>989808322597530);
   WHERE:
      989808322597530 can be found using the following procedure:
   
      SQL> select to_char(security_group_id,'99999999999999999999999')
        2  from FLOWS_030000.WWV_FLOW_FND_USER
        3  where user_name = 'DBA_APEX';
      
      TO_CHAR(SECURITY_GROUP_I
      ------------------------
        989808322597530
      
      NOTE: substitute DBA_APEX with your own user_name that you will
            use to install this application as.

There's one more change to make on the wwv_flow_api.create_flow call (see below):   

   wwv_flow_api.create_flow(
     p_id    => 114,
     p_display_id=> 114,
     p_owner => 'EBA',
                ^^^^^
                change to 'DBA_APEX' (just an example use your own username)

After all said and done it worked:

   Connected to:
   Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
   With the Partitioning, OLAP and Data Mining options
   
   SQL> spool YouTube_Integration_installer.sql.log
   SQL> @YouTube_Integration_installer.sql
   APPLICATION 114 - YouTube Integration
   Set Credentials...
   Check Compatibility...
   API Last Extended:20070525
   Your Current Version:20070525
   This import is compatible with version: 20070108
   COMPATIBLE (You should be able to run this import without issues.)
   Set Application ID...
   ...authorization schemes
   ...navigation bar entries
   ...application processes
   ...application items
   ...application level computations
   ...Application Tabs
   ...Application Parent Tabs
   ...Shared Lists of values
   ...Application Trees
   ...page groups
   ...comments: requires application express 2.2 or higher
   ...PAGE 1: Home
   ...PAGE 2: Music Videos
   ...PAGE 5: Comedy Videos
   ...PAGE 6: Video Details
   ...PAGE 7: Profile
   ...PAGE 8: User Videos
   ...PAGE 101: Login
   ...lists
   ...breadcrumbs
   ...page templates for application: 114
   ......Page template 46390917053647655
   ......Page template 46391027945647658
   ......Page template 46391128778647658
   ......Page template 46391208728647658
   ......Page template 46391310124647658
   ......Page template 46391420786647658
   ......Page template 46391503773647658
   ......Page template 46391618379647660
   ......Page template 46391709208647660
   ...button templates
   ......Button Template 46391820099647660
   ......Button Template 46391918727647661
   ......Button Template 46392029996647661
   ......Button Template 46392114927647661
   ...region templates
   ......region template 3827731326553485
   ......region template 3831915344570426
   ......region template 46392208476647661
   ......region template 46392302207647663
   ......region template 46392407599647663
   ......region template 46392508734647663
   ......region template 46392622572647663
   ......region template 46392714331647663
   ......region template 46392820301647663
   ......region template 46392903488647663
   ......region template 46393025614647663
   ......region template 46393128956647663
   ......region template 46393229853647664
   ......region template 46393324966647664
   ......region template 46393419326647664
   ......region template 46393519033647664
   ......region template 46393617459647664
   ......region template 46393719206647664
   ......region template 46393825627647664
   ......region template 46393920522647664
   ......region template 46394022841647664
   ......region template 46394124615647665
   ......region template 46394210786647665
   ...List Templates
   ......list template 46394330486647665
   ......list template 46394412621647666
   ......list template 46394513899647667
   ......list template 46394604969647667
   ......list template 46394704574647667
   ......list template 46394802970647667
   ......list template 46394906909647668
   ......list template 46395031131647668
   ......list template 46395106123647668
   ......list template 46395225913647668
   ......list template 46395323292647668
   ......list template 46395430642647668
   ......list template 46395518421647669
   ......list template 46395603786647669
   ......list template 46395717289647669
   ...report templates
   ......report template 46395822202647669
   ......report template 46395929430647671
   ......report template 46396005966647671
   ......report template 46396118926647671
   ......report template 46396226052647672
   ......report template 46396331566647672
   ......report template 46396402120647672
   ...label templates
   ......label template 46396501359647672
   ......label template 46396622824647673
   ......label template 46396721559647673
   ......label template 46396812052647673
   ......label template 46396926293647673
   ...breadcrumb templates
   ......template 46397003328647673
   ......template 46397103436647674
   ...popup list of values templates
   ......template 46397821213647677
   ...calendar templates
   ......template 46397228551647674
   ......template 46397418146647676
   ......template 46397623497647676
   ...application themes
   ......theme 46397910742647677
   ...build options used by application 114
   ...messages used by application: 114
   ...Language Maps for Application 114
   ...Shortcuts
   ...web services (9iR2 or better)
   ...shared queries
   ...report layouts
   ...authentication schemes
   ......scheme 46398003439647684
   ......scheme 46398130128647684
   ......scheme 46398206070647684
   ...application deployment
   ...application install scripts
   ...application deployment checks
   ...application deployment build options
   ...done
   SQL> spool off
   SQL>