In RT 5.0.4 with the MergeUsers extension active, the Owner search in the Assets Simple Search is mapped to the Email address of the owner but then fails to be translated to the id of the user. Here is a sample error in the logs:
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $1 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] RT::Handle=HASH(0xbdbaf88) couldn’t execute the query ‘SELECT * FROM Principals WHERE id = ?’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 635.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT * FROM Principals WHERE id = ?’, ‘ktm@rice.edu’) called at /opt/rt504/sbin/…/lib/RT/Handle.pm line 2975#012#011RT::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT * FROM Principals WHERE id = ?’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1226#012#011DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0xd70a6a0)’, ‘SELECT * FROM Principals WHERE id = ?’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1145#012#011DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0xd70a6a0)’, ‘id’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 117#012#011DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0xd70a6a0)’, ‘id’, ‘ktm@rice.edu’) called at /opt/rt504/sbin/…/lib/RT/Record.pm line 403#012#011RT::Record::LoadByCols(‘RT::Principal=HASH(0xd70a6a0)’, ‘id’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1160#012#011DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0xd70a6a0)’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1077#012#011DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0xd70a6a0)’, ‘ktm@rice.edu’) called at /opt/rt504/local/plugins/RT-Extension-MergeUsers/lib/RT/Extension/MergeUsers.pm line 503#012#011RT::Principal::Ids(‘RT::Principal’, ‘ktm@rice.edu’) called at /opt/rt504/local/plugins/RT-Extension-MergeUsers/lib/RT/Extension/MergeUsers.pm line 574#012#011RT::Groups::WithMember(‘RT::Groups=HASH(0xd3bb548)’, ‘PrincipalId’, ‘ktm@rice.edu’, ‘Recursively’, 1) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder/Role/Roles.pm line 424#012#011RT::SearchBuilder::Role::Roles::RoleLimit(‘RT::Assets=HASH(0xd46c718)’, ‘CLASS’, ‘’, ‘VALUE’, ‘ktm@rice.edu’, ‘OPERATOR’, ‘=’, ‘CASESENSITIVE’, 0, …) called at /opt/rt504/sbin/…/lib/RT/Assets.pm line 340#012#011RT::Assets::RoleLimit(‘RT::Assets=HASH(0xd46c718)’, ‘VALUE’, ‘ktm@rice.edu’, ‘CLASS’, ‘’, ‘OPERATOR’, ‘=’, ‘CASESENSITIVE’, 0, …) called at /opt/rt504/local/plugins/RT-Extension-MergeUsers/lib/RT/Extension/MergeUsers.pm line 690#012#011RT::Principal::ANON(‘RT::Assets=HASH(0xd46c718)’, ‘TYPE’, ‘Owner’, ‘FIELD’, ‘Name’, ‘OPERATOR’, ‘=’, ‘VALUE’, ‘ktm@rice.edu’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 4623#012#011HTML::Mason::Commands::ProcessAssetsSearchArguments(‘Assets’, ‘RT::Assets=HASH(0xd46c718)’, ‘Catalog’, ‘RT::Catalog=HASH(0xd548748)’, ‘ARGSRef’, ‘HASH(0xd4632a8)’) called at /opt/rt504/share/html/Asset/Search/index.html line 57#012#011HTML::Mason::Commands::ANON(‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135#012#011HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xd42b2b8)’, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval {…} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292#012#011HTML::Mason::Request::comp(undef, undef, undef, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 751#012#011RT::Interface::Web::ShowRequestedPage(‘HASH(0xd754fe0)’) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 428#012#011RT::Interface::Web::HandleRequest(‘HASH(0xd754fe0)’) called at /opt/rt504/share/html/autohandler line 53#012#011HTML::Mason::Commands::ANON(‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Co
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $2 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] RT::Handle=HASH(0xbdbaf88) couldn’t execute the query ‘SELECT DISTINCT main.* FROM Groups main JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.GroupId = main.id ) JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) WHERE (CachedGroupMembers_2.Disabled = ?) AND (CachedGroupMembers_2.MemberId IN (?)) AND (Principals_1.Disabled = ?) AND (Principals_1.PrincipalType = ?) AND (LOWER(main.Domain) = ?) ORDER BY main.Name ASC ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 635.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT DISTINCT main.* FROM Groups main JOIN CachedGroupMembe…’, 0, ‘ktm@rice.edu’, 0, ‘Group’, ‘userdefined’) called at /opt/rt504/sbin/…/lib/RT/Handle.pm line 2975#012#011RT::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT DISTINCT main.* FROM Groups main JOIN CachedGroupMembe…’, 0, ‘ktm@rice.edu’, 0, ‘Group’, ‘userdefined’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 244#012#011DBIx::SearchBuilder::_DoSearch(‘RT::Groups=HASH(0xd3bb548)’) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder.pm line 1062#012#011RT::SearchBuilder::_DoSearch(‘RT::Groups=HASH(0xd3bb548)’) called at /opt/rt504/sbin/…/lib/RT/Groups.pm line 432#012#011RT::Groups::_DoSearch(‘RT::Groups=HASH(0xd3bb548)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 774#012#011DBIx::SearchBuilder::ItemsArrayRef(‘RT::Groups=HASH(0xd3bb548)’) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder.pm line 1047#012#011RT::SearchBuilder::ItemsArrayRef(‘RT::Groups=HASH(0xd3bb548)’) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder/Role/Roles.pm line 425#012#011RT::SearchBuilder::Role::Roles::RoleLimit(‘RT::Assets=HASH(0xd46c718)’, ‘CLASS’, ‘’, ‘VALUE’, ‘ktm@rice.edu’, ‘OPERATOR’, ‘=’, ‘CASESENSITIVE’, 0, …) called at /opt/rt504/sbin/…/lib/RT/Assets.pm line 340#012#011RT::Assets::RoleLimit(‘RT::Assets=HASH(0xd46c718)’, ‘VALUE’, ‘ktm@rice.edu’, ‘CLASS’, ‘’, ‘OPERATOR’, ‘=’, ‘CASESENSITIVE’, 0, …) called at /opt/rt504/local/plugins/RT-Extension-MergeUsers/lib/RT/Extension/MergeUsers.pm line 690#012#011RT::Principal::ANON(‘RT::Assets=HASH(0xd46c718)’, ‘TYPE’, ‘Owner’, ‘FIELD’, ‘Name’, ‘OPERATOR’, ‘=’, ‘VALUE’, ‘ktm@rice.edu’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 4623#012#011HTML::Mason::Commands::ProcessAssetsSearchArguments(‘Assets’, ‘RT::Assets=HASH(0xd46c718)’, ‘Catalog’, ‘RT::Catalog=HASH(0xd548748)’, ‘ARGSRef’, ‘HASH(0xd4632a8)’) called at /opt/rt504/share/html/Asset/Search/index.html line 57#012#011HTML::Mason::Commands::ANON(’!CF.{Room Number}‘, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135#012#011HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xd42b2b8)’, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval {…} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292#012#011HTML::Mason::Request::comp(undef, undef, undef, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 751#012#011RT::Interface::Web::ShowRequestedPage(‘HASH(0xd754fe0)’) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 428#012#011RT::Interface::Web::HandleRequest(‘HASH(0xd754fe0)’) called at /opt/rt504/share/html/autohandler line 53#012#011HTML::Mason::Commands::ANON(’!CF.{Room Number}‘, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135#012#011HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xbe33e68)’, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1297#012#011
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $18 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $18 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $18 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $18 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $18 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
root@rt1a:/opt/rt5>
root@rt1a:/opt/rt5> grep ‘Sep 20 13:32:20’ /var/log/rt
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $1 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] RT::Handle=HASH(0xbdbaf88) couldn’t execute the query ‘SELECT * FROM Principals WHERE id = ?’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 635.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT * FROM Principals WHERE id = ?’, ‘ktm@rice.edu’) called at /opt/rt504/sbin/…/lib/RT/Handle.pm line 2975#012#011RT::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT * FROM Principals WHERE id = ?’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1226#012#011DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0xd70a6a0)’, ‘SELECT * FROM Principals WHERE id = ?’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1145#012#011DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0xd70a6a0)’, ‘id’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 117#012#011DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0xd70a6a0)’, ‘id’, ‘ktm@rice.edu’) called at /opt/rt504/sbin/…/lib/RT/Record.pm line 403#012#011RT::Record::LoadByCols(‘RT::Principal=HASH(0xd70a6a0)’, ‘id’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1160#012#011DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0xd70a6a0)’, ‘ktm@rice.edu’) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1077#012#011DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0xd70a6a0)’, ‘ktm@rice.edu’) called at /opt/rt504/local/plugins/RT-Extension-MergeUsers/lib/RT/Extension/MergeUsers.pm line 503#012#011RT::Principal::Ids(‘RT::Principal’, ‘ktm@rice.edu’) called at /opt/rt504/local/plugins/RT-Extension-MergeUsers/lib/RT/Extension/MergeUsers.pm line 574#012#011RT::Groups::WithMember(‘RT::Groups=HASH(0xd3bb548)’, ‘PrincipalId’, ‘ktm@rice.edu’, ‘Recursively’, 1) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder/Role/Roles.pm line 424#012#011RT::SearchBuilder::Role::Roles::RoleLimit(‘RT::Assets=HASH(0xd46c718)’, ‘CLASS’, ‘’, ‘VALUE’, ‘ktm@rice.edu’, ‘OPERATOR’, ‘=’, ‘CASESENSITIVE’, 0, …) called at /opt/rt504/sbin/…/lib/RT/Assets.pm line 340#012#011RT::Assets::RoleLimit(‘RT::Assets=HASH(0xd46c718)’, ‘VALUE’, ‘ktm@rice.edu’, ‘CLASS’, ‘’, ‘OPERATOR’, ‘=’, ‘CASESENSITIVE’, 0, …) called at /opt/rt504/local/plugins/RT-Extension-MergeUsers/lib/RT/Extension/MergeUsers.pm line 690#012#011RT::Principal::ANON(‘RT::Assets=HASH(0xd46c718)’, ‘TYPE’, ‘Owner’, ‘FIELD’, ‘Name’, ‘OPERATOR’, ‘=’, ‘VALUE’, ‘ktm@rice.edu’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 4623#012#011HTML::Mason::Commands::ProcessAssetsSearchArguments(‘Assets’, ‘RT::Assets=HASH(0xd46c718)’, ‘Catalog’, ‘RT::Catalog=HASH(0xd548748)’, ‘ARGSRef’, ‘HASH(0xd4632a8)’) called at /opt/rt504/share/html/Asset/Search/index.html line 57#012#011HTML::Mason::Commands::ANON(’!CF.{Room Number}‘, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135#012#011HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xd42b2b8)’, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval {…} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292#012#011HTML::Mason::Request::comp(undef, undef, undef, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 751#012#011RT::Interface::Web::ShowRequestedPage(‘HASH(0xd754fe0)’) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 428#012#011RT::Interface::Web::HandleRequest(‘HASH(0xd754fe0)’) called at /opt/rt504/share/html/autohandler line 53#012#011HTML::Mason::Commands::ANON(’!CF.{Room Number}‘, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Co
Sep 20 13:32:20 rt1a RT: [115153] Use of uninitialized value in string eq at /opt/rt504/sbin/…/lib/RT/Principal.pm line 112.
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $2 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] RT::Handle=HASH(0xbdbaf88) couldn’t execute the query ‘SELECT DISTINCT main.* FROM Groups main JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.GroupId = main.id ) JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) WHERE (CachedGroupMembers_2.Disabled = ?) AND (CachedGroupMembers_2.MemberId IN (?)) AND (Principals_1.Disabled = ?) AND (Principals_1.PrincipalType = ?) AND (LOWER(main.Domain) = ?) ORDER BY main.Name ASC ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 635.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT DISTINCT main.* FROM Groups main JOIN CachedGroupMembe…’, 0, ‘ktm@rice.edu’, 0, ‘Group’, ‘userdefined’) called at /opt/rt504/sbin/…/lib/RT/Handle.pm line 2975#012#011RT::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT DISTINCT main.* FROM Groups main JOIN CachedGroupMembe…’, 0, ‘ktm@rice.edu’, 0, ‘Group’, ‘userdefined’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 244#012#011DBIx::SearchBuilder::_DoSearch(‘RT::Groups=HASH(0xd3bb548)’) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder.pm line 1062#012#011RT::SearchBuilder::_DoSearch(‘RT::Groups=HASH(0xd3bb548)’) called at /opt/rt504/sbin/…/lib/RT/Groups.pm line 432#012#011RT::Groups::_DoSearch(‘RT::Groups=HASH(0xd3bb548)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 774#012#011DBIx::SearchBuilder::ItemsArrayRef(‘RT::Groups=HASH(0xd3bb548)’) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder.pm line 1047#012#011RT::SearchBuilder::ItemsArrayRef(‘RT::Groups=HASH(0xd3bb548)’) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder/Role/Roles.pm line 425#012#011RT::SearchBuilder::Role::Roles::RoleLimit(‘RT::Assets=HASH(0xd46c718)’, ‘CLASS’, ‘’, ‘VALUE’, ‘ktm@rice.edu’, ‘OPERATOR’, ‘=’, ‘CASESENSITIVE’, 0, …) called at /opt/rt504/sbin/…/lib/RT/Assets.pm line 340#012#011RT::Assets::RoleLimit(‘RT::Assets=HASH(0xd46c718)’, ‘VALUE’, ‘ktm@rice.edu’, ‘CLASS’, ‘’, ‘OPERATOR’, ‘=’, ‘CASESENSITIVE’, 0, …) called at /opt/rt504/local/plugins/RT-Extension-MergeUsers/lib/RT/Extension/MergeUsers.pm line 690#012#011RT::Principal::ANON(‘RT::Assets=HASH(0xd46c718)’, ‘TYPE’, ‘Owner’, ‘FIELD’, ‘Name’, ‘OPERATOR’, ‘=’, ‘VALUE’, ‘ktm@rice.edu’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 4623#012#011HTML::Mason::Commands::ProcessAssetsSearchArguments(‘Assets’, ‘RT::Assets=HASH(0xd46c718)’, ‘Catalog’, ‘RT::Catalog=HASH(0xd548748)’, ‘ARGSRef’, ‘HASH(0xd4632a8)’) called at /opt/rt504/share/html/Asset/Search/index.html line 57#012#011HTML::Mason::Commands::ANON(’!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135#012#011HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xd42b2b8)’, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval {…} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292#012#011HTML::Mason::Request::comp(undef, undef, undef, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 751#012#011RT::Interface::Web::ShowRequestedPage(‘HASH(0xd754fe0)’) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 428#012#011RT::Interface::Web::HandleRequest(‘HASH(0xd754fe0)’) called at /opt/rt504/share/html/autohandler line 53#012#011HTML::Mason::Commands::ANON(‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135#012#011HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xbe33e68)’, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1297#012#011
Sep 20 13:32:20 rt1a RT: [115153] DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: “ktm@rice.edu”#012CONTEXT: unnamed portal parameter $18 = ‘…’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 622.
Sep 20 13:32:20 rt1a RT: [115153] RT::Handle=HASH(0xbdbaf88) couldn’t execute the query ‘SELECT COUNT(DISTINCT main.id) FROM Assets main LEFT JOIN Groups Groups_1 ON ( LOWER(Groups_1.Domain) = ? ) AND ( LOWER(Groups_1.Name) = ? ) AND ( Groups_1.Instance = main.id ) LEFT JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.Disabled = ? ) AND ( CachedGroupMembers_2.GroupId = Groups_1.id ) LEFT JOIN CachedGroupMembers CachedGroupMembers_3 ON ( CachedGroupMembers_3.Disabled = ? ) AND ( CachedGroupMembers_3.GroupId = Groups_1.id ) WHERE ( ( CachedGroupMembers_2.MemberId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) OR ( CachedGroupMembers_3.MemberId IN (?) ) ) AND (main.Catalog = ?) AND (LOWER(main.Status) != ?) ’ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 635.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT COUNT(DISTINCT main.id) FROM Assets main LEFT JOIN Gro…’, ‘rt::asset-role’, ‘owner’, 0, 0, 22, 890395, 961853, …) called at /opt/rt504/sbin/…/lib/RT/Handle.pm line 2975#012#011RT::Handle::SimpleQuery(‘RT::Handle=HASH(0xbdbaf88)’, ‘SELECT COUNT(DISTINCT main.id) FROM Assets main LEFT JOIN Gro…’, ‘rt::asset-role’, ‘owner’, 0, 0, 22, 890395, 961853, …) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 327#012#011DBIx::SearchBuilder::__DoCount(‘RT::Assets=HASH(0xd46c718)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 320#012#011DBIx::SearchBuilder::_DoCount(‘RT::Assets=HASH(0xd46c718)’) called at /opt/rt504/sbin/…/lib/RT/SearchBuilder.pm line 1073#012#011RT::SearchBuilder::_DoCount(‘RT::Assets=HASH(0xd46c718)’) called at /opt/rt504/sbin/…/lib/RT/Assets.pm line 566#012#011RT::Assets::_DoCount(‘RT::Assets=HASH(0xd46c718)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1650#012#011DBIx::SearchBuilder::CountAll(‘RT::Assets=HASH(0xd46c718)’) called at /opt/rt504/sbin/…/lib/RT/Assets.pm line 190#012#011RT::Assets::CountAll(‘RT::Assets=HASH(0xd46c718)’) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1623#012#011DBIx::SearchBuilder::Count(‘RT::Assets=HASH(0xd46c718)’) called at /opt/rt504/sbin/…/lib/RT/Assets.pm line 184#012#011RT::Assets::Count(‘RT::Assets=HASH(0xd46c718)’) called at /opt/rt504/share/html/Asset/Search/index.html line 61#012#011HTML::Mason::Commands::ANON(’!CF.{Room Number}‘, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135#012#011HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xd42b2b8)’, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval {…} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292#012#011HTML::Mason::Request::comp(undef, undef, undef, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, …) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 751#012#011RT::Interface::Web::ShowRequestedPage(‘HASH(0xd754fe0)’) called at /opt/rt504/sbin/…/lib/RT/Interface/Web.pm line 428#012#011RT::Interface::Web::HandleRequest(‘HASH(0xd754fe0)’) called at /opt/rt504/share/html/autohandler line 53#012#011HTML::Mason::Commands::ANON(’!CF.{Room Number}', ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, ‘CF.{LOM Port}’, …) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135#012#011HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xbe33e68)’, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, ‘CF.{Equipment Type}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1297#012#011eval {…} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292#012#011HTML::Mason::Request::comp(undef, undef, undef, ‘!CF.{Room Number}’, ‘’, ‘CF.{Property Tag Number}’, ‘’, ‘!CF.{NIC1 Port}’, ‘’, …) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 481#012#011
If I use the user id in the Simple Search, the correct values are returned. If I disable the MergeUsers plugin, the search works correctly. We need it enabled to handle some duplicate accounts properly. Has anyone seen this issue before and if so, what can be done to fix it?
Regards,
Ken Marshall