05-02-2006 04:34 PM - edited 03-13-2019 01:08 PM
HI
I am getting an error
"30023: Data is not available for the date range selected. Data is available only from Dec 25, 2005 to Jan 13, 2006."
I need recent CDR logs and have a Pub/Sub cluster. I already checked the following on both Pub/sub:
CDR Enabled Flag = True
CDR Log Calls w/Zero Duration Flag = True
Enterprise parameters is also set up correctly
Thx
05-02-2006 05:01 PM
Which report|option you are using in CAR?
CDR insert service only in the PUB?
Please restart the following services (after hours):
1) Restart service "Cisco CDR Insert" on the publisher server.
2) Restart service "Cisco CDR Analysis and Reporting Scheduler" on the publisher server.
Go to Programs -> SQL Server -> Query Analyzer. Login and select ART database. Run
the following 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 will force ART to get all the old CDR into ART during the next scheduled loading time
(By default, CDR data is loaded every day from midnight to 5 am).
Can you Set the "Load CDR & CMR time duration" to 60 minutes to check.
HTH
//G
05-03-2006 02:49 AM
Pls reconfigurate the parameter "From Date*" and then u will resolved the problem.Good luck.
05-03-2006 04:37 AM
CDR Insert Service shold be enabled on Publisher only. You should disable it on the Subscriber.
Subscriber servers have no CDR database, and if you activate it on the Subscriber and ignore warnings, then all your CDR records on that Subscriber will go to the black hole - it will think, that it can handle CDR records itself, but there is no database to store it.
Another thing you should check - if your Service Parameters are configured for CDR.
On the CallManager, go Service --> Service Parameters. Select your CallManagers one by one starting from the Publisher, and select "Cisco CallManager" in the Services drop-down menu. Scroll down to "CDR Enable Flag". The parameter value should be True. If not, change it to True, and click "Update button at top of the page. Do it with all your servers.
Good luck,
Mike
----
05-03-2006 06:25 AM
Hi Anthony,
I agree with Gonz (as usual!) in that we recently had the exact same problem you are describing. The fix for us was;
Restart service "Cisco CDR Analysis and Reporting Scheduler" on the publisher server.
This service actually showed as running from a cursory view, but looking a little deeper showed that it was stopped.
Also here is a doc that may help you out;
Cisco Unified CallManager
CDR Analysis and Reporting Fails to Query by Dates
http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a0080576153.shtml
Hope this helps!
Rob
Please remember to rate helpful posts..........
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: