Problem with search builder after upgrade 3.8.4 to 4.2.12

I’m running the following:

RT 4.2.12
Fast CGI
Apache/2.2.12 (Linux/SUSE)
3.0.101-0.47.71-ppc64 #1 SMP

I recently upgraded from 3.8.4 to 4.2.12 RT and everything seems great except I noticed that creating a new search causes an error for me in most cases:

“The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script”

I recall talk on the listserve about certain global permissions causing issues with searches but I’m not finding it. Can someone point me in the right direction for which rights to look out for or are there settings I can adjust to give the system more resources for the search? The builder did not encounter this error in 3.8.4.

Thank you,
Tim

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

I misspoke I am running fcgid .

Additionally the page I am having issues with at the moment is: /Search/Build.html?NewQuery=1

In doing some reading I ran the following in query window with zero responses:

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Everyone’) and rightname=‘OwnTicket’);

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Unprivileged’) and rightname=‘OwnTicket’);

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Privileged’) and rightname=‘OwnTicket’);

Additionally I tried setting the MaxRequestLen 1073741824 as identified here (Web deployment - RT 4.2.12 Documentation - Best Practical)

FcgidMaxRequestLen 1073741824 threw an error in my conf file so I figured the Fcgid part was extra? Apache2 did not error on MaxRequestLen.

TimFrom: rt-users [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Flynn, Timothy
Sent: Friday, February 12, 2016 1:00 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] problem with search builder after upgrade 3.8.4 to 4.2.12

I’m running the following:

RT 4.2.12
Fast CGI
Apache/2.2.12 (Linux/SUSE)
3.0.101-0.47.71-ppc64 #1 SMP

I recently upgraded from 3.8.4 to 4.2.12 RT and everything seems great except I noticed that creating a new search causes an error for me in most cases:

“The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script”

I recall talk on the listserve about certain global permissions causing issues with searches but I’m not finding it. Can someone point me in the right direction for which rights to look out for or are there settings I can adjust to give the system more resources for the search? The builder did not encounter this error in 3.8.4.

Thank you,
Tim

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

It seems like my issue could be related to what changed here:

https://www.bestpractical.com/docs/rt/4.2.12/UPGRADING-4.0.html#UPGRADING-FROM-4.0.5-AND-EARLIER

I can’t load query builder and it also appears that bulk updated fails after listing the tickets… I can’t tell it what I want to update. Does anyone have any ideas? I don’t have any customizations to RT as indicated in this article. Would really appreciate some guidance here.

TimFrom: rt-users [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Flynn, Timothy
Sent: Friday, February 12, 2016 5:15 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] problem with search builder after upgrade 3.8.4 to 4.2.12

I misspoke I am running fcgid .

Additionally the page I am having issues with at the moment is: /Search/Build.html?NewQuery=1

In doing some reading I ran the following in query window with zero responses:

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Everyone’) and rightname=‘OwnTicket’);

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Unprivileged’) and rightname=‘OwnTicket’);

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Privileged’) and rightname=‘OwnTicket’);

Additionally I tried setting the MaxRequestLen 1073741824 as identified here (Web deployment - RT 4.2.12 Documentation - Best Practical)

FcgidMaxRequestLen 1073741824 threw an error in my conf file so I figured the Fcgid part was extra? Apache2 did not error on MaxRequestLen.

Tim

From: rt-users [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Flynn, Timothy
Sent: Friday, February 12, 2016 1:00 PM
To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com
Subject: [rt-users] problem with search builder after upgrade 3.8.4 to 4.2.12

I’m running the following:

RT 4.2.12
Fast CGI
Apache/2.2.12 (Linux/SUSE)
3.0.101-0.47.71-ppc64 #1 SMP

I recently upgraded from 3.8.4 to 4.2.12 RT and everything seems great except I noticed that creating a new search causes an error for me in most cases:

“The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script”

I recall talk on the listserve about certain global permissions causing issues with searches but I’m not finding it. Can someone point me in the right direction for which rights to look out for or are there settings I can adjust to give the system more resources for the search? The builder did not encounter this error in 3.8.4.

Thank you,
Tim

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

If anyone has been following my conversation with myself I fixed this with a SiteConfig setting of:

Set($AutocompleteOwners, 1);

TimFrom: rt-users [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Flynn, Timothy
Sent: Thursday, February 25, 2016 11:54 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] problem with search builder after upgrade 3.8.4 to 4.2.12

It seems like my issue could be related to what changed here:

https://www.bestpractical.com/docs/rt/4.2.12/UPGRADING-4.0.html#UPGRADING-FROM-4.0.5-AND-EARLIER

I can’t load query builder and it also appears that bulk updated fails after listing the tickets… I can’t tell it what I want to update. Does anyone have any ideas? I don’t have any customizations to RT as indicated in this article. Would really appreciate some guidance here.

Tim

From: rt-users [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Flynn, Timothy
Sent: Friday, February 12, 2016 5:15 PM
To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com
Subject: Re: [rt-users] problem with search builder after upgrade 3.8.4 to 4.2.12

I misspoke I am running fcgid .

Additionally the page I am having issues with at the moment is: /Search/Build.html?NewQuery=1

In doing some reading I ran the following in query window with zero responses:

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Everyone’) and rightname=‘OwnTicket’);

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Unprivileged’) and rightname=‘OwnTicket’);

select name from queues where id in
(select objectid from acl where principaltype=‘Group’ and principalid =
(select id from groups where type=‘Privileged’) and rightname=‘OwnTicket’);

Additionally I tried setting the MaxRequestLen 1073741824 as identified here (Web deployment - RT 4.2.12 Documentation - Best Practical)

FcgidMaxRequestLen 1073741824 threw an error in my conf file so I figured the Fcgid part was extra? Apache2 did not error on MaxRequestLen.

Tim

From: rt-users [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Flynn, Timothy
Sent: Friday, February 12, 2016 1:00 PM
To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com
Subject: [rt-users] problem with search builder after upgrade 3.8.4 to 4.2.12

I’m running the following:

RT 4.2.12
Fast CGI
Apache/2.2.12 (Linux/SUSE)
3.0.101-0.47.71-ppc64 #1 SMP

I recently upgraded from 3.8.4 to 4.2.12 RT and everything seems great except I noticed that creating a new search causes an error for me in most cases:

“The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script”

I recall talk on the listserve about certain global permissions causing issues with searches but I’m not finding it. Can someone point me in the right direction for which rights to look out for or are there settings I can adjust to give the system more resources for the search? The builder did not encounter this error in 3.8.4.

Thank you,
Tim

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.

Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.