CAR database crosses 2 Million Mark

Unanswered Question
Jun 1st, 2010
User Badges:

I started getting this message last week. "Number /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} of records in CAR database crosses 2 Million Mark; after database purging, it still crosses 2 Million Mark, loader stopped" I found information about how to purge the data base, but it filled back up with in 4 hours.  I cleared it out before the weekend again - in the database it up to 3 quarters full again.  The Error Billing Table - is the one filling up to the 2 Million mark.  Where should I start in trouble shooting this?

Thanks

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
htluo Tue, 06/01/2010 - 07:17
User Badges:
  • Red, 2250 points or more

The first thing I would check is CUCM > System > Service Paramters > Cisco CallManager > "CDR Log Calls with Zero Duration Flag".  This parameter should set to "False" on every CUCM box.


Second thing to check is on the CAR page (http://cucm/car) > System > Database > Configure Automatic Purge > Max Age of Call Detail Records.  Default is 60 days.  If you have a busy system, you want a smaller number (like 30 days).


Michael

http://htluo.blogspot.com

Actions

This Discussion