Group not found

Betz_Gregory · July 25, 2012, 2:18pm

Hello all,

I am having issues trying to add watchers to most of my queues. When I try to add a user or group I receive the error message “Group not found”.

I can set watchers for 2 queues (one is the General queue) out of 9 total queues.

Also, I noticed that the 2 queues that I can set watchers has items under Roles in Group Rights while the queues that I cannot set the watchers does not.

The following error message is displayed in /var/log/httpd/error_log

[Wed Jul 25 12:05:06 2012] [warning]: DBD::Pg::st execute failed: ERROR: syntax error at or near “)”

LINE 1: …nt(main.id) FROM GroupMembers main WHERE (main.GroupId = )

                                                                 ^ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)

[Wed Jul 25 12:05:06 2012] [warning]: RT::Handle=HASH(0x7fbc4de27b10) couldn’t execute the query 'SELECT count(main.id) FROM GroupMembers main WHERE (main.GroupId = ) ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.

    DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7fbc4de27b10)', 'SELECT count(main.id) FROM GroupMembers main  WHERE (main.Gro...') called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 291

    DBIx::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 331

    RT::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1407

    DBIx::SearchBuilder::Count('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 48

    HTML::Mason::Commands::__ANON__('QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

    HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4febff68)', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

    HTML::Mason::Request::comp(undef, undef, 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /opt/rt4/local/html/Admin/Elements/EditQueueWatcherGroup line 55

    HTML::Mason::Commands::__ANON__('Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

    HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4febca88)', 'Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

    HTML::Mason::Request::comp(undef, undef, 'Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /opt/rt4/local/html/Admin/Queues/People.html line 65

    HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'Queue-AddWatcher-Principal-30', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

    HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4feaff30)', 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

    HTML::Mason::Request::comp(undef, undef, undef, 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 955

    HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)', 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'UserString', '', ...) called at /opt/rt4/local/html/Admin/autohandler line 49

    HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'Queue-AddWatcher-Principal-30', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

    HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4ea48560)', 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

    HTML::Mason::Request::comp(undef, undef, undef, 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', ...) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548

    RT::Interface::Web::ShowRequestedPage('HASH(0x7fbc4feafc00)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295

    RT::Interface::Web::HandleRequest('HASH(0x7fbc4feafc00)') called at /opt/rt4/local/html/autohandler line 53

    HTML::Mason::Commands::__ANON__('UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', 'LIKE', 'GroupString', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

    HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4e16e7c0)', 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', 'LIKE', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1297

    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

    HTML::Mason::Request::comp(undef, undef, undef, 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 481

    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 481

    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 433

    HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)') called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85

    eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85

    HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)') called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 342

    HTML::Mason::Interp::exec(undef, undef, 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', ...) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48

    eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48

    HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x7fbc4d42e258)', 'HTML::Mason::FakeApache=HASH(0x7fbc5000a380)', 'HASH(0x7fbc4fec58c0)') called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52

    HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x7fbc50014e68)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 255

    RT::Interface::Web::Handler::__ANON__('CODE(0x7fbc50014e68)') called at /usr/local/share/perl5/Plack/Util.pm line 324

    Plack::Util::__ANON__('CODE(0x7fbc4febe048)') called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 68

    Plack::Handler::Apache2::call_app('Plack::Handler::Apache2', 'Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)', 'CODE(0x7fbc4cd08338)') called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 91

    Plack::Handler::Apache2::handler('Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)') called at -e line 0

    eval {...} called at -e line 0 (/usr/local/share/perl5/Carp.pm:103)

Any help would be greatly appreciated!

Thanks,
Greg

Paul_Tomblin · July 25, 2012, 2:24pm

I’ve seen this exact thing happen when the person trying to add the
watchers didn’t have permissions to the queues in question. Rather than
handling it properly, RT sticks a null queue name into the query, which the
query doesn’t like much.On Wed, Jul 25, 2012 at 10:18 AM, Betz, Gregory gregory.betz@thesiorg.comwrote:

Hello all,****

I am having issues trying to add watchers to most of my queues. When I
try to add a user or group I receive the error message “Group not found”.

I can set watchers for 2 queues (one is the General queue) out of 9 total
queues. ****

Also, I noticed that the 2 queues that I can set watchers has items under
Roles in Group Rights while the queues that I cannot set the watchers does
not. ****

The following error message is displayed in /var/log/httpd/error_log****

======================================================================================================================================================

[Wed Jul 25 12:05:06 2012] [warning]: DBD::Pg::st execute failed: ERROR:
syntax error at or near “)”****

LINE 1: …nt(main.id) FROM GroupMembers main WHERE (main.GroupId = )****
                                                                 ^ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)****

[Wed Jul 25 12:05:06 2012] [warning]: RT::Handle=HASH(0x7fbc4de27b10)
couldn’t execute the query 'SELECT count(main.id) FROM GroupMembers main
WHERE (main.GroupId = ) ’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.****

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7fbc4de27b10)’,
‘SELECT count(main.id) FROM GroupMembers main WHERE (main.Gro…’)
called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 291****

DBIx::SearchBuilder::_DoCount(‘RT::GroupMembers=HASH(0x7fbc4febdfb8)’)
called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 331****

RT::SearchBuilder::_DoCount(‘RT::GroupMembers=HASH(0x7fbc4febdfb8)’) called
at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1407****

DBIx::SearchBuilder::Count(‘RT::GroupMembers=HASH(0x7fbc4febdfb8)’) called
at /opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 48****
    HTML::Mason::Commands::__ANON__('QueueObj',
‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4febff68)’,
‘QueueObj’, ‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1302****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, 'QueueObj',
‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/opt/rt4/local/html/Admin/Elements/EditQueueWatcherGroup line 55****
    HTML::Mason::Commands::__ANON__('Label', 'AdminCc', 'QueueObj',
‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4febca88)’,
‘Label’, ‘AdminCc’, ‘QueueObj’, ‘RT::Queue=HASH(0x7fbc4feb6a28)’,
‘Watchers’, ‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1302****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, 'Label', 'AdminCc',
‘QueueObj’, ‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/opt/rt4/local/html/Admin/Queues/People.html line 65****
    HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp',
‘LIKE’, ‘GroupOp’, ‘LIKE’, ‘GroupString’, ‘’,
‘Queue-AddWatcher-Principal-30’, …) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4feaff30)’,
‘GroupField’, ‘Name’, ‘UserOp’, ‘LIKE’, ‘GroupOp’, ‘LIKE’, ‘GroupString’,
‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302*
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, undef, 'GroupField',
‘Name’, ‘UserOp’, ‘LIKE’, ‘GroupOp’, ‘LIKE’, …) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 955****

HTML::Mason::Request::call_next(‘RT::Interface::Web::Request=HASH(0x7fbc4fa53370)’,
‘UserOp’, ‘LIKE’, ‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5,
‘UserString’, ‘’, …) called at /opt/rt4/local/html/Admin/autohandler line
49****
    HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp',
‘LIKE’, ‘GroupOp’, ‘LIKE’, ‘GroupString’, ‘’,
‘Queue-AddWatcher-Principal-30’, …) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4ea48560)’,
‘GroupField’, ‘Name’, ‘UserOp’, ‘LIKE’, ‘GroupOp’, ‘LIKE’, ‘GroupString’,
‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302*
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, undef, 'GroupField',
‘Name’, ‘UserOp’, ‘LIKE’, ‘GroupOp’, ‘LIKE’, …) called at
/opt/rt4/sbin/…/lib/RT/Interface/Web.pm line 548****
    RT::Interface::Web::ShowRequestedPage('HASH(0x7fbc4feafc00)')
called at /opt/rt4/sbin/…/lib/RT/Interface/Web.pm line 295****
    RT::Interface::Web::HandleRequest('HASH(0x7fbc4feafc00)') called
at /opt/rt4/local/html/autohandler line 53****
    HTML::Mason::Commands::__ANON__('UserOp', 'LIKE',
‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5, ‘GroupOp’, ‘LIKE’,
‘GroupString’, …) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4e16e7c0)’,
‘UserOp’, ‘LIKE’, ‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5,
‘GroupOp’, ‘LIKE’, …) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1297****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, undef, 'UserOp', 'LIKE',
‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5, …) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 481****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 481****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 433****

HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x7fbc4fa53370)’)
called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85****
    eval {...} called at
/usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85****

HTML::Mason::Request::PSGI::exec(‘RT::Interface::Web::Request=HASH(0x7fbc4fa53370)’)
called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 342****
    HTML::Mason::Interp::exec(undef, undef, 'UserOp', 'LIKE',
‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5, ‘GroupOp’, …) called
at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48****
    eval {...} called at
/usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48****

HTML::Mason::PSGIHandler::invoke_mason(‘HTML::Mason::PSGIHandler::Streamy=HASH(0x7fbc4d42e258)’,
‘HTML::Mason::FakeApache=HASH(0x7fbc5000a380)’, ‘HASH(0x7fbc4fec58c0)’)
called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52

