<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
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">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"><lelio@uoguelph.ca></a> wrote:<br>
<blockquote
cite="mid:919724039.9413661254250245828.JavaMail.root@simcoe.cs.uoguelph.ca"
type="cite">
<style type="text/css">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"><wsisk@cisco.com></a><br>
To: "Lelio Fulgenzi" <a class="moz-txt-link-rfc2396E" href="mailto:lelio@uoguelph.ca"><lelio@uoguelph.ca></a><br>
Cc: "cisco-voip voyp list" <a class="moz-txt-link-rfc2396E" href="mailto:cisco-voip@puck.nether.net"><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>
<link href="/zimbra/css/msgview.css?v=081117021119" rel="stylesheet">
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 moz-do-not-send="true" 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 moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>
<a moz-do-not-send="true" 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>
</body>
</html>