Cisco Cisco IP Contact Center Release 4.6.1 Troubleshooting Guide
Troubleshooting Guide for Cisco Unified Contact Center Management Portal Release 8.0(1)
15
You can confirm this problem by checking the Event Viewer for an event
with a description that includes the phrase ‘violation of UNIQUE KEY
constraint’.
with a description that includes the phrase ‘violation of UNIQUE KEY
constraint’.
To solve this problem, it is necessary to delete one of the duplicate
records.
records.
To find the record causing the problem:
1. Go to the subscriber database and expand the Portal database
2. Navigate to Replication Monitor > Publishers > Publisher
Database Name and click on Base:Portal publication.
3. In the left-hand window, right-click on the Distribution Agent for
Base publication. This will be displayed as Subscriber Database
Name:Portal.
Name:Portal.
4. Select Agent History to open the Distribution Agent History
window, which displays information about the error and the place
where the conflict is occurring.
where the conflict is occurring.
5. To find the record in the table where this error is occurring, right-
click the Base:Portal publication (Replication Monitor >
Publishers > Publisher Database Name) and click View
Conflicts. This opens the Replication Conflict Viewer window.
Publishers > Publisher Database Name) and click View
Conflicts. This opens the Replication Conflict Viewer window.
6. Select the table that you suspect the conflict to be in and click
View.