Guest

Cisco Unified Intelligent Contact Management Enterprise

Field Notice: FN - 62444 - Contact Center ICM/IPCC 7.0 EDMT Data Migration Issue While Upgrading from Release 6.0 - Data in Specific Columns of Three Historical Tables Erased


Revised June 12, 2006

June 7, 2006

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.


Products Affected

Products Affected

ICM/IPCC EDMT - 6.0(0), 6.0(0)A or 6.0(0)B with latest SR installed

ICM/IPCC Enterprise EDMT - 6.0(0), 6,0(0)A or 6.0(0)B with latest SR installed

Problem Description

Use of EDMT during an upgrade from ICM EDMT Release 6.0(0), 6.0(0)A or 6.0(0)B to ICM Release EDMT 7.0(0)B results in failure to transfer data to specific columns of three tables.

Note: The table and columns affected are new to the 6.0 release.

Background

In the process of migrating data from ICM EDMT Release 6.0(0), 6.0(0)A or 6.0(0)B to ICM EDMT Release 7.0(0)B, data is erased and replaced with a value of NULL. For detailed information on the tables listed in this section, please consult the Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions.

The fields associate with this issue were part of reporting enhancements implemented in ICM Release 6.0(0). End users will see NULL data in 'Call Type' reports, and as indicated in the subsquent list, three table and certain columns are affected.

The following tables and specific columns are impacted:

TABLE NAME: t_Call_Type_Half_Hour: 
COLUMNS IN TABLE AFFECTED 
CallsAnsweredToHalf 
CallsRoutedNonAgentToHalf 
CallsRONAToHalf 
ReturnReleaseToHalf 
CallsQHandledToHalf 
VruUnhandledCallsToHalf 
VruHandledCallsToHalf 
VruAssistedCallsToHalf 
VruOptOutUnhandledCallsToHalf 
VruScriptedXferredCallsToHalf 
VruForcedXferredCallsToHalf 
VruOtherCallsToHalf 
ServiceLevelType 
BucketIntervalID 
AnsInterval1 
AnsInterval2 
AnsInterval3 
AnsInterval4 
AnsInterval5 
AnsInterval6 
AnsInterval7 
AnsInterval8 
AnsInterval9 
AnsInterval10 
AbandInterval1 
AbandInterval2 
AbandInterval3 
AbandInterval4 
AbandInterval5 
AbandInterval6 
AbandInterval7 
AbandInterval8 
AbandInterval9 
AbandInterval10 
DbDateTime 

TABLE NAME: t_Route_Call_Detail: 
COLUMNS IN TABLE AFFECTED 
DbDateTime 
BeganRoutingDateTime 
BeganCallTypeDateTime 
TargetType 
RequeryResult 
VruProgress 

TABLE NAME: t_Termination_Call_Detail: 
COLUMNS IN TABLE AFFECTED 
DbDateTime 
NetQTime

Problem Symptoms

Reference defect CSCse27987 through the Bug Tookit for details.

Workaround/Solution

The solution has been implemented in EDMT and can be downloaded from CCO at the Contact Center Software Download Page (registered customers only) .

DDTS

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

DDTS

Description

CSCse27987 (registered customers only)

EDMT nulls some historical data columns moving from 6.0 to 7.0. After upgrade from 6.0 to 7.0B following fields of Call_Type_Half_Hour in HDS had been set to NULL : CallsAnsweredToHalf, CallsRoutedNonAgent, CallsRONA, ReturnRelease.

Revision History

Revision

Date

Comment

1.1

12-JUN-2006

Updated Problem Description, Background, Workaround/Solution and DDTS sections.

1.0

07-JUN-2006

Initial Public Release

NetPro Discussion Forums - Featured Conversations

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.