01-14-2010 12:45 AM - edited 03-18-2019 10:59 AM
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
01-21-2010 07:27 AM
Did you get an answer or solution. Same issue here. Cannot instert anything in car db.
01-21-2010 07:38 AM
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
01-21-2010 07:40 AM
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
01-21-2010 07:59 AM
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?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide