I don’t know if I missed a step on the upgrade or what (I did to run
etc/upgrade/upgrade-assets). My assets are working correctly except for
this:
Any asset linked to a privileged user will not show up as an Assigned Asset
on their user page. As long as they are a non-privileged user, it seems
to work fine (tested with Held By and Ownder),
I’m sure this search error I get in the log is pointing me to the culprit
but not sure what to do in order to fix the issue or how I might have
caused it.
Feb 17 18:10:59 rt RT: [19769] Use of uninitialized value
$args{“GroupsAlias”} in hash element at
/opt/rt4/sbin/…/lib/RT/SearchBuilder/Role/Roles.pm line 153.
Feb 17 18:10:59 rt RT: [19769] Use of uninitialized value $args{“ALIAS1”}
in concatenation (.) or string at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm line 1086.
Feb 17 18:10:59 rt RT: [19769] Use of uninitialized value in string eq at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm line 1282.
Feb 17 18:10:59 rt RT: [19769] DBD::Pg::st execute failed: ERROR: syntax
error at or near “.”#012LINE 1: …bled = ‘0’ ) AND (
CachedGroupMembers_3.GroupId = .id ) JOIN…#012
^ at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm line 586.
Feb 17 18:10:59 rt RT: [19769] RT::Handle=HASH(0x7f6ca0066e60) couldn’t
execute the query 'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN
CachedGroupMembers CachedGroupMembers_3 ON ( CachedGroupMembers_3.Disabled
= ‘0’ ) AND ( CachedGroupMembers_3.GroupId = .id ) JOIN CachedGroupMembers
CachedGroupMembers_4 ON ( CachedGroupMembers_4.Disabled = ‘0’ ) AND (
CachedGroupMembers_4.GroupId = .id ) JOIN Groups Groups_1 ON (
LOWER(Groups_1.Domain) = ‘rt::asset-role’ ) AND ( Groups_1.Instance =
main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON (
CachedGroupMembers_2.Disabled = ‘0’ ) AND ( CachedGroupMembers_2.GroupId =
Groups_1.id ) WHERE ( ( CachedGroupMembers_2.MemberId = ‘151821’ ) OR (
CachedGroupMembers_3.MemberId = ‘3863’ ) OR (
CachedGroupMembers_4.MemberId = ‘26’ ) ) AND (LOWER(main.Status) !=
‘deleted’) ’ at /usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm
line
599.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f6ca0066e60),
“SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGr”…) called
at /usr/local/share/perl/5.20.2/DBIx/SearchBuilder.pm line
295#012#011DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0x7f6cb4236bb0),
- called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line
993#012#011RT::SearchBuilder::_DoCount(RT::Assets=HASH(0x7f6cb4236bb0), 1)
called at /opt/rt4/sbin/…/lib/RT/Assets.pm line
293#012#011RT::Assets::_DoCount(RT::Assets=HASH(0x7f6cb4236bb0), 1) called
at /usr/local/share/perl/5.20.2/DBIx/SearchBuilder.pm line
1525#012#011DBIx::SearchBuilder::CountAll(RT::Assets=HASH(0x7f6cb4236bb0))
called at /opt/rt4/share/html/Elements/CollectionList line
54#012#011HTML::Mason::Commands::ANON(“Collection”,
RT::Assets=HASH(0x7f6cb4236bb0), “OrderBy”, “id”, “Order”, “ASC”, “Format”,
“\x{a} '<a href="WebHomePath/Asset/Display.html?id=_id”…,
“AllowSorting”, …) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6ca0448688),
“Collection”, RT::Assets=HASH(0x7f6cb4236bb0), “OrderBy”, “id”, “Order”,
“ASC”, “Format”, “\x{a} '<a
href="WebHomePath/Asset/Display.html?id=_id”…, …) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1302#012#011eval
{…} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, “Collection”,
RT::Assets=HASH(0x7f6cb4236bb0), “OrderBy”, “id”, “Order”, “ASC”, “Format”,
…) called at /opt/rt4/share/html/User/Elements/AssetList line
66#012#011HTML::Mason::Commands::ANON() called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1380#012#011eval
{…} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1380#012#011HTML::Mason::Request::content(RT::Interface::Web::Request=HASH(0x7f6ca04799d0))
called at /opt/rt4/share/html/Widgets/TitleBox line
56#012#011HTML::Mason::Commands::ANON(“title”, “Assigned Assets”,
“class”, “user asset-list”) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6ca0439fb0),
“title”, “Assigned Assets”, “class”, “user asset-list”) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1302#012#011eval
{…} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, undef, “title”,
“Assigned Assets”, “class”, “user asset-list”) called at
/opt/rt4/share/html/User/Elements/AssetList line
73#012#011HTML::Mason::Commands::ANON(“User”,
RT::User=HASH(0x7f6ca04e4818), “Roles”, ARRAY(0x7f6cb8d0cb70), “Title”,
“Assigned Assets”) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6cb4236e50),
“User”, RT::User=HASH(0x7f6ca04e4818), “Roles”, ARRAY(0x7f6cb8d0cb70),
“Title”, “Assigned Assets”) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1302#012#011eval
{…} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, “User”,
RT::User=HASH(0x7f6ca04e4818), “Roles”, ARRAY(0x7f6cb8d0cb70), “Title”,
“Assigned Assets”) called at
/opt/rt4/share/html/User/Elements/Portlets/UserAssets line
49#012#011HTML::Mason::Commands::ANON(“User”,
RT::User=HASH(0x7f6ca04e4818)) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6cb8d105b8),
“User”, RT::User=HASH(0x7f6ca04e4818)) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1302#012#011eval
{…} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, “User”,
RT::User=HASH(0x7f6ca04e4818)) called at
/opt/rt4/share/html/User/Summary.html line
94#012#011HTML::Mason::Commands::ANON(“UserAssets”) called at
/opt/rt4/share/html/User/Summary.html line
57#012#011HTML::Mason::Commands::ANON(“id”, 26) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6ca03b21c8),
“id”, 26) called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1302#012#011eval {…} called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, undef, “id”, 26)
called at /opt/rt4/sbin/…/lib/RT/Interface/Web.pm line
696#012#011RT::Interface::Web::ShowRequestedPage(HASH(0x7f6cb031b0e8))
called at /opt/rt4/sbin/…/lib/RT/Interface/Web.pm line
375#012#011RT::Interface::Web::HandleRequest(HASH(0x7f6cb031b0e8)) called
at /opt/rt4/share/html/autohandler line
53#012#011HTML::Mason::Commands::ANON(“id”, 26) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6ca0142530),
“id”, 26) called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1300#012#011eval {…} called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, undef, “id”, 26)
called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
481#012#011eval {…} called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 481#012#011eval
{…} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
433#012#011HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x7f6ca04799d0))
called at /usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler.pm line
96#012#011eval {…} called at
/usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler.pm line
96#012#011HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x7f6ca04799d0))
called at /usr/local/share/perl/5.20.2/HTML/Mason/Interp.pm line
342#012#011HTML::Mason::Interp::exec(undef, undef, “id”, 26) called at
/usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler.pm line 59#012#011eval
{…} called at /usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler.pm line
59#012#011HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x7f6cfe138d60),
HASH(0x7f6cb8c41c60), HASH(0x7f6ca04f4500)) called at
/usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler/Streamy.pm line
52#012#011HTML::Mason::PSGIHandler::Streamy::ANON(CODE(0x7f6cb8cbb4c0))
called at /usr/local/share/perl/5.20.2/Plack/Util.pm line
339#012#011Plack::Util::ANON(CODE(0x7f6ca04c3ec0)) called at
/usr/local/share/perl/5.20.2/Plack/Handler/Apache2.pm line
89#012#011Plack::Handler::Apache2::call_app(“Plack::Handler::Apache2”,
Apache2::RequestRec=SCALAR(0x7f6ca04cd218), CODE(0x7f6cfe2b5ce0)) called at
/usr/local/share/perl/5.20.2/Plack/Handler/Apache2.pm line
126#012#011Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f6ca04cd218))
called at -e line 0#012#011eval {…} called at -e line 0