<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Since upgrading from RT 3.5 to 3.6.3 I’ve been having
problems with some of the Statistics reports. </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The major problem is that two of the reports don’t
appear when invoked. The chart box is blank. The reports are “</span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Tickets by
status per day”, “Time to Resolve tickets by Queue”. </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>A minor problem is that I’m getting an error: </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana;font-weight:bold'>error:</span></font></b><font size=1
face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>Undefined subroutine &POSIX::strftime called at /opt/rt3/local/lib/RTx/Statistics.pm
line 94.</span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana;font-weight:bold'>context:</span></font></b><font size=1
face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>...</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>90:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>=cut</span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>91:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>sub FormatDate {</span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>92:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>my $fmt = shift;</span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>93:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>my $self = shift;</span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>94:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 color=red face=Verdana><span
style='font-size:7.5pt;font-family:Verdana;color:red'>return
POSIX::strftime($fmt, localtime($self->Unix));</span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>95:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>}</span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>96:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>97:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>98:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>=head2 RTDateSetToLocalMidnight</span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>...</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana;font-weight:bold'>code stack:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font></p>
</td>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>/opt/rt3/local/lib/RTx/Statistics.pm:94<br>
/opt/rt3/share/html/RTx/Statistics/CallsQueueDay/index.html:267<br>
/opt/rt3/share/html/autohandler:292</span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I thought this just meant that the code assumed that Perl
Posix was available and RT no longer loaded it. I inserted a </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>use POSIX; </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>statement and the error disappeared. </span></font></p>
</div>
</body>
</html>