Guest

Cisco Unity

Field Notice: FN - 63217 - Unity , 4.2(1), 5.0(1), 7.0(2) - A range of Unity ES's may cause the system to end up in a non-operational state.

Field Notice: FN - 63217 - Unity , 4.2(1), 5.0(1), 7.0(2) - A range of Unity ES's may cause the system to end up in a non-operational state.

April 13, 2009


NOTICE:

THIS FIELD NOTICE IS PROVIDED ON AN "AS IS" BASIS AND DOES NOT IMPLY ANY KIND OF GUARANTEE OR WARRANTY, INCLUDING THE WARRANTY OF MERCHANTABILITY. YOUR USE OF THE INFORMATION ON THE FIELD NOTICE OR MATERIALS LINKED FROM THE FIELD NOTICE IS AT YOUR OWN RISK. CISCO RESERVES THE RIGHT TO CHANGE OR UPDATE THIS FIELD NOTICE AT ANY TIME.

Revision History

Revision Date Comment
1.0
13-APR-2009
Initial Public Release


Products Affected

Products Affected Comments
Unity System Administration - 4.2(X)
Affected ES's - 4.2(1)ES162 to 4.2(1)ES165 (inclusive)
Unity System Administration - 5.0
Affected ES's - 5.0(1)ES56 to 5.0(1)ES64 (inclusive)
Unity System Administration - 7

Affected ES's - 7.0(2)ES9 to 7.0(2)ES15 (inclusive)


Problem Description

Cisco Unity voicemail systems may end up in a non- operational state under the following conditions.

First, have one of the following engineering specials (ES's) applied:

  • 4.2(1)ES162 to 4.2(1)ES165 (inclusive)
  • 5.0(1)ES56 to 5.0(1)ES64 (inclusive)
  • 7.0(2)ES9 to 7.0(2)ES15 (inclusive)

Second, you initiate any 1 of these 3 triggers:

  • Upgrading to a newer version (Minor or Major) of Unity, or Running Cisco Unity setup. (Ex: To add a new feature or language)
  • Using the ConfigMgr Tool to restore stored procedures found in UnityDbEx.sql.
  • Running the Failover Configuration Wizard while the Location table has characters or values in the TextName or DialingDomainName columns that are outside the constraints imposed by a faulty fix included in the aforementioned ES's. The allowed characters include 0-9 a-z A-Z {} '-]. An example of a character outside the constraint is '(' or ')'.

 

Background

