<div dir="ltr">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:<div><br></div><div>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), </div><div><br></div><div>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. </div><div><br></div><div>--</div><div><p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">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.</p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">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.</p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">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.</p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">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.</p>
<p style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">Feb 17 18:10:59 rt RT: [19769] RT::Handle=HASH(0x7f6ca0066e60) couldn't execute the query 'SELECT COUNT(DISTINCT <a href="http://main.id">main.id</a>) 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 = <a href="http://main.id">main.id</a> ) 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 <a href="http://main.id">main.id</a>) 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), 1) 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}    '<b><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}    '<b><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</p></div><div>--</div></div>