Unable to create a group

Philip Greenspun's Homepage : Philip Greenspun's Homepage Discussion Forums : 6916 : One Thread
Notify me of new responses
Trying to create the Uber Users group, and got the following error page:

Tcl script failed


Database operation "1row" failed (exception ORA,
"ora8.c:903:ora_exec: error in `OCIStmtExecute ()': ORA-06575: Package
or function SYSTEM_ADMINISTRATOR_GROUP_ID is in an invalid state

SQL: select count(*)
from user_group_map ugm
where ugm.user_id = 1
and ugm.group_id = system_administrator_group_id")
    while executing
"ns_db 1row $db $sql"
    invoked from within
"set selection [ns_db 1row $db $sql]..."
    (procedure "database_to_tcl_string" line 3)
    invoked from within
"database_to_tcl_string $db "select count(*)
from user_group_map ugm
where ugm.user_id = $user_id
and ugm.group_id = system_administrator_group_id""
    invoked from within
"set n_rows [database_to_tcl_string $db "select count(*)
from user_group_map ugm
where ugm.user_id = $user_id
and ugm.group_id = system_administrator_g ..."
    (procedure "ad_administrator_p" line 5)
    invoked from within
"ad_administrator_p $db $user_id"
    invoked from within
"if { [ad_administrator_p $db $user_id] || ([database_to_tcl_string
$db "select approval_policy from user_group_types where group_type =
'$QQgroup_type ..."
    (file "/web/student36/www/ug/group-new-3.tcl" line 53)
    invoked from within
"source $script"
    invoked from within
"if ![file exists $script] {
                ns_returnnotfound $conn
        } else {
                source $script
        }"
    (procedure "ns_sourceproc" line 3)
    invoked from within
"ns_sourceproc cns76 {}"

For further assistance, contact the server administrator.

-- Richard Tibbetts, September 27, 1999

Answers

More about: Unable to create a group

I get the same thing.

Jin said:

>The administration group type should have been created by the data

>model loading scripts (check out community-core.sql, look for "insert

>into user_group_types...").

However, I looked there and there is no such line. I.e. the "administration" group type does not exist at all.

There is something wrong---don't know what though, and I am eager to find out in lab.

-- Hristo Bojinov, September 28, 1999


I had this problem too. The cause was that I was missing the table administration_info. Don't ask me how, but I was.

I went in the file www/doc/sql/user-groups.sql, copied the declaration of administration_info into sqlplus, and created the table.

This solved the problem.

-- Michael Harder, September 28, 1999