CDR Date problem

[luzhenning]

Hi all:

I have encounted a CDR Date problem.There are 2 CCM 4.0.2,one PUB,one SUB,all IP Phone register to SUB.One day,customer told me that when he used CDR,the CDR only can have record from 27/10/2004 to 27/03/2005.So I purge old file to 23/04/2005,and change to max CDR record,restart the PUB,all is OK,the CDR begin to record.

But customer told me that the CDR only can report data from 23/04/2005 to 25/04/2005.It is very strange.and I find that the C:\program files\Cisco\CDR has lots of file,so I change the inter insert time from 1 Min to 60 Min.and there is no file on that folder.But the report can only report that range.

So can anybody reslove the problem?thanks

[irisrios]

Perform these steps to determine if you have any record in the Structured Query Language (SQL) database:

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

Select Publisher Server > Databases.

Select CDR > Tables. Right click on the CallDetailRecord table.

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

If you see many records, perform this procedure to remove records from ART:

Go to Programs > SQL Server > Query Analyzer. Log in and select 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 during the next scheduled loading time. By default, CDR data is loaded every day from midnight to 5 a.m.