[cisco-voip] Cisco CAR

Wes Sisk wsisk at cisco.com
Mon Jan 15 18:13:34 EST 2007


CAR only loads records from its install date forward.  Reset the  
install date, then purge your art tables.

In SQL in the art database in the table tbl_system_preferences.

To force reload of all data:
truncate table Tbl_Load_History
truncate table Tbl_Dump_Pkid
truncate table Tbl_Error_Id_Map
truncate table Tbl_Billing_Data
truncate table Tbl_Billing_Error
truncate table Tbl_Dump_CallDetailRecord
truncate table Tbl_Dump_CallDetailRecordDiagnostic

then restart the CAR scheduler service.

/Wes

On Jan 15, 2007, at 2:00 PM, Israel Lang wrote:

I did an upgrade of CM over the holiday break, but forgot to install  
CAR until a few weeks afterwards. In looking at the CDRs I see them  
going a ways back, but when I run a report it only gives me the  
option of reporting on dates since install of CAR forward. Is there a  
way to get those other records imported?

-- 
Have a great day!!!!!!!!!!
zephy316_gmail.com

Replace the _ with an @ symbol
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip



More information about the cisco-voip mailing list