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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CUCM 6.1.3 CDR issue

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

  • IP Telephony
4 REPLIES
New Member

Re: CUCM 6.1.3 CDR issue

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

New Member

Re: CUCM 6.1.3 CDR issue

I did everything according to https://supportforums.cisco.com/message/1094339#1094339 and last what I did is restarted the whole CUCM. After that I can see CDRs through web interfaces  from the day when I restarted CUCM.

Good luck.

M

New Member

Re: CUCM 6.1.3 CDR issue

I did everything according to https://supportforums.cisco.com/message/1094339#1094339 and last what I did is that I restarted the whole CUCM. After this I can see CDRs from the day when I restarted CUCM.

Good luck.

M

New Member

Re: CUCM 6.1.3 CDR issue

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?

812
Views
0
Helpful
4
Replies
This widget could not be displayed.