Error when trying to remove a Member of a group

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

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

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? :frowning:

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

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? :frowning:

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

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

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,

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” :frowning:

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

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