Field Notice: FN - 70276 - Unified Communications Manager 11.5(X) Exhibits Slow GUI Page Response Times - Software Upgrade Recommended

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	Publish Date	Comments
1.0	13-Sep-18	Initial Release

Products Affected

Affected OS Type	Affected Release	Affected Release Number	Comments
NON-IOS	UCM	11.5(1)SU3b, 11.5(1)SU3a, 11.5(1)SU3
NON-IOS	11.5(1)	11.5(1)SU3, 11.5(1)SU3a

Defect Information

Defect ID	Headline
CSCva78144	Slow GUI/Tomcat Response due to Informix Database Issue not being able to run Auto Update Statistics

Problem Description

Cisco Unified Communications Manager (UCM), Cisco Unity Connection (CUC), or Cisco Unified Communications Manager IM & Presence Service can exhibit slow GUI performance and slow database access due to database query optimizer failure.

Background

Customers can experience slow performance with various database queries. This slowness can be caused by a failure in the automated process that collects the statistics that are used to optimize queries. Most database queries will not be impacted significantly. However, as more of the system data changes over time, the statistics that the optimizer uses can become stale and database queries can become slower.

Problem Symptom

Administrators can experience slow server performance or operation timeouts when they perform GUI-based queries.

Examples (not exhaustive):

• Cisco CallManager Administration (CCMAdmin) - Some operations can be slow and can time out with this message:

  System or internal error
  java.net.SocketTimeoutException: Read timed out

• Bulk Administration Tool (BAT) - Some operations can be slow and can time out.
• Responses to the Cisco Administrative XML (AXL) request might also be delayed.

Note: Some functions of the system require database queries as part of the operation.

Workaround/Solution

Workaround

None

Solution

Cisco customers that run UCM Version 11.5(1)SU4 are not impacted by this defect. For all other customers with impacted releases,  Cisco recommends that you upgrade to UCM Version 11.5(1)SU5 or later.

Note: UCM GUI performance issues can have multiple causes. Consult the Troubleshooting Guide for Cisco Unified Communications Manager, Release 11.5(1) and consider these other options:

• Ensure that the VMware OVA file has the proper resources for the configured users and devices.
• Ensure that the virtual disk meets the required performance specifications.
• Ensure that network delays are within specifications and that network issues are resolved.

How To Identify Affected Products

Customers who experience GUI slowness as mentioned in the Problem Symptom section can identify the issue with this command:

file get activelog cm/log/informix/ccm.log

Upon review of the log file, customers will see text similar to this example which identifies the issue:

23:13:59 SCHAPI: last statement aus_refresh_stats(integer,integer)
23:13:59 SCHAPI: [Auto Update Statistics Refresh 43-2] Error -217 Column (aus_cmd_dbs_priority) not found in any table in the query (or SLV is undefined).

See How to Collect CUCM Logs if RTMT isn't Accessible or Available for information on how to collect log files via the CLI.

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:

• Open a service request on Cisco.com
• By email
• By telephone

Receive Email Notification For New Field Notices

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