Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 
New Member

CDR Report Generate Prob. in CCM 5.1

Dear all,

I am using CCM5.1. I am generating the Call Report daily through CDR Management.

But Last two days I could not generate the Call Report. Bcz. When I am going to generate the report..It s showing a Meesage Like Below

" Data is not available for selected range.Data is availabe only for Aug'03 to Sep, 26.2008

When We are assigned following Description in CDR Database:

Used CAR database space: 7.53 %

Maximum CAR database space: 6075.76171875 Mega Bytes

LWM and HWM apply only when CAR Purge is enabled

Low Water Mark 65 70 75 80 85 %

High Water Mark 70 75 80 85 90 %

Min Age of Call Detail Records * 30 Day(s)

Max Age of Call Detail Records * 60 Day(

So Plz Help me as soon as possible to resolve this problem

I am waiting for your quick reply.

Thanks And Regards



Re: CDR Report Generate Prob. in CCM 5.1

You may try the following steps:

TroubleShooting Steps:

1) Restart service "Cisco database Layer Monitor" on publisher and subscriber servers.

2) Restart service "Cisco CDR Insert" on the publisher server.

3) Restart service "Cisco CDR Analysis and Reporting Scheduler" on the publisher server.

Go to Programs -> SQL Server -> Query Analyzer. Login and select ART database. Run

the following 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

The following URL helps to know more information about CAR reports:

New Member

Re: CDR Report Generate Prob. in CCM 5.1

Dear bwilmoth

Thank you very much for help

thanks again


CreatePlease to create content