CUCM 6.1.3 CDR issue

Unanswered Question
Jan 14th, 2010
User Badges:

We have CUCM 6.1.3.1000-16 and when we want to get CDR for users or gateways etc. we got error message: error code "10021" error description "There are no matching records". According to earlier post https://supportforums.cisco.com/message/1094339#1094339 we did everything but we still have the same problem. Also when we want to update date we have a error:


admin:run sql insert into car:tbl_system_preferences values('CDR_MIN_DATE', '01/12/2010')
Unique constraint (car:informix.pktbl_system_preferences_01) violated.


It is very strange that we have all date the same:


MIN_DATE                  01/01/1970
MAX_DATE                 01/01/1970
CDR_MIN_DATE          01/01/1970
CDR_MAX_DATE         01/01/1970


Here are our output from CUCM:

Any idea ?


--------

admin:show status


Host Name    : EARTH
Date         : Thu Jan 14, 2010 09:33:39
Time Zone    : XXXXXX
Locale       : en_US.UTF-8
Product Ver  : 6.1.3.1000-16
Platform Ver : 2.0.0.1-1


Uptime:
09:33:40  up 271 days, 15:02,  1 user,  load average: 1.92, 1.25, 1.20


CPU Idle:  79.00%  System:  07.00%    User:  12.00%
  IOWAIT:  00.00%     IRQ:  00.00%    Soft:  02.00%   Intr/sec: 117.00


Memory Total:        2054288K
        Free:          24380K
        Used:        2029908K
      Cached:         850020K
      Shared:              0K
     Buffers:          83816K


                        Total            Free            Used
Disk/active         27656372K       16015860K       11359536K (42%)
Disk/inactive       27656340K       16055128K       11320236K (42%)
Disk/logging        96245392K       62284332K       29072084K (32%)


---

admin:run sql select param_value from car:tbl_system_preferences where param_name='MANUAL_PURGE_STATUS'
param_value
===========
0

admin:run sql select param_value from car:tbl_system_preferences where param_name='MIN_DATE'

param_value

===========

01/01/1970


admin:run sql select param_value from car:tbl_system_preferences where param_name='CDR_MIN_DATE'
param_value
===========
01/01/1970


admin:run sql select param_value from car:tbl_system_preferences where param_name='MAX_DATE'
param_value
===========
01/01/1970


admin:run sql select param_value from car:tbl_system_preferences where param_name='CDR_MAX_DATE'
param_value
===========
01/01/1970

admin:run sql select * from car:tbl_system_preferences
param_name                param_value
========================= ========================================
MIN_DATE                  01/01/1970
MAX_DATE                  01/01/1970
CDR_MIN_DATE              01/01/1970
CDR_MAX_DATE              01/01/1970
MAX_CDR_NUMBER            2000000
MAX_ERROR_RECORD_ID       3471259
COMPANY_NAME              xxxxxx
TOLL_FREE                 1800,1855,1866,1877,1888
CHARGELIMIT               200.00
GOOD                      20.00
POOR                      30.00
DEFAULT_CAR_USER          _unspecifieduser
LOADER_STATUS             1
CONTINUOUS_LOADING_24_7   1
LOAD_CDR_ONLY             1
MANUAL_PURGE_STATUS       0
LOADER_SCHEDULE_BACKUP    DailyCdrLoad,L,1440,-1,00:00:00,0,300,30
PURGE_LOW_WATER_MARK      80
PURGE_HIGH_WATER_MARK     90
MIN_CAR_DATABASE_AGE      30
MAX_CAR_DATABASE_AGE      60
LAST_PROCESSING_DIRECTORY
LAST_PROCESSING_FILE
LAST_PROCESSING_DATA_ROW
UPDATE_STATISTICS_DATE    01/14/2010,0
LOADER_BATCH              600,600,2500,3000
INSTALLATION_DATE         6/26/2008

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
m8kubicki Thu, 01/21/2010 - 07:27
User Badges:

Did you get an answer or solution. Same issue here. Cannot instert anything in car db.

m8kubicki Thu, 01/21/2010 - 07:59
User Badges:

you could put a date into the db like this:


admin: run sql insert into car:tbl_system_preferences values('CDR_MIN_DATE', '01/01/2008');


and get no error message ?

Unique constraint (car:informix.pktbl_system_preferences_01) violated.


This is what i get. And so i cannot put anything to the car tables. Or do you only reboot the server?

Actions

This Discussion