HTML::Mason::PSGIHandler::Streamy::ANON(‘CODE(0x7fbc50014e68)’) called
at /opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm line 255****
    RT::Interface::Web::Handler::__ANON__('CODE(0x7fbc50014e68)')
called at /usr/local/share/perl5/Plack/Util.pm line 324****
    Plack::Util::__ANON__('CODE(0x7fbc4febe048)') called at
/usr/local/share/perl5/Plack/Handler/Apache2.pm line 68****
    Plack::Handler::Apache2::call_app('Plack::Handler::Apache2',
‘Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)’, ‘CODE(0x7fbc4cd08338)’)
called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 91****

Plack::Handler::Apache2::handler(‘Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)’)
called at -e line 0****
    eval {...} called at -e line 0 (/usr/local/share/perl5/Carp.pm:103)
======================================================================================================================================================

Any help would be greatly appreciated!****

Thanks,****

Greg****

http://www.linkedin.com/in/paultomblin
http://careers.stackoverflow.com/ptomblin

Betz_Gregory · July 25, 2012, 2:28pm

Hey Paul,

Thanks for the quick response.

I use the root account when attempting to put watchers on the queues, so I don’t think this is the issue

Thanks,
GregFrom: ptomblin@gmail.com [mailto:ptomblin@gmail.com] On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 10:25 AM
To: Betz, Gregory
Cc: rt-users@lists.bestpractical.com
Subject: EXTERNAL: Re: [rt-users] Group not found

I’ve seen this exact thing happen when the person trying to add the watchers didn’t have permissions to the queues in question. Rather than handling it properly, RT sticks a null queue name into the query, which the query doesn’t like much.

Betz_Gregory · July 25, 2012, 5:13pm

Also, I noticed the following message after the aforementioned warning message in the log.

Use of uninitialized value in numeric eq (==) at /opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 3. (/opt/rt4/local/html/Admin/Elements/EditQueueWatchers:3)

Thanks,
GregFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Betz, Gregory
Sent: Wednesday, July 25, 2012 10:29 AM
To: Paul Tomblin
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] EXTERNAL: Re: Group not found

Hey Paul,

Thanks for the quick response.

I use the root account when attempting to put watchers on the queues, so I don’t think this is the issue

Thanks,
Greg

From: ptomblin@gmail.com mailto:ptomblin@gmail.com [mailto:ptomblin@gmail.com]mailto:[mailto:ptomblin@gmail.com] On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 10:25 AM
To: Betz, Gregory
Cc: rt-users@lists.bestpractical.com mailto:rt-users@lists.bestpractical.com
Subject: EXTERNAL: Re: [rt-users] Group not found

I’ve seen this exact thing happen when the person trying to add the watchers didn’t have permissions to the queues in question. Rather than handling it properly, RT sticks a null queue name into the query, which the query doesn’t like much.

Paul_Tomblin · July 25, 2012, 5:18pm

That’s just a consequence of the other error:
%if ($Members->Count == 0 ) {

$Members->Count returns an undef because of the error, which leads to the
second error.On Wed, Jul 25, 2012 at 1:13 PM, Betz, Gregory gregory.betz@thesiorg.comwrote:

Also, I noticed the following message after the aforementioned warning
message in the log.****

Use of uninitialized value in numeric eq (==) at
/opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 3.
(/opt/rt4/local/html/Admin/Elements/EditQueueWatchers:3) ****

Thanks,****

Greg****

From: rt-users-bounces@lists.bestpractical.com [mailto:
rt-users-bounces@lists.bestpractical.com] On Behalf Of Betz, Gregory
Sent: Wednesday, July 25, 2012 10:29 AM
To: Paul Tomblin
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] EXTERNAL: Re: Group not found**

Hey Paul, ****

Thanks for the quick response. ****

I use the root account when attempting to put watchers on the queues, so I
don’t think this is the issue****

Thanks,****

Greg****

From: ptomblin@gmail.com [mailto:ptomblin@gmail.com] On Behalf Of Paul
Tomblin
Sent: Wednesday, July 25, 2012 10:25 AM
To: Betz, Gregory
Cc: rt-users@lists.bestpractical.com
Subject: EXTERNAL: Re: [rt-users] Group not found**

I’ve seen this exact thing happen when the person trying to add the
watchers didn’t have permissions to the queues in question. Rather than
handling it properly, RT sticks a null queue name into the query, which the
query doesn’t like much.****

On Wed, Jul 25, 2012 at 10:18 AM, Betz, Gregory gregory.betz@thesiorg.com
wrote:****

Hello all,****

I am having issues trying to add watchers to most of my queues. When I
try to add a user or group I receive the error message “Group not found”.

