Cisco Unified CallManager CAR Scheduler service issue

Unanswered Question
Nov 12th, 2008

When trying to run reports in CDR Analysis and Reporting we will often get the error "30023:Data is not available for the date range selected...". Each time it turns out that the Cisco Unified CallManager CAR Scheduler service has stopped and we have to manually restart it. It usually only runs for a few days at a time before stopping again. Any ideas?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
jbayuka Tue, 11/18/2008 - 15:03

This error can occur if ART does not get the CDR data to report.

In order to determine if there are any records in the Structured Query Language (SQL) database, complete these steps:

Choose Start > Programs > SQL > Enterprise Manager > Microsoft SQL Servers > SQL Server Group.

Choose Publisher Server > Databases.

Choose CDR > Tables. Right-click the CallDetailRecord table.

Choose Open Table > Return All Rows. Determine if there are any records.

If many records appear, complete this procedure to remove records from ART:

Choose Programs > SQL Server > Query Analyzer. Log in and choose ART database.

Run these queries:

delete from Tbl_Load_History

delete from Tbl_Dump_PkID

delete from Tbl_Error_Id_Map

delete from Tbl_Billing_Data

delete from Tbl_Billing_Error

delete from Tbl_Dump_CallDetailRecord

delete from Tbl_Dump_CallDetailRecordDiagnostic

This forces ART to get all the old CDRs into ART in the next scheduled loading time. By default, CDR data is loaded every day from midnight to 5 a.m.

Restart the CDR Insert and DBL Monitor Services from CCM Administration > Application >Cisco CCM Serviceability >Tools > Control Center.

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_qanda_item09186a008020650a.shtml#qa2

Actions

This Discussion