Skip Menu |

This queue is for tickets about the RT-Extension-ActivityReports CPAN distribution.

Report information
The Basics
Id: 85177
Status: rejected
Priority: 0/
Queue: RT-Extension-ActivityReports
People
Owner: Nobody in particular
Requestors: juan.lopez [...] tdn.com.ni
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)
Attachments
image001.png
image002.png
image003.png

History Show all quoted text
  Fri May 10 12:42:30 2013 juan.lopez [...] tdn.com.ni - Ticket created
Subject: two problem with activity report
Date: Fri, 10 May 2013 10:41:59 -0600
To: <bug-RT-Extension-ActivityReports [...] rt.cpan.org>
From: "Juan Carlos Lopez" <juan.lopez [...] tdn.com.ni>
I am using RT 4.0.12 in ubuntu 12.04 and Activity report extension 1.03 Problem 1: It is not showing the correct statistic, ex: I only have 1 new ticket but the activity report say 5 tickets. Etc. Second Problem: If I try to use “resolution comments” and “ Resolution statistic” I received the following error: In my log I have the following: Stack: [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/E lements/ResolutionComments:31] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/E lements/ResolutionComments:31] [/usr/local/share/perl/5.14.2/HTML/Mason/Interp.pm:820] [/usr/local/share/perl/5.14.2/HTML/Mason/Interp.pm:448] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1130] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1063] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1242] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Search/Elements/Ac tivityReport:8] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/i ndex.html:8] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/E lements/Wrapper:10] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/i ndex.html:11] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:634] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:335] [/opt/rt4/share/html/autohandler:53] BEGIN failed--compilation aborted at /opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/El ements/ResolutionComments line 31. Stack: [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/E lements/ResolutionComments:31] [/usr/local/share/perl/5.14.2/HTML/Mason/Interp.pm:820] [/usr/local/share/perl/5.14.2/HTML/Mason/Interp.pm:448] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1130] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1063] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1242] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Search/Elements/Ac tivityReport:8] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/i ndex.html:8] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/E lements/Wrapper:10] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/i ndex.html:11] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:634] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:335] [/opt/rt4/share/html/autohandler:53] Stack: [/usr/local/share/perl/5.14.2/HTML/Mason/Interp.pm:453] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1130] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1063] [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:1242] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Search/Elements/Ac tivityReport:8] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/i ndex.html:8] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/E lements/Wrapper:10] [/opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/i ndex.html:11] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:634] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:335] [/opt/rt4/share/html/autohandler:53] (/opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm:208) Juan Carlos López Corrales | Ing. Aplicaciones IT. Tecnología de Nicaragua S.A | Km 3 1/2 Carretera Sur, Las Palmas, Gasolinera Uno 1c Norte, | Managua, Nicaragua. Teléfono +505 2268-7530 ext. 213 | Claro +505 89454239 | Movistar +505 89884442 <mailto:juan.lopez@tdn.com.ni> juan.lopez@tdn.com.ni <http://www.tdn.com.ni/> www.tdn.com.ni | www.EmersonNetworkPower.com Este mensaje y cualquier adjunto trasmitido con él, son confidenciales y fueron planeados solo para el destinatario originalmente nombrado. Está estrictamente prohibido revelar, copiar, distribuir o tomar cualquier acción en relación al contenido de esta información. Si tú has recibido éste mensaje producto de un error por favor comunícate con <mailto:sysadmin@tdn.com.ni> sysadmin@tdn.com.ni o con el remitente original del mensaje. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and/or <mailto:sysadmin@tdn.com.ni> sysadmin@tdn.com.ni and delete the original. Any other use of the email by you is prohibited.
Download image001.png
image/png 29.5k
image001.png
Download image002.png
image/png 5.9k
image002.png
Download image003.png
image/png 30.1k
image003.png
  Fri May 10 12:49:35 2013 tsibley [...] cpan.org - Correspondence added
