This document describes how to resolve the sql query failed for extension range match: error message that Bulk Edit Utility gives during the attempt to search subscribers by extension in Cisco Unity.
There are no specific requirements for this document.
The information in this document is based on these software versions:
Cisco Unity 7.x/8.x
Bulk edit tool 4.0
The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.
Refer to Cisco Technical Tips Conventions for more information on document conventions.
The Bulk Edit Utility is designed to allow you to choose large numbers of call handlers or subscribers and make changes to them in bulk quickly and easily. Nearly every value you can see and edit through the SA is available to change in mass with the use of Bulk Edit as well as a few items that are not visible in the SA.
Bulk Edit Utility gives this error while you try to search subscribers by extension. The error message is appears:
The DTMFAccessId table contains all the extension numbers for all subscribers, call handlers, interview handlers, directory handlers, location objects and public distribution lists in the entire system.The error can occur due to any special character in DTMFAccessID colmun. Complete these steps in order to check whether DTMFAccessId table has any special character in DTMFAccessID colmun.
Choose Start > Programs > Microsoft SQL Server in order to open SQL Enterprise manager.
Choose Microsoft SQL Servers > SQL Servers Groups > Local or name of primary > Database > UnityDB > Tables.
Right-click the "DtmfAccessId" table and click design table.
Check whether the values inside the DTMFAccessID colmun has any special characters. If so, delete that special characters in DTMFAccessID column.
If you are unable to resolve the issue, use these steps in order to search for illegal characters in the table.
Choose Start -> Program Files > Microsoft SQL server >Query Analyzer in order to open SQL Query Analyzer.
Choose Windows Authentication, then click OK.
Choose "UnityDB" in the combo box on the Menu bar.
Choose Query and choose Results in Text.
Run this sql query: select DTMFAccessID from DtmfAccessId
Note: It is possible that you see an entry, for example, (302) 824-5543, as the result.
Use Datalink Explorer and open the DtmfAccessId table.
Hover the mouse over the parentobjectid in the DtmfAccessId column in order to get the name of the subscriber.
Go to the subscriber and change the alternate extension in order to match correctly without the () and - characters.
While you try to do a bulk edit of subscribers for Cisco Unity with the Bulk Edit tool in Cisco Unity Tools Depot, you are unable to find the settings that need to be changed in the tool. This means that you cannot make changes in Bulk Edit for Cisco Unity 7.0.2 in such a way that subscribers are set to Sign-in settings. Currently most subscribers are set to be handled by different call handlers. It is much faster to bulk edit them all to one setting.
You want to apply a change in Cisco Unity Bulk Edit for When exiting the conversation in Cisco Unity, but you are not able to find it on this tool.
1. Right click on the Unity icon while in the server and select Launch System Admin 2. Click on Subscribers on the left side 3. Click on Conversation with the subscriber information up 4. The heading for the setting is 'When exiting the conversation'
The solution for this issue is shown in this diagram.
Choose Select Subscriber Changes > Exit Dest. > Take Action and choose the Sign In option, which helps you to make the change for the Subscriber settings.
Complete these steps in order to do the bulk edit:
Create two users in Cisco Unity.
On the Cisco Unity Admin page, choose Users and click Search Users page.
Check the box besides the two users, which you have created and click the Bulk Edit button.
Click Edit in Caller Input.
Choose 0 Key.
Choose Call Action as Transfer to Alternate Contact number.
Check the box beside Extension and set the extension value to 0.
- Cisco Unity: Using Bulk Edit to Reset the TUI Password for a Group of Subscribers
- Cisco Unity: Using Bulk Edit to Switch from Multiple Integrations to IP
- Voice Technology Support
- Voice and Unified Communications Product Support
- Troubleshooting Cisco IP Telephony
- Technical Support & Documentation - Cisco Systems
The Cisco Support Community is a forum for you to ask and answer questions, share suggestions, and collaborate with your peers.
Refer to Cisco Technical Tips Conventions for information on conventions used in this document.