CDR Database

m8kubicki · ‎01-21-2010

Hi,

I am running a CUCM 6.1.3.1000-16. Now I have some trouble with the CAR GUI and the CDR database. When I try to select any option in the CAR GUI I get an error code (code:10012). I have tried some discussed solutions to set the min/max date values on cdr db and so on. But when I try this command:

run sql insert into car:tbl_system_preferences values('CDR_MIN_DATE', '01/01/2010')

i´ll get this response:

Unique constraint (car:informix.pktbl_system_preferences_01) violated.

The same for cdr_min_max_date ...

Also see this:

admin:run sql select * from car:tbl_system_preferences

param_name                param_value
========================= ===========
MIN_DATE                  1148
MAX_DATE                  1148
CDR_MIN_DATE              1148
CDR_MAX_DATE              1148
MAX_CDR_NUMBER            1148
MAX_ERROR_RECORD_ID       1148
COMPANY_NAME              1148
TOLL_FREE                 1148
CHARGELIMIT               1148
GOOD                      1148
POOR                      1148
DEFAULT_CAR_USER          1148
LOADER_STATUS             1148
CONTINUOUS_LOADING_24_7   1148
LOAD_CDR_ONLY             1148
MANUAL_PURGE_STATUS       1148
LOADER_SCHEDULE_BACKUP    1148
PURGE_LOW_WATER_MARK      1148
PURGE_HIGH_WATER_MARK     1148
MIN_CAR_DATABASE_AGE      1148
MAX_CAR_DATABASE_AGE      1148
LAST_PROCESSING_DIRECTORY 1148
LAST_PROCESSING_FILE      1148
LAST_PROCESSING_DATA_ROW 1148
UPDATE_STATISTICS_DATE    1148
LOADER_BATCH              1148
INSTALLATION_DATE         1148

The values seems to be strange cause there are no dates, usernames or so on.

Can I rebuild the whole CDR DB from CLI? Would an update be usefull?

Anyone help?

htluo · ‎01-25-2010

I guess some SQL novice updated the table with value 1148 without specifying the "WHERE" clause?

Try get the table from a "good" box for reference.

Michael

http://htluo.blogspot.com

m8kubicki · ‎01-25-2010

I have entries of a "good" box. But at the moment i can´t insert anything in that table. I will ever get a violation error, so i can´t edit. The table seems to be locked or corrupt. Any idea?

htluo · ‎01-25-2010

Sorry, I missed that part. The "contraints" are some rules to prevent people from inserting bad data.

At this point, I think you need to get a TAC engineer to disable those rules, fix the table, and re-enable the rules. This can only be done from root shell.

Michael