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
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.
Technical Tips Conventions for more information on document
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
Choose Start > Programs > Microsoft SQL
Server in order to open SQL Enterprise
Choose Microsoft SQL Servers > SQL Servers Groups >
Local or name of primary > Database > UnityDB >
Right-click the "DtmfAccessId" table and click
Check whether the values inside the DTMFAccessID
colmun has any special characters. If so, delete that special characters in
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
Choose Windows Authentication, then click
Choose "UnityDB" in the combo box on the Menu
Choose Query and choose Results in
Run this sql query: select DTMFAccessID from
Note: It is possible that you see an entry, for example, (302)
824-5543, as the result.
Use Datalink Explorer and open the DtmfAccessId
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
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
Bulk Edit Tool Fails when making changes to Caller Input page.
Use the Firefox web browser instead of IE, which can
solve the problem. This is documented in the Cisco bug ID
(registered customers only)