Figure out what day CDRs started to go bad. Delete all CDR records for days that you suspect CDRs were lost. You will need to delete records from the following database tables:
The following SQL commands can be used for deleting records generated between two time stamps. Use the DateTimeStamp column for the ICDR table and O_DateTimeStamp for the other tables.
sql>delete from ICDR where DateTimeStamp >= '2011-01-24 00:00:00' AND DateTimeStamp <= '2011-02-09 23:59:59'; sql>commit;
sql>delete from RatedCDR where O_DateTimeStamp >= '2011-01-24 00:00:00' sql>AND O_DateTimeStamp <= '2011-02-09 23:59:59'; sql>commit;
Deleting records may take a long time. An alternative might be to delete all records (using the SQL ‘truncate TableName’ command) and then reprocess all records starting from a particular date.