CDR Report Generate Prob. in CCM 5.1

cisco.madhab · ‎09-30-2008

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

Madhab

bwilmoth · ‎10-07-2008

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:

cisco.madhab · ‎11-12-2008

Dear bwilmoth

Thank you very much for help

thanks again

Madhab