[rt-users] RTx::Statistics v1.8 - Tickets per day inmultiplequeues shows a ll tickets created since inception

Wed Jan 25 09:47:09 EST 2006

Steve,

            Well, Hmm. I can't say that I've seen that behavior, but
strangely enough I'm still not using RT for anything!  In any event,
awhile back I added some debugging, so go into Statistics.pm, look for
the line below, change 0 to 1.

my $debugging=0;  # set to 1 to enable debugging

Now, you'll have to restart apache and clear the mason object cache.  If
you have a test/dev system where you care a bit less about performance,
find the variable DevelMode in /opt/rt3/etc/RT_Config.pm, copy that
variable to RT_SiteConfig.pm and set it to '1'.  That way you won't have
to keep restarting apache and clearing the cache.

Now, it's unlikely that I've added the exact debugging line to find your
problem, but if you look in CallsMultiQueue/index.html for calls to
Statistcs::DebugLog, you'll see that you can copy these, sprinkle them
around, printing out the things that you're suspicious of.....

-- 

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

  _____  

From: Steven Platt [mailto:Steven.Platt at HPA.org.uk] 
Sent: Wednesday, January 25, 2006 4:11 AM
To: Kelly F. Hickel; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] RTx::Statistics v1.8 - Tickets per day
inmultiplequeues shows a ll tickets created since inception

Kelly,

Thanks for the advice but I'm afraid it doesn't solve the problem. 

Here's a bit more info ... when /CallsMultiQueue/index.html is first
displayed it shows the correct ticket figures, but updating the page in
any way (changing status, queue, date range) gives the error. Updates
take effect so all queues are seen, different date ranges shown, etc...
but the number of tickets for each date under a particular queue is the
same and it's the total number of tickets created in that queue since RT
began.

I looked into Statistics.pm and found the lines you mentioned. By
tweaking the initial settings for $Multiqueue variables I can get a
basic report although it'd be much nicer to be able to use this
properly. I've got a feeling the problem lies with
/CallsMultiQueue/index.html rather than Statistics.pm, but I wouldn't
know where to start looking.

Any thoughts?

Steve

Bioinformatics

Ext 6618

  _____  

From: Kelly F. Hickel [mailto:kfh at mqsoftware.com] 
Sent: Tuesday,24 January 2006 19:12
To: Kelly F. Hickel; Steven Platt; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] RTx::Statistics v1.8 - Tickets per day
inmultiplequeues shows a ll tickets created since inception

Steve,

            I'm not sure if that answered your question, so let me know.
Also, Nick's changes are already incorporated to v0.1.8.....

-- 

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

  _____  

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kelly F.
Hickel
Sent: Tuesday, January 24, 2006 1:09 PM
To: Steven Platt; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] RTx::Statistics v1.8 - Tickets per day
inmultiplequeues shows a ll tickets created since inception

Steve,

            The way it's supposed to work is you modify this statement
"$MultiQueueMaxRows = 10;" in /opt/rt3/local/lib/RTx/Statistics.pm to be
the number of days you want the chart to show by default. For
CallsQueueDay, you change this one: "$PerDayMaxRows = 10;".

-- 

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

  _____  

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Steven
Platt
Sent: Tuesday, January 24, 2006 11:18 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] RTx::Statistics v1.8 - Tickets per day in
multiplequeues shows a ll tickets created since inception

Request Trackers,

I've just upgraded to RTx::Statistics  v1.8. It looks great and works
fine, apart from one niggle...

When I view 'Tickets per day in Multiple Queues by status' every day in
the range reports the number of tickets created in that queue since RT
was enabled. This happens for single & multi-queue queries, regardless
of the query status. Here's an example of the header accompanying a
dodgy result set "Tickets with Status ARRAY(0x9b45f2c) in
Bioinformatics, per day from Sat Jan 14 2006 through Tue Jan 24 2006
<http://www.hpa-bioinfosupport.org.uk/RTx/Statistics/OpenStalled/index.h
tml?queues=Bioinformatics&sDay=14&sMonth=0&sYear=2006&eDay=24&eMonth=0&e
Year=2006&weekends=1> "

I've looked over the Wiki & searched the mailing list archives and the
best suggestion came from Nick
(http://www...gossamer-threads.com/lists/rt/users/51586
<http://www.gossamer-threads.com/lists/rt/users/51586> ). Unfortunately
this fixes Statistics v1.7 and all the changes appear to be implemented
in v1.8 /CallsMultiQueue/index.html. 

We're running RT v3.4.2 (not looking to upgrade just yet), Perl v5.8.6,
Mason 1.18 & Apache 1.3 on Redhat 1.7.

Any help or pointers gratefully received.

Thanks

Steve

Steve Platt

Bioinformatics Support Co-ordinator

Bioinformatics Unit: Statistics, Modelling & Bioinformatics Department

Center for Infections

Health Protection Agency

61 Colindale Avenue

London

UK

NW9 5EQ

http://www.hpa.org.uk/srmd/bioinformatics/index.htm

  _____  

***********************************************************************
***
The information contained in the EMail and any attachments is
confidential and intended solely and for the attention and use of the
named addressee(s). It may not be disclosed to any other person without
the express authority of the HPA, or the intended recipient, or both.
If you are not the intended recipient, you must not disclose, copy,
distribute or retain this message or any part of it. This footnote also
confirms that this EMail has been swept for computer viruses, but
please re-sweep any attachments before opening or saving.
HTTP://www.HPA.org.uk *************************************************
************************* 

  _____  

***********************************************************************
***
The information contained in the EMail and any attachments is
confidential and intended solely and for the attention and use of the
named addressee(s). It may not be disclosed to any other person without
the express authority of the HPA, or the intended recipient, or both.
If you are not the intended recipient, you must not disclose, copy,
distribute or retain this message or any part of it. This footnote also
confirms that this EMail has been swept for computer viruses, but
please re-sweep any attachments before opening or saving.
HTTP://www.HPA.org.uk *************************************************
************************* 

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