Hello,
I am trying to create some simple chart which is based on transaction search, for example to illustrate number of correspond transactions were done. When I setup my transaction search query and go for the Chart, I get an error “Your query exceeded the maximum run time and was stopped. Try modifying your query to improve the performance or contact your RT admin.”
Request tracker log shows me bunch of errors like
2025-05-05T08:00:42.806757+00:00 rsyslog rtir-apache2-error: [11902] [Mon May 5 08:00:42 2025] [warning]: DBD::Pg::st execute failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
2025-05-05T08:00:42.806795+00:00 rsyslog rtir-apache2-error: LINE 1: …EN NULL ELSE main.Created END < $29 ) ) ORDER BY main.Creat…
2025-05-05T08:00:42.806809+00:00 rsyslog rtir-apache2-error: ^ at /usr/local/share/perl/5.34.0/DBIx/SearchBuilder/Handle.pm line 634. (/usr/local/share/perl/5.34.0/DBIx/SearchBuilder/Handle.pm:634)
Wondering I stumbled on some RT bug, or it is my deployment related problem. Can anyone confirm that RT’s transaction charts works? I am using RT 5.0.7.
–
Marius