Error when trying to remove a Member of a group

Emmanuel_Lacour · November 16, 2007, 10:12am

I try to empty a group from his members which are mixed users/groups,
and I get those errors for many of those members groups:

[Fri Nov 16 09:50:41 2007] [warning]: User not loaded. (/opt/rt/lib/RT/User_Overlay.pm:1792)
[Fri Nov 16 09:50:41 2007] [warning]: Unable to revoke delegated rights
for principal 22525 (/opt/rt/lib/RT/GroupMember_Overlay.pm:334)

and this member group cannot be removed

Many thanks for any idea/hint to solve this?

Tested with RT 3.4.5 and 3.6.3 on the same database (Oracle 9i).

Easter-eggs Sp?cialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - M?tro Gait?
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

Emmanuel_Lacour · November 16, 2007, 10:50am

I try to empty a group from his members which are mixed users/groups,
and I get those errors for many of those members groups:

[Fri Nov 16 09:50:41 2007] [warning]: User not loaded. (/opt/rt/lib/RT/User_Overlay.pm:1792)
[Fri Nov 16 09:50:41 2007] [warning]: Unable to revoke delegated rights
for principal 22525 (/opt/rt/lib/RT/GroupMember_Overlay.pm:334)

It seems I have a problem with the Principals table:

SQL> select * from principals where id=22525;

ID PRINCIPALTYPE OBJECTID DISABLED

22525 Group 22525 0

SQL> select Name from groups where id=22525;

NAME

There is no group with this Id!!!

Any idea why my database has this problems?

Easter-eggs Sp?cialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - M?tro Gait?
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

Emmanuel_Lacour · November 16, 2007, 10:59am

It seems I have a problem with the Principals table:

SQL> select * from principals where id=22525;

ID PRINCIPALTYPE OBJECTID DISABLED

22525 Group 22525 0

SQL> select Name from groups where id=22525;

NAME

There is no group with this Id!!!

Any idea why my database has this problems?

Sorry … I didn’t know the true content of Groups table, there is an
entry for this Principal:

ID 22525
DOMAIN RT::Ticket-Role
TYPE AdminCc
INSTANCE 3196

Easter-eggs Sp?cialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - M?tro Gait?
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

Kenn_Crocker · November 16, 2007, 6:02pm

Emmanuel,

There could be many reason why you can't remove users from a group.

What are your privileges for that group. What are your privileges in
changing the privileges of those users?

Kenn
LBNLOn 11/16/2007 2:12 AM, Emmanuel Lacour wrote:

I try to empty a group from his members which are mixed users/groups,
and I get those errors for many of those members groups:

[Fri Nov 16 09:50:41 2007] [warning]: User not loaded. (/opt/rt/lib/RT/User_Overlay.pm:1792)
[Fri Nov 16 09:50:41 2007] [warning]: Unable to revoke delegated rights
for principal 22525 (/opt/rt/lib/RT/GroupMember_Overlay.pm:334)

and this member group cannot be removed

Many thanks for any idea/hint to solve this?

Tested with RT 3.4.5 and 3.6.3 on the same database (Oracle 9i).

Emmanuel_Lacour · November 17, 2007, 6:47am

Emmanuel,

There could be many reason why you can’t remove users from a group.
What are your privileges for that group. What are your privileges in
changing the privileges of those users?

Hi, thanks for having a look at my problem:)

So I will explain a littre bit more:

I have a group “group1”

This group as different kind of members, some users and some other
groups.

All the actions that I tried are made with a “SuperUser” account.

I was able to remove some members of type “group”, but some others gave
me the error in my first message.

I’m unable to remove members of type User for this group, RT said “no
such member”

Emmanuel_Lacour · November 19, 2007, 5:32pm

I try to empty a group from his members which are mixed users/groups,
and I get those errors for many of those members groups:

i.e. group “groupA” as for example the following members:

user1
user2
…
group1
group2
…

[Fri Nov 16 09:50:41 2007] [warning]: User not loaded. (/opt/rt/lib/RT/User_Overlay.pm:1792)
[Fri Nov 16 09:50:41 2007] [warning]: Unable to revoke delegated rights
for principal 22525 (/opt/rt/lib/RT/GroupMember_Overlay.pm:334)

and this member group cannot be removed

Many thanks for any idea/hint to solve this?

Tested with RT 3.4.5 and 3.6.3 on the same database (Oracle 9i).

Here is more informations:

If I disable the following line in
/opt/rt/lib/RT/GroupMember_Overlay.pm, function “Delete”, line 332:

$err = $self->MemberObj->_CleanupInvalidDelegations(InsideTransaction => 1);

I can delete those member groups (group1, group2, …).

If it could help understanding the problem, here is a dumper of $self
then @_ in /opt/rt/lib/RT/User_Overlay.pm function
_CleanupInvalidDelegations:

[Mon Nov 19 17:15:42 2007] [warning]: Dumper1: $VAR1 = bless( {
‘_Class’ => ‘RT::User’,
‘original_user’ => undef,
‘_SB_Record_Primary_RecordCache_key’ => undef,
‘user’ => bless( {
‘_Class’ => ‘RT::CurrentUser’,
‘LangHandle’ => bless( {}, ‘RT::I18N::en’ ),
‘_SB_Record_Primary_RecordCache_key’ => ‘id=284971’,
‘table’ => ‘Users’,
‘values’ => {
‘creator’ => ‘12’,
‘comments’ => undef,
‘state’ => undef,
‘webencoding’ => undef,
‘realname’ => ‘RT Connect’,
‘password’ => ‘NO-PASSWORD’,
‘authsystem’ => undef,
‘homephone’ => undef,

                                              'id' => '284971',
                                              'timezone' => undef,
                                              'lang' => 'en',
                                              'name' => 'rtconnect',
                                              'contactinfosystem' => undef,
                                              'zip' => undef,
                                              'emailencoding' => undef,
                                              'lastupdated' => '2007-10-18 17:50:41',
                                              'signature' => undef,
                                              'externalauthid' => undef,
                                              'address1' => undef,
                                              'workphone' => undef,
                                              'emailaddress' => 'rtconnect@foo.bar',
                                              'freeformcontactinfo' => undef,
                                              'city' => undef,
                                              'gecos' => 'rtconnect',
                                              'organization' => 'Foo',
                                              'country' => undef,
                                              'mobilephone' => undef,
                                              'nickname' => 'rtconnect',
                                              'externalcontactinfoid' => undef,
                                              'address2' => undef,
                                              'created' => '2007-10-18 15:34:59',
                                              'pgpkey' => undef,
                                              'pagerphone' => undef,
                                              'lastupdatedby' => '284971'
                                            },
                                'fetched' => {
                                               'creator' => 1,
                                               'comments' => 1,
                                               'state' => 1,
                                               'webencoding' => 1,
                                               'realname' => 1,
                                               'password' => 1,
                                               'authsystem' => 1,
                                               'homephone' => 1,
                                               'id' => 1,
                                               'timezone' => 1,
                                               'lang' => 1,
                                               'name' => 1,
                                               'contactinfosystem' => 1,
                                               'zip' => 1,
                                               'emailencoding' => 1,
                                               'signature' => 1,
                                               'lastupdated' => 1,
                                               'externalauthid' => 1,
                                               'address1' => 1,
                                               'workphone' => 1,
                                               'emailaddress' => 1,
                                               'freeformcontactinfo' => 1,
                                               'city' => 1,
                                               'gecos' => 1,
                                               'organization' => 1,
                                               'country' => 1,
                                               'mobilephone' => 1,
                                               'nickname' => 1,
                                               'externalcontactinfoid' => 1,
                                               'address2' => 1,
                                               'created' => 1,
                                               'pgpkey' => 1,
                                               'lastupdatedby' => 1,
                                               'pagerphone' => 1
                                             }
                              }, 'RT::CurrentUser' ),
             'table' => 'Users',
             'values' => {},
             'fetched' => {}
           }, 'RT::User' ); (/opt/rt/lib/RT/User_Overlay.pm:1791)

[Mon Nov 19 17:15:42 2007] [warning]: Dumper2: $VAR1 = ‘InsideTransaction’;
$VAR2 = 1;
$VAR3 = ‘Object’;
$VAR4 = undef; (/opt/rt/lib/RT/User_Overlay.pm:1792)

Thanks for any help