|
Home > Archive > Voice over IP Cisco > November 2006 > CDRs missing from SQL!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
CDRs missing from SQL!!
|
|
| Anthony Kouloglou 2006-11-13, 8:09 am |
| Hi,
today i discovered that cdr records are missing from the sql!!
1.Records exist in c:\Program Files\Cisco\CallDetail (really what are
these for?)
2.In Enterprise Parameters it is checked "CDRs will be inserted in the
database"
3. I make an sql query and i get values till 17th of October only.
Don't ask about CAR tool!!
1. It does not work (I get an apache http error message when i try to
access it via IE)
2. Even if it did work, i wouldn't use it.
Thanks Anthony
| |
| Ryan Ratliff 2006-11-13, 8:10 am |
| Is the InsertCDR service running?
-Ryan
On Nov 9, 2006, at 3:39 AM, Anthony Kouloglou wrote:
Hi,
today i discovered that cdr records are missing from the sql!!
1.Records exist in c:\Program Files\Cisco\CallDetail (really what are
these for?)
2.In Enterprise Parameters it is checked "CDRs will be inserted in the
database"
3. I make an sql query and i get values till 17th of October only.
Don't ask about CAR tool!!
1. It does not work (I get an apache http error message when i try to
access it via IE)
2. Even if it did work, i wouldn't use it.
Thanks Anthony
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Anthony Kouloglou 2006-11-13, 8:10 am |
| Thanks a lot Erick for the briefing.
Yes the cdr insert service is running.
I just restarted it and all the cdrs were inserted in the database!!
From 17th of october, there was no error in the event viewer and
because the service was
running, i didn't thing to restart it!!Besides, the server has reboot at
least 2 times from then and the service kept saying that it is running!!
Cheers
Erick Bergquist wrote:
> Is the CDR Insert service started and running -- on the publisher usually. This service is what processes the records in the flat files in the \program files\cisco\calldetail\cdr folder and puts them in the CDR SQL Database.
>
> If the CDR Insert service is started, check to see if CDR database exists on that server and if there are any errors in the event viewer application log.
>
> If the cdr flat files are just collecting in the \program files\cisco\calldetail\cdr folder and not being moved to the bad folder then the CDR service (if started) may be hung and need to restarted.
>
> Each CCM server creates the CDR records in a CSV file. Under CCM Service Parameters for each node in the cluster, there is a CDR Enabled flag. Check to see if this is set to TRUE on the servers you want to do CDR (usually all of the servers).
>
> ----- Original Message ----
> From: Anthony Kouloglou <akoul@dataways.gr>
> To: "cisco-voip@puck-nether.net" <cisco-voip@puck.nether.net>
> Sent: Thursday, November 9, 2006 2:39:00 AM
> Subject: [cisco-voip] CDRs missing from SQL!!
>
> Hi,
> today i discovered that cdr records are missing from the sql!!
> 1.Records exist in c:\Program Files\Cisco\CallDetail (really what are
> these for?)
> 2.In Enterprise Parameters it is checked "CDRs will be inserted in the
> database"
> 3. I make an sql query and i get values till 17th of October only.
>
> Don't ask about CAR tool!!
> 1. It does not work (I get an apache http error message when i try to
> access it via IE)
> 2. Even if it did work, i wouldn't use it.
>
> Thanks Anthony
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
>
>
>
>
| |
| Erick Bergquist 2006-11-13, 8:10 am |
| Is the CDR Insert service started and running -- on the publisher usually. This service is what processes the records in the flat files in the \program files\cisco\calldetail\cdr folder and puts them in the CDR SQL Database.
If the CDR Insert service is started, check to see if CDR database exists on that server and if there are any errors in the event viewer application log.
If the cdr flat files are just collecting in the \program files\cisco\calldetail\cdr folder and not being moved to the bad folder then the CDR service (if started) may be hung and need to restarted.
Each CCM server creates the CDR records in a CSV file. Under CCM Service Parameters for each node in the cluster, there is a CDR Enabled flag. Check to see if this is set to TRUE on the servers you want to do CDR (usually all of the servers).
----- Original Message ----
From: Anthony Kouloglou <akoul@dataways.gr>
To: "cisco-voip@puck-nether.net" <cisco-voip@puck.nether.net>
Sent: Thursday, November 9, 2006 2:39:00 AM
Subject: [cisco-voip] CDRs missing from SQL!!
Hi,
today i discovered that cdr records are missing from the sql!!
1.Records exist in c:\Program Files\Cisco\CallDetail (really what are
these for?)
2.In Enterprise Parameters it is checked "CDRs will be inserted in the
database"
3. I make an sql query and i get values till 17th of October only.
Don't ask about CAR tool!!
1. It does not work (I get an apache http error message when i try to
access it via IE)
2. Even if it did work, i wouldn't use it.
Thanks Anthony
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
|
|
|
|
|