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 | Publish Date | Comments |
---|---|---|
1.0 |
09-Jul-18 |
Initial Release |
1.1 |
26-Jun-20 |
Updated Terminology |
Affected OS Type | Affected Software Product | Affected Release | Affected Release Number | Comments |
---|---|---|---|---|
NON-IOS |
Unified Contact Center Express Critical Updates |
Unified CCX 11 |
11.5(1), 11.5(1)SU1, 11.0(1) |
|
NON-IOS |
Unified Contact Center Express Software |
Unified CCX 11 |
11.6(1) |
Defect ID | Headline |
---|---|
CSCvg58622 | Database primaryship Changes After Connection Pool Runs Out of Connections to DataSource |
Unified Contact Center Express (UCCX) database primaryship changes after the Cisco Unified CCX Cluster View Daemon service fails to connect to the primary Cisco Unified CCX Database service.
UCCX runs out of connections from its connection pool to connect to the primary database, so database primaryship fails over to the High Availability (HA) node if an HA node exists.
This issue is triggered by the start of the nightly purge process. This process is configured on the UCCX application administration page under Tools > Historical Reporting > Purge Schedule Configuration.
Every time the scheduled purge process is run, two connections from the Cluster View Daemon service to the database are leaked. After roughly 75 days, the Cluster View Daemon service runs out of possible connections to the CCX database. After the Cluster View Daemon service sees that it cannot connect to the database, database primaryship changes.
The problem symptoms include:
A CCX Cluster View Daemon restart closes all connections in the connection pool and allows new connections to be made afterwards.
Off hours, enter utils service restart Cisco Unified CCX Cluster View Daemon on the impacted node. Ensure the correct node is the primary afterwards as restarting the Cluster View Daemon service causes primaryship failover.
Once the system is recovered, go to the CCX Administration page and choose Tools > Historical Reporting > File Restore in order to restore the data that was written to flat files while the database was down. It is recommended to perform this operation during a maintenance window or during periods of low call volume if the flat files have been created for multiple days in a high call volume environment.
Unified Contact Center Express 11.5(1) SU1 ES03 Software Download
Unified Contact Center Express 11.6(1) ES02 Software Download
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:
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.
Unleash the Power of TAC's Virtual Assistance