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.