Guest

Cisco Unified Contact Center Enterprise

Field Notice: FN - 63603 - Purge Jobs Not Created After Unified Contact Center Enterprise (UCCE) 9.0(x) Upgrade

Field Notice: FN - 63603 - Purge Jobs Not Created After Unified Contact Center Enterprise (UCCE) 9.0(x) Upgrade

January 23, 2013


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
23-JAN-2013
Initial Public Release

Products Affected

Products Affected Comments
UCCE - Releases 9.0(1), 9.0(2), 9.0(3)
Applicable for technology refresh upgrades to Release 9.0(X).

Problem Description

After an upgrade from earlier versions of UCCE to UCCE Release 9.0(1), UCCE Release 9.0(2), or UCCE Release 9.0(3) as a technology refresh, stored procedures (that is, the purge jobs in SQL) in Logger and Historical Data Server (HDS) are not created after the upgrade.

This prevents daily scheduled purge activities to control the size of the Logger and HDS databases within the configured percentage utilization (80% by default) and eventually causes auto purge to run constantly.

Background

Daily purge activities will not run after the Release 9.0 upgrade is performed. The HDS and Logger databases will store data beyond the maximum recommended utilization and auto purge and purge adjustment will run constantly.

This might cause Termination Call Detail (TCD)/Route Call Detail (RCD) records not to be written and performance issues on the Logger and the HDS. All the 'A' tables, such as Agent_Half_Hour and so on, will be purged regardless of the age of the data. This is due to the fact that auto purge will run constantly to keep the database utilization below 90%.

Problem Symptoms

This problem only occurs in a technology refresh scenario. Stored procedures are created if there is a common ground upgrade or a new install.

Workaround/Solution

From the Microsoft SQL Server Management Studio query panel, run the 'scheduledailypurge.sql' file. This creates the purge jobs for both HDS and Logger. This file is located at:

  • Logger machine - 'icm//la(lb)/install' folder
  • Distributor - 'icm//aw/install' folder

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
CSCud88390 (registered customers only) No purge jobs after ICM 9.0 upgrade in tech refresh

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

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.