[rt-users] Report "Resolved by owner" fails to output, generates error in log

Charles Kugelman Charles.Kugelman at kaplan.com
Mon Apr 13 12:25:27 EDT 2009


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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090413/0329cbda/attachment.htm>


More information about the rt-users mailing list