Cisco Cisco Unified Contact Center Enterprise 8.0(1) Troubleshooting Guide

Introduction
 Prerequisites
      Requirements
      Components Used
      Conventions
 Problem
 Solution
 Related Information

The Unified Contact Center Enterprise (UCCE) Agent Re−skilling tool is an optional, browser−based
application designed for use by IPCC Call Center supervisors. This tool allows you to change the skill group
designations of agents on your team, and quickly view skill group members and details on individual agents.

This document discusses how to troubleshoot the SQL errors which occur when you use the UCCE Agent
Re−skilling tool to add or remove skills.

There are no specific requirements for this document.

The information in this document is based on the Cisco Unified Contact Center Enterprise 8.5(2).

The information in this document was created from the devices in a specific lab environment. All of the
devices used in this document started with a cleared (default) configuration. If your network is live, make sure
that you understand the potential impact of any command.

Refer to Cisco Technical Tips Conventions for more information on document conventions.

SQL error messages are received when you try to add or delete skills for the agents using the UCCE Agent
Re−skilling tool.

When the skills are added, this message is received:

SQL Server Error 

Error: 2627, State 1, Severity: 14 

Violation of PRIMARY KEY constraint 'XPKSkill_Group_Members'.