This issue exists in Cisco Unity Releases that have the following engineering specials (ES's) applied:

  • 4.2(1)ES162 to 4.2(1)ES165 (inclusive)
  • 5.0(1)ES56 to 5.0(1)ES64 (inclusive)
  • 7.0(2)ES9 to 7.0(2)ES15 (inclusive)

 

Problem Symptoms

If you have installed one of the affected ES's, here are the symptoms that you may experience given the following triggers in bold.

Upgrading to a newer version (Minor or Major) of Unity, or Running Cisco Unity setup.

The Setup wizard will hang while executing UnityDbEx.sql.
The following error message will pop up "Setup was unable to configure default settings on your system. To resolve this problem do the following

A look at the latest OSQL* file in Commserver\Logs will show repeated errors of this kind:

fn_MatchString
Msg 3729, Level 16, State 1, Server XXXXX, Line 1
Cannot DROP PROCEDURE 'fn_MatchString' because it is being referenced
by object 'CN_TextName'.

Running the ConfigMgr Tool to restore stored procedures found in UnitydbEx.sql on the Cisco Unity server results in the following error, found in the latest OSQL* file in Commserver\Logs.

Dropping remaining stored procedures
Msg 3729, Level 16, State 1, Server xxxxx, Line 2
Cannot DROP PROCEDURE 'dbo.fn_MatchString' because it is being referenced by
object 'CN_TextName'

Running the Failover Configuration Wizard fails with the following pop-up error.

"The SQL distribution agent failed. As a result, Cisco Unity Failover will not work properly. Disable all Cisco Unity replication using the SQL Enterprise Manager and run this wizard again."

 

Workaround/Solution

Customers running Unity and an Engineering Special that haven't noticed any of the aforementioned symptoms, can simply upgrade to the following ES's.

4.2(1)ES162 to 4.2(1)ES165 (inclusive) Download/Install 4.2(1) ES166 or higher - Registered Users Only

5.0(1)ES56 to 5.0(1)ES64 (inclusive) Download/Install 5.0(1)ES65 or higher - Registered Users Only

7.0(2)ES9 to 7.0(2)ES15 (inclusive) Download/Install 7.0(2)ES17 or higher - Registered Users Only

Customers experiencing any of the symptoms listed, please follow the steps below which are specific to the symptom.

Upgrading to a newer version (Minor or Major)of Unity, or Running Cisco Unity setup.

The Setup wizard will hang while executing UnityDbEx.sql. The following error message will pop up "Setup was unable to configure default settings on your system. To resolve this problem do the following"

A look at the latest OSQL* file in Commserver\Logs will show repeated errors of this kind:

fn_MatchString
Msg 3729, Level 16, State 1, Server XXXXX, Line 1
Cannot DROP PROCEDURE 'fn_MatchString' because it is being referenced
by object 'CN_TextName'.

Obtain the appropriate patch (should correspond to the version of Unity you are upgrading to, or which you are reinstalling) from the list below:

Unity 4.2(1) Patch 111 Download/Install 4.2(1) Unity Patch 111 - Registered Users Only
Unity 5.0(1) Patch 112 Download/Install 5.0(1) Unity Patch 112 - Registered Users Only
Unity 7.0(2) Patch 113 Download/Install 7.0(2) Unity Patch 113 - Registered Users Only

Follow the instructions provided with the patch to recover your Unity system, and to start Unity upgrade or installation again.

After Unity upgrade or re-run of Setup, install the ES appropriate to your Unity version, from the following list:

4.2(1)ES162 to 4.2(1)ES165 (inclusive) Download/Install 4.2(1) ES166 or higher - Registered Users Only

5.0(1)ES56 to 5.0(1)ES64 (inclusive) Download/Install 5.0(1)ES65 or higher - Registered Users Only

7.0(2)ES9 to 7.0(2)ES15 (inclusive) Download/Install 7.0(2)ES17 or higher - Registered Users Only

Running the ConfigMgr Tool to restore stored procedures found in UnityDbEx.sql on the Cisco Unity server results in the following error:

Found in the latest OSQL* file in Commserver\Logs.

Dropping remaining stored procedures
Msg 3729, Level 16, State 1, Server xxxxx, Line 2
Cannot DROP PROCEDURE 'dbo.fn_MatchString' because it is being referenced by
object 'CN_TextName'

Obtain the appropriate patch:

Unity 4.2(1) -- Patch 111 Download/Install 4.2(1) Unity Patch 111 - Registered Users Only
Unity 5.0(1) -- Patch 112 Download/Install 5.0(1) Unity Patch 112 - Registered Users Only
Unity 7.0(2) -- Patch 113 Download/Install 7.0(2) Unity Patch 113 - Registered Users Only

Follow the instructions provided with the patch to recover your Unity system, and to start Unity upgrade or installation again.

Then install the ES appropriate to your Unity version, from the following list:

4.2(1)ES162 to 4.2(1)ES165 (inclusive): Download/Install 4.2(1) ES166 or higher - Registered Users Only

5.0(1)ES56 to 5.0(1)ES64 (inclusive): Download/Install 5.0(1)ES65 or higher - Registered Users Only

7.0(2)ES9 to 7.0(2)ES15 (inclusive) Download/Install 7.0(2)ES17 or higher - Registered Users Only

Running the Failover Configuration Wizard fails with the following pop-up error.

"The SQL distribution agent failed. As a result, Cisco Unity Failover will not work properly. Disable all Cisco Unity replication using the SQL Enterprise Manager and run
this wizard again."

Install an ES from the following list, to both Unity servers in the failover pair.

4.2(1)ES162 to 4.2(1)ES165 (inclusive): Download/Install 4.2(1) ES166 or higher - Registered Users Only

5.0(1)ES56 to 5.0(1)ES64 (inclusive): Download/Install 5.0(1)ES65 or higher - Registered Users Only

7.0(2)ES9 to 7.0(2)ES15 (inclusive) Download/Install 7.0(2)ES17 or higher - Registered Users Only

Then rerun FCW on the primary and secondary.


DDTS

To follow the bug ID link below and see detailed bug information, you must be a registered customer and you must be logged in.

DDTS Description
{CSCsv99163} (registered customers only), {CSCsv93549} (registered customers only) Upgrade or rerunning Unity Setup fails after installing certain ESs.
CSCsv93549 - This defect will only be triggered in the following scenario: The Location table has values in the TextName or DialingDomainName column that are outside the constraints imposed by a faulty fix included within the same range of ES's.

 

For More Information

If you require further assistance, or if you have any further questions regarding this field notice, please contact the Cisco Systems Technical Assistance Center (TAC) by one of the following methods:

Receive Email Notification For New Field Notices

Product Alert Tool - Set up a profile to receive email updates about reliability, safety, network security, and end-of-sale issues for the Cisco products you specify.