CDR configuration issue

Unanswered Question
Jul 8th, 2008
User Badges:

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3 (2 ratings)
Loading.
ivillegas Mon, 07/14/2008 - 11:50
User Badges:
  • Silver, 250 points or more

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.


dom.a Tue, 07/15/2008 - 01:57
User Badges:

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

Jaime Valencia Tue, 07/15/2008 - 10:04
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

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

dom.a Tue, 07/15/2008 - 11:15
User Badges:

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

Jaime Valencia Tue, 07/15/2008 - 17:27
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

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

Actions

This Discussion