CDR Manual purge is not working

Unanswered Question
Oct 7th, 2009

Dear networkers,

We have CUCM 6.0.1.2000-3 installed at the customer site.

When trying to purge manually the CDR database, we have the following message : "Reload

proccess is running.Please wait till the Reload Process is over". (see attached screen shot)

We are not able to manually purge the Database.

Please help.

thanks in advance.

Attachment: 
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
virverma Wed, 10/07/2009 - 19:39

Its an existing defect,

try the workaround

Identify which column(s) are missing in tbl_system_preferences table (this can be done either by looking at the CAR scheduler trace and search for ERRORm, or it can simply be done by querying directly on tbl_system_preferences table via CLI to find out which one(s) are missing: "admin: run sql select * from car:tbl_system_preferences")

If any of these four columns is missing, insert it back to the table with the following logic:

- If MIN_DATE is missing, find CDR_MIN_DATE value and insert such value as MIN_DATE to tbl_system_preferences.

- If CDR_MIN_DATE is missing, find MIN_DATE value and insert such value as CDR_MIN_DATE to tbl_system_preferences.

- If both MIN_DATE & CDR_MIN_DATE are missing, insert '01/01/1970' to both columns to to tbl_system_preferences.

- If MAX_DATE is missing, find CDR_MAX_DATE value and insert such value as MAX_DATE to tbl_system_preferences.

- If CDR_MAX_DATE is missing, find MAX_DATE value and insert such value as CDR_MAX_DATE to tbl_system_preferences.

- If both MAX_DATE & CDR_MAX_DATE are missing, insert '01/01/1970' to both columns to to tbl_system_preferences.

In any of the above cases, once Loader starts and load new files, it will populate the correct values for these columns again, based on the records being loaded.

For example, if CDR_MIN_DATE is missing:

1. Get MIN_DATE value.

admin: run sql select param_value from car:tbl_system_preferences where param_name='MIN_DATE'

2. Get the value from above, eg: 01/01/2008, then run:

admin: run sql insert into car:tbl_system_preferences values('CDR_MIN_DATE', '01/01/2008');

For example, if MAX_DATE is missing:

1. Get CDR_MAX_DATE value.

admin: run sql select param_value from car:tbl_system_preferences where param_name='CDR_MAX_DATE'

2. Get the value from above, eg: 02/14/2008, then run:

admin: run sql insert into car:tbl_system_preferences values('MAX_DATE', '02/14/2008');

haouaswajih Thu, 10/08/2009 - 12:16

Hi,

Thanks for your response but in fact the procedure that you mentioned is used usually for another type of issues with CDRs.

In fact I have solveed the issue.

I had to stop the :

-Car Scheduler service (on publisher)

-CDR Repository manager (on all nodes)

then execute the following command from CLI (SSH on callmanager): run sql update car:tbl_system_preferences set param_value ='0' where param_name like 'MANUAL_PURGE_STATUS'

then Start again those services mentioned before.

Now Manual purge is working fine.

Thanks for you help anyway :)

Actions

This Discussion