[cisco-voip] missing CAR data...why?

[Lelio Fulgenzi]

Thanks Wes. 

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? 

--- 
Lelio Fulgenzi, B.A. 
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1 
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
"Bad grammar makes me [sic]" - Tshirt 


----- Original Message ----- 
From: "Wes Sisk" <wsisk at cisco.com> 
To: "Lelio Fulgenzi" <lelio at uoguelph.ca> 
Cc: "cisco-voip voyp list" <cisco-voip at puck.nether.net> 
Sent: Tuesday, September 29, 2009 3:05:17 PM GMT -05:00 US/Canada Eastern 
Subject: Re: [cisco-voip] missing CAR data...why? 

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. 

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a008056bd4e.shtml 

/Wes 

On Tuesday, September 29, 2009 2:50:45 PM, Lelio Fulgenzi <lelio at uoguelph.ca> wrote: 



Sorry - CCM v4.1(3)sr7 

from SQL: CAR has data as far back as Jun 17 2009 as the error suggests. 
from SQL: CDR has data as far back as Sep 9 2009 

--- 
Lelio Fulgenzi, B.A. 
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1 
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
"Bad grammar makes me [sic]" - Tshirt 


----- Original Message ----- 
From: "Wes Sisk" <wsisk at cisco.com> 
To: "Lelio Fulgenzi" <lelio at uoguelph.ca> 
Cc: "cisco-voip voyp list" <cisco-voip at puck.nether.net> 
Sent: Tuesday, September 29, 2009 2:35:56 PM GMT -05:00 US/Canada Eastern 
Subject: Re: [cisco-voip] missing CAR data...why? 

What CM version? 

what is the oldest record available in the CDR database? 
what is the oldest record available in the CAR database? 

/Wes 

On Tuesday, September 29, 2009 2:17:02 PM, Lelio Fulgenzi <lelio at uoguelph.ca> wrote: 



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: 



30023: Data is not available for the date range selected. Data is only available from Jun 17, 2009 to Sep 1, 2009. 


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. 

Any way to check what's going on? I checked the event viewer for Sept 1 and 2 and couldn't see anything. 

--- 
Lelio Fulgenzi, B.A. 
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1 
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
"Bad grammar makes me [sic]" - Tshirt 


_______________________________________________
cisco-voip mailing list cisco-voip at puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090929/47a2ff4c/attachment.html>