<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>Thanks Wes. <br><br>As per my follow up message, do you think I should start the "Cisco CDR Analysis and Reporting Scheduler" service under CAR > System > Control Centre first and see if that fixes things or go through the process as outlined in the doc you sent me?<br><br>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>"Bad grammar makes me [sic]" - Tshirt<br><br><br>----- Original Message -----<br>From: "Wes Sisk" <wsisk@cisco.com><br>To: "Lelio Fulgenzi" <lelio@uoguelph.ca><br>Cc: "cisco-voip voyp list" <cisco-voip@puck.nether.net><br>Sent: Tuesday, September 29, 2009 3:05:17 PM GMT -05:00 US/Canada Eastern<br>Subject: Re: [cisco-voip] missing CAR data...why?<br><br>
<link href="/zimbra/css/msgview.css?v=081117021119" rel="stylesheet">
So most likely CDR has older data but CAR is not loading that older
data because it thinks that data is already loaded. Probably best bet
is purge all CAR, reset the load date(combination of tbl_load_history
and art..tbl_system_preferences.paramname=MIN_DATE), and let it all
reload.<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a008056bd4e.shtml" target="_blank">http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a008056bd4e.shtml</a><br>
<br>
/Wes<br>
<br>
On Tuesday, September 29, 2009 2:50:45 PM, Lelio Fulgenzi
<a class="moz-txt-link-rfc2396E" href="mailto:lelio@uoguelph.ca" target="_blank"><lelio@uoguelph.ca></a> wrote:<br>
<blockquote cite="mid:919724039.9413661254250245828.JavaMail.root@simcoe.cs.uoguelph.ca">
<style>p { margin: 0; }</style>
<div style="font-family: Verdana; font-size: 10pt; color: rgb(0, 0, 0);">Sorry
- CCM v4.1(3)sr7<br>
<br>
from SQL: CAR has data as far back as Jun 17 2009 as the error suggests.<br>
from SQL: CDR has data as far back as Sep 9 2009<br>
<br>
---<br>
Lelio Fulgenzi, B.A.<br>
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>
"Bad grammar makes me [sic]" - Tshirt<br>
<br>
<br>
----- Original Message -----<br>
From: "Wes Sisk" <a class="moz-txt-link-rfc2396E" href="mailto:wsisk@cisco.com" target="_blank"><wsisk@cisco.com></a><br>
To: "Lelio Fulgenzi" <a class="moz-txt-link-rfc2396E" href="mailto:lelio@uoguelph.ca" target="_blank"><lelio@uoguelph.ca></a><br>
Cc: "cisco-voip voyp list" <a class="moz-txt-link-rfc2396E" href="mailto:cisco-voip@puck.nether.net" target="_blank"><cisco-voip@puck.nether.net></a><br>
Sent: Tuesday, September 29, 2009 2:35:56 PM GMT -05:00 US/Canada
Eastern<br>
Subject: Re: [cisco-voip] missing CAR data...why?<br>
<br>
What CM version?<br>
<br>
what is the oldest record available in the CDR database?<br>
what is the oldest record available in the CAR database?<br>
<br>
/Wes<br>
<br>
On Tuesday, September 29, 2009 2:17:02 PM, Lelio Fulgenzi
<a class="moz-txt-link-rfc2396E" href="mailto:lelio@uoguelph.ca" target="_blank"><lelio@uoguelph.ca></a>
wrote:<br>
<blockquote cite="mid:1268874862.9395221254248222819.JavaMail.root@simcoe.cs.uoguelph.ca">
<style>p { margin: 0; }</style>
<div style="font-family: Verdana; font-size: 10pt; color: rgb(0, 0, 0);">For
some reason, it looks like we're missing CAR data. I'm pretty sure we
have CDR data because I can do searches. But when I do anything from
the CAR menu, I get:<br>
<br>
<div style="margin-left: 40px;">
<hr style="width: 100%; height: 2px;">30023: Data is not available
for the date range selected. Data is only available from Jun 17, 2009
to Sep 1, 2009.<br>
<hr style="width: 100%; height: 2px;"></div>
<br>
A colleague of mine ran a manual purge sometime early August, but he's
done that many times and even then, he always uses the "older than"
option and selects something from a few months back.<br>
<br>
Any way to check what's going on? I checked the event viewer for Sept 1
and 2 and couldn't see anything.<br>
<br>
---<br>
Lelio Fulgenzi, B.A.<br>
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>
"Bad grammar makes me [sic]" - Tshirt<br>
<br>
</div>
<pre><hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
<br>
</div></body></html>