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
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.
Technical Tips Conventions for more information on document
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'.
Cannot insert duplicate key in object 'dbo.t_Skill_Group_Member'.
When the skills are deleted, this message is received:
delete t_Skill_Group_Member where SkillGroupSkillTargetID = <ID>
and AgentSkillTargetID = <ID>' did not locate a record.
The database that originated the query does not match the Logger database.
However, if you look at the configlogger logs, you can see that the
add/delete occurred twice. The re-skill occurs fine, but it displays the error
message due to the duplicate add/delete.
This occurs when using an Internet Explorer 8 browser to add or remove
agent skills, then clicking the save button at the bottom of the page.
As a workaround, use the save button at the top of the web page in
order to save the changes, or use a different supported browser. For
information on browser support, refer to
This issue is fixed in UCCE 8.5(4) and 9.0(1). Refer to Cisco bug ID
(registered customers only)