CDR alert?

[sbshah]

Hi,

I got an alert saying that Number of rows in calldetailrecord table in CDR database has crossed the threshold limit. What does this mean and how do I resolve that?

Thanks

[Steven Smith]

The alert means that you have passed a predefined threshold for the database. You may want to purge some data so the database does not get to big.

If you go into the CDR Analysis and Reporting tool (do this from the serviceability page and then under tools), click on system then database. You will see 4 options. CDR Alert, CAR Alert, Manual Purge and Configure AutoMatic Purge. The Alert menus allow you to set the alert levels. The manual purge allows you to purge manually 1 time. The automatic purge can be setup to purge data on a regular basis.

Thanks

Steven

[sbshah]

Thanks for your reply.

I am not able to find out four options on CDR reporting and analysis page. I am using CallManager administration version 4.1(0.11) and CallManager servicebility version 4.0(0.1).

Thanks.

[Steven Smith]

Hi,

Are you a CAR admin? If you are not a CAR admin, you will not see all the options. I would verify that you are a CAR admin.

Here is a document on the options I spoke of.

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_administration_guide_chapter09186a00801ed126.html#1094892

Here is how you grant someone admin rights. You will need someone with admin rights to do this.

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_administration_guide_chapter09186a00801ed126.html#1092239

Thanks

Steven

[jasondrisc]

Hello Steven,

How do you recreate a CAR admin if your CAR admins have been mistakenly deleted?? A post 7-digit conversion user cleanup resulted in this situation.

Thanks,

Jason

[Steven Smith]

Hi Jason,

You need to delete the CAR admin group from the directory that you are using.

The object is CiscoAdminRepToolAdminGroupUsers

Depending on your integration, it could be in a different location. After you delete, you should be able to login with the default user id and password.

[jasondrisc]

Hello,

Thank you for the information! I will give this a shot.

Much appreciated!!

Jason

[jasondrisc]

Steven,

Just as a follow-up, before deleting that object I used the following link to find an ID that was a member of the CAR admin group: http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801115eb.shtml

The ID must've been used during our initial deployment and made it under my radar during my ID cleanup.

Thanks again for your assistance, it got me pointed in the right direction.

Regards,

Jason