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?
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: