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

[Wes Sisk]

yes, starting loader is best first step. see how it runs tonight.

On Tuesday, September 29, 2009 3:43:13 PM, Lelio Fulgenzi 
<lelio at uoguelph.ca> wrote:
> 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/752bec27/attachment.html>