Subject: Re: [rt.cpan.org #85177] two problem with activity report
Date: Fri, 10 May 2013 09:48:48 -0700
To: bug-RT-Extension-ActivityReports [...] rt.cpan.org
From: Thomas Sibley <tsibley [...] cpan.org>
On 05/10/2013 09:42 AM, juan.lopez@tdn.com.ni via RT wrote: Show quoted text
> Problem 1: > > It is not showing the correct statistic, ex: > > I only have 1 new ticket but the activity report say 5 tickets. Etc.
The reports are for a certain time frame (between two dates) and so over those two dates you must have had 5 new tickets. Show quoted text
> Second Problem: > > If I try to use “resolution comments” and “ Resolution statistic” I received > the following error: > > In my log I have the following:
The copy and pasted logs you sent don't contain the actual error messages and instead just has the stacktraces. Please include the full logs, otherwise we can't help.
  Fri May 10 12:49:35 2013 The RT System itself - Status changed from 'new' to 'open'
  Fri May 10 12:57:22 2013 juan.lopez [...] tdn.com.ni - Correspondence added
Subject: RE: [rt.cpan.org #85177] two problem with activity report
Date: Fri, 10 May 2013 10:57:03 -0600
To: <bug-RT-Extension-ActivityReports [...] rt.cpan.org>
From: "Juan Carlos Lopez" <juan.lopez [...] tdn.com.ni>
Thank you for your fast answer, The entire log is: [Fri May 10 16:42:46 2013] [error]: Error during compilation of /opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/ResolutionComments: Can't locate Time/Duration.pm in @INC (@INC contains: /opt/rt4/sbin/../local/lib /opt/rt4/local/plugins/RT-Extension-ActivityReports/lib /opt/rt4/local/plugins/RT-Extension-JSGantt/lib /opt/rt4/local/plugins/RT-Extension-ResetPassword/lib /opt/rt4/local/plugins/RT-Extension-NotifyOwners/lib /opt/rt4/local/plugins/RT-Extension-RepeatTicket/lib /opt/rt4/local/plugins/RT-Extension-TicketPDF/lib /opt/rt4/sbin/../lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . /etc/apache2) at /opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/ResolutionComments line 31. With the first problem, doesn’t matter what date ranges I select always is showing incorrect statistic number... I clean the database with all the test ticket open it when I was installing the RT, is it possible that in some place in the database are incorrect data? Juan Carlos López Corrales | Ing. Aplicaciones IT. Tecnología de Nicaragua S.A | Km 3 1/2 Carretera Sur, Las Palmas, Gasolinera Uno 1c Norte, | Managua, Nicaragua. Teléfono +505 2268-7530 ext. 213 | Claro +505 89454239 | Movistar +505 89884442 juan.lopez@tdn.com.ni www.tdn.com.ni | www.EmersonNetworkPower.com Este mensaje y cualquier adjunto trasmitido con él, son confidenciales y fueron planeados solo para el destinatario originalmente nombrado. Está estrictamente prohibido revelar, copiar, distribuir o tomar cualquier acción en relación al contenido de esta información. Si tú has recibido éste mensaje producto de un error por favor comunícate con sysadmin@tdn.com.ni o con el remitente original del mensaje. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and/or sysadmin@tdn.com.ni and delete the original. Any other use of the email by you is prohibited. Show quoted text
-----Mensaje original----- De: Thomas Sibley via RT [mailto:bug-RT-Extension-ActivityReports@rt.cpan.org] Enviado el: viernes, 10 de mayo de 2013 10:50 a.m. Para: juan.lopez@tdn.com.ni Asunto: Re: [rt.cpan.org #85177] two problem with activity report <URL: https://rt.cpan.org/Ticket/Display.html?id=85177 > On 05/10/2013 09:42 AM, juan.lopez@tdn.com.ni via RT wrote:
> Problem 1: > > It is not showing the correct statistic, ex: > > I only have 1 new ticket but the activity report say 5 tickets. Etc.
The reports are for a certain time frame (between two dates) and so over those two dates you must have had 5 new tickets.
> Second Problem: > > If I try to use “resolution comments” and “ Resolution statistic” I > received the following error: > > In my log I have the following:
The copy and pasted logs you sent don't contain the actual error messages and instead just has the stacktraces. Please include the full logs, otherwise we can't help.
  Fri May 10 13:13:45 2013 tsibley [...] cpan.org - Status changed from 'open' to 'rejected'
  Fri May 10 13:13:53 2013 tsibley [...] cpan.org - Correspondence added
Subject: Re: [rt.cpan.org #85177] two problem with activity report
Date: Fri, 10 May 2013 10:13:13 -0700
To: bug-RT-Extension-ActivityReports [...] rt.cpan.org
From: Thomas Sibley <tsibley [...] cpan.org>
On 05/10/2013 09:57 AM, juan.lopez@tdn.com.ni via RT wrote: Show quoted text
> The entire log is: > > [Fri May 10 16:42:46 2013] [error]: Error during compilation of > /opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/ResolutionComments: > >
Can't locate Time/Duration.pm in @INC This implies you didn't install the dependencies of the ActivityReports plugin when you installed it. You need to install Time::Duration from CPAN. Show quoted text
> With the first problem, doesn’t matter what date ranges I select > always is showing incorrect statistic number... I clean the database > with all the test ticket open it when I was installing the RT, is it > possible that in some place in the database are incorrect data?
Ah. How did you "clean" the test ticket data? I suspect you did it incorrectly, as RT's database is complicated and not meant to be mangled by hand by someone unfamiliar with it.
  Fri May 10 14:58:45 2013 juan.lopez [...] tdn.com.ni - Correspondence added
Subject: RE: [rt.cpan.org #85177] two problem with activity report
Date: Fri, 10 May 2013 12:57:29 -0600
To: <bug-RT-Extension-ActivityReports [...] rt.cpan.org>
From: "Juan Carlos Lopez" <juan.lopez [...] tdn.com.ni>
Thank you thomas, I install the time::Duration from CPAN and now it is working fine both reports. What is the correct way to erase tickets? Juan Carlos López Corrales | Ing. Aplicaciones IT. Tecnología de Nicaragua S.A | Km 3 1/2 Carretera Sur, Las Palmas, Gasolinera Uno 1c Norte, | Managua, Nicaragua. Teléfono +505 2268-7530 ext. 213 | Claro +505 89454239 | Movistar +505 89884442 juan.lopez@tdn.com.ni www.tdn.com.ni | www.EmersonNetworkPower.com Este mensaje y cualquier adjunto trasmitido con él, son confidenciales y fueron planeados solo para el destinatario originalmente nombrado. Está estrictamente prohibido revelar, copiar, distribuir o tomar cualquier acción en relación al contenido de esta información. Si tú has recibido éste mensaje producto de un error por favor comunícate con sysadmin@tdn.com.ni o con el remitente original del mensaje. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and/or sysadmin@tdn.com.ni and delete the original. Any other use of the email by you is prohibited. Show quoted text
-----Mensaje original----- De: Thomas Sibley via RT [mailto:bug-RT-Extension-ActivityReports@rt.cpan.org] Enviado el: viernes, 10 de mayo de 2013 11:14 a.m. Para: juan.lopez@tdn.com.ni Asunto: Re: [rt.cpan.org #85177] two problem with activity report <URL: https://rt.cpan.org/Ticket/Display.html?id=85177 > On 05/10/2013 09:57 AM, juan.lopez@tdn.com.ni via RT wrote:
> The entire log is: > > [Fri May 10 16:42:46 2013] [error]: Error during compilation of > /opt/rt4/local/plugins/RT-Extension-ActivityReports/html/Reports/Activity/Elements/ResolutionComments: > >
Can't locate Time/Duration.pm in @INC This implies you didn't install the dependencies of the ActivityReports plugin when you installed it. You need to install Time::Duration from CPAN.
> With the first problem, doesn’t matter what date ranges I select > always is showing incorrect statistic number... I clean the database > with all the test ticket open it when I was installing the RT, is it > possible that in some place in the database are incorrect data?
Ah. How did you "clean" the test ticket data? I suspect you did it incorrectly, as RT's database is complicated and not meant to be mangled by hand by someone unfamiliar with it.
  Fri May 10 15:11:42 2013 tsibley [...] cpan.org - Correspondence added
Subject: Re: [rt.cpan.org #85177] two problem with activity report
Date: Fri, 10 May 2013 12:11:09 -0700
To: bug-RT-Extension-ActivityReports [...] rt.cpan.org
From: Thomas Sibley <tsibley [...] cpan.org>
On 05/10/2013 11:58 AM, juan.lopez@tdn.com.ni via RT wrote: Show quoted text
> Thank you thomas, I install the time::Duration from CPAN and now it is working fine both reports. > > What is the correct way to erase tickets?
The Shredder tool for RT is the only safe way to do so. You should run rt-validator to see what errors come up and have it fix those if it can. For further support, please use the rt-users community mailing list. This bug tracker is not appropriate for general purpose RT questions.
  Fri May 10 16:58:54 2013 juan.lopez [...] tdn.com.ni - Correspondence added
Subject: RE: [rt.cpan.org #85177] two problem with activity report
Date: Fri, 10 May 2013 14:58:26 -0600
To: <bug-RT-Extension-ActivityReports [...] rt.cpan.org>
From: "Juan Carlos Lopez" <juan.lopez [...] tdn.com.ni>
Thank you for your excellent help. I appreciate a lot of. Juan Carlos López Corrales | Ing. Aplicaciones IT. Tecnología de Nicaragua S.A | Km 3 1/2 Carretera Sur, Las Palmas, Gasolinera Uno 1c Norte, | Managua, Nicaragua. Teléfono +505 2268-7530 ext. 213 | Claro +505 89454239 | Movistar +505 89884442 juan.lopez@tdn.com.ni www.tdn.com.ni | www.EmersonNetworkPower.com Este mensaje y cualquier adjunto trasmitido con él, son confidenciales y fueron planeados solo para el destinatario originalmente nombrado. Está estrictamente prohibido revelar, copiar, distribuir o tomar cualquier acción en relación al contenido de esta información. Si tú has recibido éste mensaje producto de un error por favor comunícate con sysadmin@tdn.com.ni o con el remitente original del mensaje. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and/or sysadmin@tdn.com.ni and delete the original. Any other use of the email by you is prohibited. Show quoted text
-----Mensaje original----- De: Thomas Sibley via RT [mailto:bug-RT-Extension-ActivityReports@rt.cpan.org] Enviado el: viernes, 10 de mayo de 2013 01:12 p.m. Para: juan.lopez@tdn.com.ni Asunto: Re: [rt.cpan.org #85177] two problem with activity report <URL: https://rt.cpan.org/Ticket/Display.html?id=85177 > On 05/10/2013 11:58 AM, juan.lopez@tdn.com.ni via RT wrote:
> Thank you thomas, I install the time::Duration from CPAN and now it is working fine both reports. > > What is the correct way to erase tickets?
The Shredder tool for RT is the only safe way to do so. You should run rt-validator to see what errors come up and have it fix those if it can. For further support, please use the rt-users community mailing list. This bug tracker is not appropriate for general purpose RT questions.