CUCM 6.1.3 CDR issue

mljevakovic · ‎01-14-2010

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

m8kubicki · ‎01-21-2010

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

mljevakovic · ‎01-21-2010

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

mljevakovic · ‎01-21-2010

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

m8kubicki · ‎01-21-2010

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?