Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CDR configuration issue

Hi,

I have configured CDR in a CCM 4.1(3) and now try to collect data. When trying to get bill report i have an error message : 30061 : data is not available in the Database.

Something missing in my configuration ? i have checked step-by-step each details, but the error message still appears.

Rgds

6 REPLIES
Silver

Re: CDR configuration issue

The problem is because of MIN_DATE and MAX_DATE values are not getting updated according to the processed CDR and CMR files. So whenever the report was tried to be generated, it used to throw the error "Data is not available in the Database".

The workaround is to update the MIN_DATE and MAX_DATE values manually in tbl_system_preferences table. Update the values of CDR_MIN_DATE and CDR_MAX_DATE for MIN_DATE and MAX_DATE respectively. Use the following queries to update the values

Update tbl_system_preferences set param_value = '

Update tbl_system_preferences set param_value='' where param_name='MAX_DATE'

Replace with the actual date values.

Cisco Employee

Re: CDR configuration issue

Data is Absent in Reports Created by the CAR Tool

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a008056bd4e.shtml

HTH

javalenc

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: CDR configuration issue

Hi,

After reading this document, i think i missed one important requirement for CDR configuration : The MS SQL Server.

Is it mandatory to have a database (like MS SQL server or Oracle)installed on the CCM before configuring the CDR ?

Regards

Cisco Employee

Re: CDR configuration issue

OF COURSE IT'S MANDATORY!!! if you do not have SQL on that server how is your CUCM even working??????

CUCM should have installed it on the installation process. if not then rebuild from scratch

we do not use Oracle, not sure why you mention that

HTH

javalenc

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: CDR configuration issue

Ok, my installation has SQL server installed !

So now, if the CDR generate some files, i don't know exactly where CDR files are stored into CCM (the exact path on the CCM).

Regards

Cisco Employee

Re: CDR configuration issue

program files/cisco/cdr and something else i don't have a server right now. you probably can browse from there. flat files are inserted every minute into CDR DB

HTH

javalenc

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
217
Views
6
Helpful
6
Replies