A small, early $HOLIDAY gift from BPS

More accurately, a holiday gift from one of our customers whose legal
department has told us we’re never allowed to mention them by name.

I’ve just uploaded to cpan “RT-Extension-ActivityReports”, which
includes four new reports for RT 3.4 that slot into the “Tools” menu and
can easily run on the results of any search you do.

Best,

Jesse

This looks like it could be pretty useful here…please pass our thanks
along to the anonymous benefactors. :slight_smile:

Mark Roedel
Web Programmer / Analyst
LeTourneau University-----Original Message-----
From: rt-devel-bounces@lists.bestpractical.com
[mailto:rt-devel-bounces@lists.bestpractical.com] On Behalf Of Jesse
Vincent
Sent: Tuesday, December 20, 2005 10:20 AM
To: rt-devel@lists.bestpractical.com
Subject: [Rt-devel] A small, early $HOLIDAY gift from BPS

More accurately, a holiday gift from one of our customers whose legal
department has told us we’re never allowed to mention them by name.

I’ve just uploaded to cpan “RT-Extension-ActivityReports”, which
includes four new reports for RT 3.4 that slot into the “Tools” menu and
can easily run on the results of any search you do.

Best,

Jesse

Installed this and after installing a few additional CPAN modules, my RT
is back up, but when I run any of the reports, I get table headers, but
no data and in /var/log/httd/error_log I get messages like this (note
time is in GMT too unlike the other messages in the file):

[Wed Dec 21 14:29:48 2005] [error]: Query error in << AND ( Updated >=
‘2005-12-1’ AND Updated <= ‘2005-12-21’)>>:
Error near ->(<- expecting a OP in AND ( Updated >= ‘2005-12-1’ AND
Updated <= ‘2005-12-21’)

Stack:
[/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:238]
[/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:480]
[/opt/rt3/share/html/Reports/Activity/ActivitySummary.html:39]
[/opt/rt3/share/html/autohandler:215]
(/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:482)

Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
kfh@mqsoftware.com

-----Original Message-----
From: rt-devel-bounces@lists.bestpractical.com [mailto:rt-devel-
bounces@lists.bestpractical.com] On Behalf Of Jesse Vincent
Sent: Tuesday, December 20, 2005 10:20 AM
To: rt-devel@lists.bestpractical.com
Subject: [Rt-devel] A small, early $HOLIDAY gift from BPS

More accurately, a holiday gift from one of our customers whose legal
department has told us we’re never allowed to mention them by name.

I’ve just uploaded to cpan “RT-Extension-ActivityReports”, which
includes four new reports for RT 3.4 that slot into the “Tools” menu
and

Installed this and after installing a few additional CPAN modules, my RT
is back up, but when I run any of the reports, I get table headers, but
no data and in /var/log/httd/error_log I get messages like this (note
time is in GMT too unlike the other messages in the file):

What RT are you running? I know Updated got some fixes in the 3.4.5 dev
series.

-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Wednesday, December 21, 2005 9:55 AM
To: Kelly F. Hickel
Cc: Jesse Vincent; rt-devel@lists.bestpractical.com
Subject: Re: [Rt-devel] A small, early $HOLIDAY gift from BPS

Installed this and after installing a few additional CPAN modules,
my RT

is back up, but when I run any of the reports, I get table headers,
but

no data and in /var/log/httd/error_log I get messages like this
(note

time is in GMT too unlike the other messages in the file):

What RT are you running? I know Updated got some fixes in the 3.4.5
dev
series.
This is RT 3.4.4

[Wed Dec 21 14:29:48 2005] [error]: Query error in << AND ( Updated
=
‘2005-12-1’ AND Updated <= ‘2005-12-21’)>>:
Error near ->(<- expecting a OP in AND ( Updated >= ‘2005-12-1’ AND
Updated <= ‘2005-12-21’)

Stack:
[/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:238]
[/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:480]
[/opt/rt3/share/html/Reports/Activity/ActivitySummary.html:39]
[/opt/rt3/share/html/autohandler:215]
(/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:482)

Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc
952.345.8677
kfh@mqsoftware.com

-----Original Message-----
From: rt-devel-bounces@lists.bestpractical.com [mailto:rt-devel-
bounces@lists.bestpractical.com] On Behalf Of Jesse Vincent
Sent: Tuesday, December 20, 2005 10:20 AM
To: rt-devel@lists.bestpractical.com
Subject: [Rt-devel] A small, early $HOLIDAY gift from BPS

More accurately, a holiday gift from one of our customers whose
legal

department has told us we’re never allowed to mention them by
name.

I’ve just uploaded to cpan “RT-Extension-ActivityReports”, which
includes four new reports for RT 3.4 that slot into the "Tools"
menu

This is RT 3.4.4

Oh. wait. did you run ActivitySummary with no user-defined query?

-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Wednesday, December 21, 2005 10:03 AM
To: Kelly F. Hickel
Cc: Jesse Vincent; rt-devel@lists.bestpractical.com
Subject: Re: [Rt-devel] A small, early $HOLIDAY gift from BPS

This is RT 3.4.4

Oh. wait. did you run ActivitySummary with no user-defined query?
Yep, sure did. So I have to enter some base query?

-Kelly

Oh. wait. did you run ActivitySummary with no user-defined query?
Yep, sure did. So I have to enter some base query?

Start from a Ticket search. look in the lower right corner of the
results page. (And yes, we’ll bulletproof the search page)

-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Wednesday, December 21, 2005 10:15 AM
To: Kelly F. Hickel
Cc: Jesse Vincent; rt-devel@lists.bestpractical.com
Subject: Re: [Rt-devel] A small, early $HOLIDAY gift from BPS

Oh. wait. did you run ActivitySummary with no user-defined query?
Yep, sure did. So I have to enter some base query?

Start from a Ticket search. look in the lower right corner of the
results page. (And yes, we’ll bulletproof the search page)
OK, that did it, now it works…

Thanks

Start from a Ticket search. look in the lower right corner of the
results page. (And yes, we’ll bulletproof the search page)

OK, that did it, now it works…

Indeed. Thanks for asking the question. I would have done otherwise …

Looks very usable indeed!

/af

Actually I correct myself - after /using/ it now I had to emergency-stop
RT again; this time it was not the mysql which was going crazy, but the
apache.

I’ll work on the hardware as well a bit.
/af

Actually I correct myself - after /using/ it now I had to emergency-stop
RT again; this time it was not the mysql which was going crazy, but the
apache.

I haven’t seen your previous message yet, but that’s definitely not a
good sign. What did you click that sent RT into a tailspin?

I haven’t seen your previous message yet, but that’s definitely not a
good sign. What did you click that sent RT into a tailspin?

Here we start:

2719 mysql 16 0 946m 282m 2924 S 0.0 28.0 327:20.25 mysqld
(28% memory for mysql)

I tried

Queue = ‘$BigFirstLevelQueue’ OR ( Status = ‘open’ OR Status = 'new’
OR Status = ‘stalled’ ) OR Status = ‘resolved’

I Found 86,357 tickets.

Then I do “created monthly” as bar and it looks cool. No performance
impact at all ( load average: 0.05, ->0.10<-. 0.09). And I really like
that graph.

I then go back to my big search result and click on “Reports”.

I click on “Activity Summary”, but scope only one week (as proposed).
That seems to be very expensive. Too expensive for my server.

More Memory (currently 1GB) and CPU (currently 1) will come, but I still
feel something else is wrong(?).

Best,
Alex

I click on “Activity Summary”, but scope only one week (as proposed).
That seems to be very expensive. Too expensive for my server.

can you get the queries out of mysql? There’s a chance that the index
will fix it. There’s also a chance that the query our customer was
looking for turns out to be crazy in your environment.

Jesse