All,
It's been pointed out that the "Resolved by owner" report isn't outputting results. I looked in the RT error log and found the entries below. Thoughts? ---Relevant Info--- - RT Version: 3.8.2 - HTTPD Package (RPM): httpd-2.2.3-22.el5 - Mod_Perl Package (RPM): mod_perl-2.0.4-6.el5 - Perl Package (RPM): perl-5.8.8-18.el5 - OS: RedHat Enterprise Linux 5 - Oracle Client: 10.2, Instant Client - Oracle Server (remote server): 11g - Mail Package (RPM): postfix-2.3.3-2 ---Errors--- [Mon Apr 13 16:08:14 2009] [warning]: DBD::Oracle::db prepare failed: ORA-00979: not a GROUP BY expression (DBD ERROR: error possibly near <*> indicator at char 29 in 'SELECT COUNT(main.id) AS id, <*>Users_2.Name AS col1 FROM Tickets main LEFT JOIN Users Users_2 ON ( Users_2.id = main.Owner ) LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner ) WHERE (main.Status != 'deleted') AND (main.Status = 'resolved' AND main.Queue = '5') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) GROUP BY Users_1.Name ') [for Statement "SELECT COUNT(main.id) AS id, Users_2.Name AS col1 FROM Tickets main LEFT JOIN Users Users_2 ON ( Users_2.id = main.Owner ) LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner ) WHERE (main.Status != 'deleted') AND (main.Status = 'resolved' AND main.Queue = '5') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) GROUP BY Users_1.Name "] at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 465, <GEN79> line 130. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:465) [Mon Apr 13 16:08:14 2009] [warning]: RT::Handle=HASH(0x2b9ff6d2c540) couldn't prepare the query 'SELECT COUNT(main.id) AS id, Users_2.Name AS col1 FROM Tickets main LEFT JOIN Users Users_2 ON ( Users_2.id = main.Owner ) LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner ) WHERE (main.Status != 'deleted') AND (main.Status = 'resolved' AND main.Queue = '5') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) GROUP BY Users_1.Name 'ORA-00979: not a GROUP BY expression (DBD ERROR: error possibly near <*> indicator at char 29 in 'SELECT COUNT(main.id) AS id, <*>Users_2.Name AS col1 FROM Tickets main LEFT JOIN Users Users_2 ON ( Users_2.id = main.Owner ) LEFT JOIN Users Users_1 ON ( Users_1.id = main.Owner ) WHERE (main.Status != 'deleted') AND (main.Status = 'resolved' AND main.Queue = '5') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) GROUP BY Users_1.Name ') (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:472) Thanks, -CK
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
