Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

SQL database with CDR

Here is my problem. I get a database error with I try to use the phone services on our 7960 phones. I've been able to replicate this problem at my desk but now even if I delete the user profile and phone from CCM and create a new profile with a different extension number, I still have the same missed/received calls. That leads me to think that the phone itself is tied to the SQL database. If that is the case, would there be a way to go into SQL and just delete this phone?

4 REPLIES
Silver

Re: SQL database with CDR

This error can most likely be corrected with arepublish. This can be done using DBLHelper. MAke sure SA password is right.

New Member

Re: SQL database with CDR

I've tried DblHelper but witout success. I get Green happy faces.

New Member

Re: SQL database with CDR

Hi,

if i have understood right you have a problem with the missed/received calls under the directory button? The information displayed here is not coming from callmanager database. This information is maintained by the phone itself. The database is not invoked here. You can clear the information when you a power off/on oon the phone.

HTH

/Robert

New Member

Re: SQL database with CDR

Actually, I've resolved the problem. The issue was that our SQL database wasn't being updated. We are using a 3rd party application for Long Distance calls and for some reason the link between SQL and CCM was broken and the script wasn't running. This is why when we created new extensions in CCM, they were not implimented in the SQL database and we had a Database error under the services on the phones. But thanks for the info.

152
Views
0
Helpful
4
Replies
CreatePlease to create content