I can set watchers for 2 queues (one is the General queue) out of 9 total
queues. ****

Also, I noticed that the 2 queues that I can set watchers has items under
Roles in Group Rights while the queues that I cannot set the watchers does
not. ****

The following error message is displayed in /var/log/httpd/error_log****

======================================================================================================================================================

[Wed Jul 25 12:05:06 2012] [warning]: DBD::Pg::st execute failed: ERROR:
syntax error at or near “)”****

LINE 1: …nt(main.id) FROM GroupMembers main WHERE (main.GroupId = )****
                                                                 ^ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)****

[Wed Jul 25 12:05:06 2012] [warning]: RT::Handle=HASH(0x7fbc4de27b10)
couldn’t execute the query 'SELECT count(main.id) FROM GroupMembers main
WHERE (main.GroupId = ) ’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.****

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x7fbc4de27b10)’,
‘SELECT count(main.id) FROM GroupMembers main WHERE (main.Gro…’)
called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 291****

DBIx::SearchBuilder::_DoCount(‘RT::GroupMembers=HASH(0x7fbc4febdfb8)’)
called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 331****

RT::SearchBuilder::_DoCount(‘RT::GroupMembers=HASH(0x7fbc4febdfb8)’) called
at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1407****

DBIx::SearchBuilder::Count(‘RT::GroupMembers=HASH(0x7fbc4febdfb8)’) called
at /opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 48****
    HTML::Mason::Commands::__ANON__('QueueObj',
‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4febff68)’,
‘QueueObj’, ‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1302****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, 'QueueObj',
‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/opt/rt4/local/html/Admin/Elements/EditQueueWatcherGroup line 55****
    HTML::Mason::Commands::__ANON__('Label', 'AdminCc', 'QueueObj',
‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4febca88)’,
‘Label’, ‘AdminCc’, ‘QueueObj’, ‘RT::Queue=HASH(0x7fbc4feb6a28)’,
‘Watchers’, ‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1302****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, 'Label', 'AdminCc',
‘QueueObj’, ‘RT::Queue=HASH(0x7fbc4feb6a28)’, ‘Watchers’,
‘RT::Group=HASH(0x7fbc5000f3f0)’) called at
/opt/rt4/local/html/Admin/Queues/People.html line 65****
    HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp',
‘LIKE’, ‘GroupOp’, ‘LIKE’, ‘GroupString’, ‘’,
‘Queue-AddWatcher-Principal-30’, …) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4feaff30)’,
‘GroupField’, ‘Name’, ‘UserOp’, ‘LIKE’, ‘GroupOp’, ‘LIKE’, ‘GroupString’,
‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302*
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, undef, 'GroupField',
‘Name’, ‘UserOp’, ‘LIKE’, ‘GroupOp’, ‘LIKE’, …) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 955****

HTML::Mason::Request::call_next(‘RT::Interface::Web::Request=HASH(0x7fbc4fa53370)’,
‘UserOp’, ‘LIKE’, ‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5,
‘UserString’, ‘’, …) called at /opt/rt4/local/html/Admin/autohandler line
49****
    HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp',
‘LIKE’, ‘GroupOp’, ‘LIKE’, ‘GroupString’, ‘’,
‘Queue-AddWatcher-Principal-30’, …) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4ea48560)’,
‘GroupField’, ‘Name’, ‘UserOp’, ‘LIKE’, ‘GroupOp’, ‘LIKE’, ‘GroupString’,
‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302*
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, undef, 'GroupField',
‘Name’, ‘UserOp’, ‘LIKE’, ‘GroupOp’, ‘LIKE’, …) called at
/opt/rt4/sbin/…/lib/RT/Interface/Web.pm line 548****
    RT::Interface::Web::ShowRequestedPage('HASH(0x7fbc4feafc00)')
called at /opt/rt4/sbin/…/lib/RT/Interface/Web.pm line 295****
    RT::Interface::Web::HandleRequest('HASH(0x7fbc4feafc00)') called
at /opt/rt4/local/html/autohandler line 53****
    HTML::Mason::Commands::__ANON__('UserOp', 'LIKE',
‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5, ‘GroupOp’, ‘LIKE’,
‘GroupString’, …) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135****

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x7fbc4e16e7c0)’,
‘UserOp’, ‘LIKE’, ‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5,
‘GroupOp’, ‘LIKE’, …) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1297****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 1292****
    HTML::Mason::Request::comp(undef, undef, undef, 'UserOp', 'LIKE',
‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5, …) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 481****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 481****
    eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
line 433****

HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x7fbc4fa53370)’)
called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85****
    eval {...} called at
/usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85****

HTML::Mason::Request::PSGI::exec(‘RT::Interface::Web::Request=HASH(0x7fbc4fa53370)’)
called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 342****
    HTML::Mason::Interp::exec(undef, undef, 'UserOp', 'LIKE',
‘Queue-AddWatcher-Principal-30’, ‘AdminCc’, ‘id’, 5, ‘GroupOp’, …) called
at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48****
    eval {...} called at
/usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48****

HTML::Mason::PSGIHandler::invoke_mason(‘HTML::Mason::PSGIHandler::Streamy=HASH(0x7fbc4d42e258)’,
‘HTML::Mason::FakeApache=HASH(0x7fbc5000a380)’, ‘HASH(0x7fbc4fec58c0)’)
called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52

HTML::Mason::PSGIHandler::Streamy::ANON(‘CODE(0x7fbc50014e68)’) called
at /opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm line 255****
    RT::Interface::Web::Handler::__ANON__('CODE(0x7fbc50014e68)')
called at /usr/local/share/perl5/Plack/Util.pm line 324****
    Plack::Util::__ANON__('CODE(0x7fbc4febe048)') called at
/usr/local/share/perl5/Plack/Handler/Apache2.pm line 68****
    Plack::Handler::Apache2::call_app('Plack::Handler::Apache2',
‘Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)’, ‘CODE(0x7fbc4cd08338)’)
called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 91****

Plack::Handler::Apache2::handler(‘Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)’)
called at -e line 0****
    eval {...} called at -e line 0 (/usr/local/share/perl5/Carp.pm:103)
======================================================================================================================================================

Any help would be greatly appreciated!****

Thanks,****

Greg****

–
http://www.linkedin.com/in/paultomblin
http://careers.stackoverflow.com/ptomblin****

http://www.linkedin.com/in/paultomblin
http://careers.stackoverflow.com/ptomblin

Betz_Gregory · July 30, 2012, 1:59pm

I came back to this issue this morning and am still at a loss.

I created a group Admin and added the root user to it. I added full rights for the Admin group and specifically for the user ‘root’ for one of the queues with the issue and I am still receiving the same error.

I failed to mention that I converted an old MySQL DB from another RT server to the current RT server with PostgreSQL DB. I only imported specific fields from the old database to the new database but everything else appears to be functioning correctly.

The tables (along with their sequences) I imported were: attachments, cachedgroupmembers, groupmembers, groups, principals, tickets, topics, transactions, users.

Could this have been an issue?

Thanks,
GregFrom: ptomblin@gmail.com [mailto:ptomblin@gmail.com] On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 1:19 PM
To: Betz, Gregory
Cc: rt-users@lists.bestpractical.com
Subject: EXTERNAL: Re: [rt-users] EXTERNAL: Re: Group not found

That’s just a consequence of the other error:
%if ($Members->Count == 0 ) {

$Members->Count returns an undef because of the error, which leads to the second error.

Betz_Gregory · July 30, 2012, 2:47pm

To add to this, I’m positive that it is conflict with the old root account.

I just created another queue and the Roles section is there and watchers can be added.

Is there somewhere in the db that I can fix this or would it be best to just recreate the queues?

Thanks,
GregFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Betz, Gregory
Sent: Monday, July 30, 2012 10:00 AM
To: Paul Tomblin
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] EXTERNAL: Re: EXTERNAL: Re: Group not found

I came back to this issue this morning and am still at a loss.

I created a group Admin and added the root user to it. I added full rights for the Admin group and specifically for the user ‘root’ for one of the queues with the issue and I am still receiving the same error.

I failed to mention that I converted an old MySQL DB from another RT server to the current RT server with PostgreSQL DB. I only imported specific fields from the old database to the new database but everything else appears to be functioning correctly.

The tables (along with their sequences) I imported were: attachments, cachedgroupmembers, groupmembers, groups, principals, tickets, topics, transactions, users.

Could this have been an issue?

Thanks,
Greg

From: ptomblin@gmail.com mailto:ptomblin@gmail.com [mailto:ptomblin@gmail.com]mailto:[mailto:ptomblin@gmail.com] On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 1:19 PM
To: Betz, Gregory
Cc: rt-users@lists.bestpractical.com mailto:rt-users@lists.bestpractical.com
Subject: EXTERNAL: Re: [rt-users] EXTERNAL: Re: Group not found

That’s just a consequence of the other error:
%if ($Members->Count == 0 ) {

$Members->Count returns an undef because of the error, which leads to the second error.