<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
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:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoPlainText">Good morning need help quickly please<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Came in this morning and all the Quick search are not showing any data.<o:p></o:p></p>
<p class="MsoPlainText"><img width="387" height="394" id="Picture_x0020_1" src="cid:image001.png@01CF4D8A.F8E33860"><o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">If I click anywhere in the quick search box the searches are working meaning I get a list of tickets.<o:p></o:p></p>
<p class="MsoPlainText">This is also happening on all of the Quick searches I have defined.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">I also look in the var directory and found a lot of directories see below.<o:p></o:p></p>
<p class="MsoPlainText"><img width="159" height="718" id="Picture_x0020_2" src="cid:image002.png@01CF4D8B.1F6B43B0"><o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">This is just a small list.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Here is a part of the RT log after a restart which does not look normal.<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">[26474] [Tue Apr 1 14:11:25 2014] [warning]: RT::Handle=HASH(0x8a1a460) couldn't execute the query 'SELECT main.Status AS status, main.Queue AS queue, COUNT(DISTINCT main.id) AS
id FROM Tickets main WHERE (main.IsMerged IS NULL) AND (main.Status != 'deleted') AND (main.Type = 'ticket') AND ( ( main.Status = 'new' OR main.Status = 'assigned' OR main.Status = 'opened' OR main.Status = 'evaluation' OR main.Status = 'closed' ) AND
( main.Queue = '15' OR main.Queue = '16' OR main.Queue = '21' OR main.Queue = '17' OR main.Queue = '10' OR main.Queue = '18' OR main.Queue = '19' OR main.Queue = '25' OR main.Queue = '20' OR main.Queue = '12' OR main.Queue = '4' OR main.Queue = '14' OR main.Queue
= '13' ) ) GROUP BY main.Status, main.Queue ' at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder/Handle.pm line 602.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x8a1a460)', 'SELECT main.Status AS status, main.Queue AS queue, COUNT(DIST...') called at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder.pm
line 239<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> DBIx::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 990<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> RT::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 2374<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> RT::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/Report/Tickets.pm line 563<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> RT::Report::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder.pm line 507<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> DBIx::SearchBuilder::Next('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/Report/Tickets.pm line 603<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> RT::Report::Tickets::Next('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/share/html/Elements/QueueSummaryByLifecycle line 157<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Commands::__ANON__('queue_filter', 'CODE(0x8f91d90)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8fed3c8)', 'queue_filter', 'CODE(0x8f91d90)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm
line 1305<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::comp(undef, undef, 'queue_filter', 'CODE(0x8f91d90)') called at /opt/rt4/share/html/Elements/Quicksearch line 58<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1383<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1383<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::content('RT::Interface::Web::Request=HASH(0x8920180)') called at /opt/rt4/share/html/Widgets/TitleBox line 56<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Commands::__ANON__('title', 'Quick search', 'bodyclass', '', 'titleright', 'Edit', 'titleright_href', '/rt/Prefs/Quicksearch.html') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm
line 138<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8e56f88)', 'title', 'Quick search', 'bodyclass', '', 'titleright', 'Edit', 'titleright_href', '/rt/Prefs/Quicksearch.html',
...) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::comp(undef, undef, undef, 'title', 'Quick search', 'bodyclass', '', 'titleright', 'Edit', ...) called at /opt/rt4/share/html/Elements/Quicksearch line
58<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x1af9bc8)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::comp(undef, undef) called at /opt/rt4/share/html/Elements/MyRT line 97<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Commands::__ANON__('HASH(0x8ac8308)') called at /opt/rt4/share/html/Elements/MyRT line 58<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8dddd90)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::comp(undef, undef) called at /opt/rt4/share/html/index.html line 78<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8a3b558)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::comp(undef, undef, undef) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 680<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> RT::Interface::Web::ShowRequestedPage('HASH(0x8b1ab60)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 368<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> RT::Interface::Web::HandleRequest('HASH(0x8b1ab60)') called at /opt/rt4/share/html/autohandler line 53<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8a5b958)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1300<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 484<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 484<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 436<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x8920180)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 96<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 96<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x8920180)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Interp.pm line 345<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::Interp::exec(undef, undef) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 59<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 59<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x89a7018)', 'HASH(0x8a6fcc8)', 'HASH(0x8a6fd40)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler/Streamy.pm
line 52<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x8ac9c20)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 307<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> RT::Interface::Web::Handler::__ANON__('CODE(0x8ac9c20)') called at /usr/lib/perl5/site_perl/5.16.2/Plack/Util.pm line 301<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> Plack::Util::__ANON__('CODE(0x8bc0648)') called at /usr/lib/perl5/site_perl/5.16.2/Plack/Handler/FCGI.pm line 136<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x89d5e70)', 'CODE(0x89c7868)') called at /usr/lib/perl5/site_perl/5.16.2/Plack/Loader.pm line 84<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> Plack::Loader::run('Plack::Loader=HASH(0x89c7550)', 'Plack::Handler::FCGI=HASH(0x89d5e70)') called at /usr/lib/perl5/site_perl/5.16.2/Plack/Runner.pm line 277<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> Plack::Runner::run('RT::PlackRunner=HASH(0x85ff8b0)') called at /opt/rt4/sbin/../lib/RT/PlackRunner.pm line 141<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> eval {...} called at /opt/rt4/sbin/../lib/RT/PlackRunner.pm line 141<o:p></o:p></span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">I have not rebooted the server yet but at this point that is next.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Thanks<o:p></o:p></p>
<p class="MsoPlainText">Bryon Baker<o:p></o:p></p>
<p class="MsoPlainText">Network Operations Manager<o:p></o:p></p>
<p class="MsoPlainText">Copesan - Specialists in Pest Solutions<o:p></o:p></p>
<p class="MsoPlainText">800-267-3726 • 262-783-6261 ext. 2296<o:p></o:p></p>
<p class="MsoPlainText">bbaker@copesan.com<o:p></o:p></p>
<p class="MsoPlainText">www.copesan.com<o:p></o:p></p>
<p class="MsoPlainText">"Servicing North America with Local Care" <o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
</div>
</body>
</html>