02-13-2007 08:19 AM - edited 03-14-2019 08:00 PM
Getting the following error when trying to run reports in CAR.
30025 : Data is available only upto Feb 12, 2007. Do you want to generate the report?
I have deleted the information in the ART database to force it to repopulate from the CDR database. CDR information is there as of Feb 13th. Any ideas?
02-13-2007 08:43 AM
02-13-2007 12:51 PM
>>>Verify that "Cisco CDR Insert" and "Cisco CDR Analysis and Reporting Scheduler" services are running ONLY in the Publisher Call Manager:
In your publisher callmanager server, go to start > programs > administration tools > services > verify the status for services "Cisco CDR Insert" and "Cisco CDR Analysis and Reporting Scheduler". If they are not "started", please restart them (just right-click on the service and select "restart").
If "Cisco CDR Insert" and "Cisco CDR Analysis and Reporting Scheduler" (or ART scheduler depending on the CCM version) are running also in the subscriber servers, please stop them.
-------------------
>>>Verify service parameters in callmanager servers (publisher and subscriber).
--go to ccm admin > service > service parameters > select a callmanager server from the drop-down list > at "service" please select "Cisco CallManager" > click on "advanced" > verify that the following parameters are set to the correct values:
CDR Enabled Flag = True
CDR Log Calls with Zero Duration Flag = True
Call Diagnostics Enabled = True
***Repeat the same procedure for all callmanager servers in your cluster***
--Now go to ccm admin > service > service parameters > select a callmanager server from the drop-down list > at "service" please select "Cisco Data Base Layer Monitor" > verify that the following parameter is set to the correct value:
Max CDR Records = 1500000
***Repeat the same procedure for all callmanager servers in your cluster***
--Now go to ccm admin > system > enterprise parameters > verify that the following parameters are set to the correct values:
CDR File Time Interval (min) = 1
CDR Format = CDRs will be inserted into database
CDR UNC Path = \\
Local CDR Path = C:\Program Files\Cisco\CallDetail
***Repeat the same procedure for all callmanager servers in your cluster***
-------------------
>>>Please go to start > programs > administration tools > services and restart the following services:
1) Restart service "Cisco database Layer Monitor" on publisher and subscriber servers.
2) Restart service "Cisco CDR Insert" on the publisher server.
3) Restart service "Cisco CDR Analysis and Reporting Scheduler" (or ART scheduler) on the publisher server.
-------------------
>>>Run SQL querys:
In your publisher server, go to start > programs > SQL Server > Query Analyzer > SQL Server: (local) ; Select "windows authentication"; click on "OK" > select the "ART" database from the drop-down menu. Run the following queries (just copy and paste the following in the main window, then click on the "execute query" icon):
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
Login into the CAR tool > go to the "system" menu > scheduler > CDR Load > Load CDR & CMR and change the load time to 30 min
Restart the services again.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide