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
|
||||
|
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>