Purge CAR Database
This section describes how to manually purge selected records from the CAR database and how to delete all of the CAR data and reload the database with new CDR data. You may want to reload the database to reclassify calls after dial-plan updates, user-device association changes, call rate changes, and so on.
Before you begin to manually purge data, disable the CDR Loader.
-
Choose
. -
Chosse either of the following:
-
Disable Loader - check the Disable Loader check box and click the Update.
Enable CDR loading to load the data into CAR. Changes take effect at midnight. You can force the change to take effect immediately by stopping and restarting the CAR Scheduler service.
-
Enable Loader - uncheck the Disable Loader check box.
-
Manual purging of the CDRs gets stopped if the CAR Web Service is stopped during the manual purge process. Manual purging cannot begin again until the CAR Web Service restarts. Then you must begin the manual purge process again.
There are two ways to intentionally stop the CAR Web Service:
-
Deactivate the CAR Web Service in the Serviceability Service Activation window (
). -
Stop the CAR Web Service in the Feature Services window of the Serviceability Control Center (
).
The CDR Loader cannot begin again until either the CAR Web Service or the CAR Scheduler gets restarted.
A CAR administrator can no longer generate CAR reports when a manual purge of the CAR database is in process or CDR records are reloading. The following error message displays when you try to run reports during these processes:
10023: Manual Purge/Reload is in process. Please run the reports once the Manual Purge/Reload is over.
Both the Purge button and the Reload All Call Detail Records button get disabled, and the following alert message displays on the Manual Purge window, when either a manual purge or CDR reload occurs:
Manual Purge/Reload is still running. User will not be allowed to run another instance of Manual Purge/Reload. So, both Purge and Reload All Call Detail Records buttons are disabled.
Procedure
Step 1 |
Choose .The Manual Database Purge window displays. |
||||||||||||||||||||
Step 2 |
Choose one of the following actions: |
||||||||||||||||||||
Step 3 |
In the Select Table field, choose the table in the database that you want purged. To view the tables for which manual purge is permitted, the total number of records in the table, and the latest record and oldest record in the table, click the Table Information button. The Table Information window displays. You will see a table with the following information:
To return to the Manual Database Purge window, click the Close button. |
||||||||||||||||||||
Step 4 |
In the Delete records field, choose a date that will determine which records will be purged by clicking one of the following radio buttons:
|
||||||||||||||||||||
Step 5 |
Choose the date range of the CAR records that you want to delete. |
||||||||||||||||||||
Step 6 |
To delete all records older than or between the dates that you specified, click the Purge button. A prompt advises you that you are about to permanently delete the specified records. |
||||||||||||||||||||
Step 7 |
To purge the records, click the OK button or click the Cancel button to abort the purge operation. If you click OK, the records get purged from the selected table. After successful deletion of records, the status message shows the number of records that were deleted from the table. |