Guest

Cisco Unity

Unable to Search Subscribers in Cisco Unity by Extension with Bulk Edit

Document ID: 112007

Updated: Feb 22, 2012

   Print

Introduction

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.

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

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.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

BulkEdit Utility

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.

unity-bulk-edit-error-01.gif

Error When trying to Search Subscribers by Extension

Bulk Edit Utility gives this error while you try to search subscribers by extension. The error message is appears:

unity-bulk-edit-error-02.gif

Solution

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.

  1. Choose Start > Programs > Microsoft SQL Server in order to open SQL Enterprise manager.

  2. Choose Microsoft SQL Servers > SQL Servers Groups > Local or name of primary > Database > UnityDB > Tables.

  3. Right-click the "DtmfAccessId" table and click design table.

  4. 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.

  1. Choose Start -> Program Files > Microsoft SQL server >Query Analyzer in order to open SQL Query Analyzer.

  2. Choose Windows Authentication, then click OK.

  3. Choose "UnityDB" in the combo box on the Menu bar.

  4. Choose Query and choose Results in Text.

  5. 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.

  6. Use Datalink Explorer and open the DtmfAccessId table.

  7. Hover the mouse over the parentobjectid in the DtmfAccessId column in order to get the name of the subscriber.

  8. Go to the subscriber and change the alternate extension in order to match correctly without the () and - characters.

Unable to find the Edit Settings

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'

Solution

The solution for this issue is shown in this diagram.

unity-bulk-edit-error-03.gif

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.

Error Message: Error on Page

Complete these steps in order to do the bulk edit:

  1. Create two users in Cisco Unity.

  2. On the Cisco Unity Admin page, choose Users and click Search Users page.

  3. Check the box besides the two users, which you have created and click the Bulk Edit button.

  4. Click Edit in Caller Input.

  5. Choose 0 Key.

  6. Choose Call Action as Transfer to Alternate Contact number.

  7. Check the box beside Extension and set the extension value to 0.

  8. Click Submit.

    When you submit the page, no response, javascript error showing up. Bulk Edit Tool Fails when making changes to Caller Input page.

Solution

Use the Firefox web browser instead of IE, which can solve the problem. This is documented in the Cisco bug ID CSCth50703 (registered customers only)

Related Information

Updated: Feb 22, 2012
Document ID: 112007