Assets not linking to privileged users after upgrade to 4.4.0

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),

  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} '<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