cdr stopped

[malel2015]

Hi,

Cdr stopped and return no record 

(

10021

There are no matching record

),Last record shows  old date . I believe when scheduled backup also failed on the same date ,or when backup failed CDR also failed .

Now how can I  see the call records again ?

Thanks  

[Jaime Valencia · Accepted solution]

Have you tried restarting the CDR/CAR related services?

Are all the service parameters configured to enable CDR?

[malel2015]

Hi

Have you tried restarting the CDR/CAR related services?

It would be really helpful if you mention the  services 

Are all the service parameters configured to enable CDR?

yes 

It was working till few days back 

Thanks 

[Ratheesh Kumar · Accepted solution]

You can restart these services in all your nodes, in the following order 

Cisco Database Layer Monitor as well

Cisco CDR Repository Manager
Cisco CDR Agent
Cisco CAR Scheduler
Cisco SOAP - CallRecord Service
Cisco CAR DB

Wait for at least an hour and then run the CAR 

Hope this helps!

Cheers
Rath!

***Please rate helpful posts***

[malel2015]

hI,

Thanks for the reply .

Cisco database layer monitor needed to start first or last ? 

Thanks again 

[Ratheesh Kumar]

You can start that first then the other CDR services

Hope this helps!

Cheers
Rath!

***Please rate helpful posts***

[malel2015]

Hi,

Thanks for the reply . Cisco car db must be start from GUI ,

Is there any specific reason , any interruption will happen ? 

It would be great if you  give me the command 

Second thing  you asked me to run the 'CAR ' , again .

What does it mean 

Thanks

[Ratheesh Kumar]

Hi there
You can restart Cisco Database Layer Monitor either from GUI or CLI.
For CLI you can SSH to CUCM and issue the below command
admin:utils service restart Cisco Database Layer Monitor
Restarting the Cisco DBL service will not reset any phones or devices. It just reloads the database cache and forces the CallManager service to get a fresh copy of the database.

You need to wait for at least an hour and then run the CAR report
*For CAR system administrators only-From Cisco Unified Serviceability, choose Tools > CDR Analysis and Reporting.
*For CAR users or administrators-From the web browser, enter https://:8443/car/


Hope this Helps
Cheers
Rath!

***Please rate helpful posts***

[erniegurule]

Thanks for adding this tip!

[bwolf]

Is it safe to restart Cisco CAR scheduler during business hours, or should it be done after hours?  Will it affect calls in progress?

thanks

[Clifford McGlamry]

On CUCM 14, trying to restart the CAR DB via GUI tells you you must restart via CLI.  However, the CAR DB service IS NOT PRESENT via the CLI on version 14 or my lab box on 11.5:

[Ratheesh Kumar]

Following Java's suggestion below is the 2 solutions from the tech notes (same across all CUCM versions)

https://www.cisco.com/c/en/us/support/docs/voice-unified-communications/unified-communications-manager-version-50/100465-cdr-cmr-error.html#Problem2

Error Code 10021

When an attempt is made to access CDR Search and CDR report from CDR Analysis and Reporting (CAR) on Cisco Unified Communications Manager (CallManager) 5.X, this error message appears: Error Code 10021 There is no matching records.

Similarly, when an attempt is made to collect data, CAR is not able to collect data and this error message appears: 30023: Data is not available for the date range selected.

Solution 1

1. This error can occur when the Disable CDR loader check box is checked in CAR. Choose System > Scheduler > CDR Load, and uncheck the Disable Loader check box in order to resolve the issue.

2. Choose System > Service Parameters, and click the Advanced button in order to display the list of Service Parameters. Make sure that the CDR Enabled Flag is set to True.

Solution 2

Complete the steps mentioned in the Solution for the Error Code 10012.

If these solutions do not solve the issue, contact the Cisco Technical Assistance Center (TAC).

Complete these steps:

1. Reset the MAX_CDR_NUMBER to a default of two million. Run this query from CLI:

   admin: run sql update car:tbl_system_preferences set
   		param_value='2000000' where param_name='MAX_CDR_NUMBER'.

2. Choose System > Scheduler > CDR Load. Select Disable Loader, and click the Update button in order to disable the CAR loader.

   Note: CDR data does not load into CAR until you enable CDR loading. Changes take effect at midnight. In order to force the change to take effect immediately, stop and restart the CAR Scheduler service.

3. Re-enable it, uncheck the Disable Loader check box. Check the Continuous Loading 24/7 check box, and click the Update button.

4. In order for the changes to take effect immediately, stop and restart the CAR Scheduler service.

Hope this helps!

Cheers
Rath!

***Please rate helpful posts***