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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

How to clear "PreDial" field?

We recently upgraded our CCM from 4.1(3)sr4c to 4.1(3)sr5d. This has caused a problem for people that utilize the "Personal Address Book" service. They press the services button on their phone and attempt to dial some in the address book and in all cases they just get a "d" on their screen and the call fails. During the troubleshooting process I figured that the "PreDial" field (under the Subscribe / Unsubscribe link) is not blank and is causing the problem. Once the field is cleared the problem is resolved.

I'd like to know if there is a way to clear that field using some sort of batch program. I have already tried the "BAT" option with no success.


Re: How to clear "PreDial" field?

You can update this through SQL. In SQL Enterprise Manager, expand your current CCM database. In the TelecasterServiceParameter table, find the PreDial parameter and copy the GUID from the fkTelecasterService column. Open the TelecasterSubscribedParameter table and search based on the fkTelecasterService GUID that you copied. You can update those rows that have a 1 for the Value column to a 0. You can do this manually or with an update query.

Hope this helps. If so, please rate the post.