Symptoms
When trying to add a new Queue, after submitting the required information the below error is reported:
Server Error in '/' Application.
Violation of PRIMARY KEY constraint 'PK_tbl_OpenConfirmation'. Cannot insert duplicate key in object 'dbo.tbl_OpenConfirmation'.
The statement has been terminated.
Resolution
To correct this issue please perform one of the following tasks below.
(1) Connect to the database and open the tables tbl_OpenConfirmation and tbl_CloseConfirmation and delete records 2 to 6 in both of them.
(2) Execute the following SQL Script against the versaSRS database:
PRINT 'Deleting records from table tbl_QueueEscalations'
Delete from tbl_QueueEscalations
Where QueueID > 1
PRINT 'Deleting records from table tbl_QueueGroupUsers'
Delete from tbl_QueueGroupUsers
Where QueueID > 1
PRINT 'Deleting records from table tbl_OpenConfirmation'
Delete from tbl_OpenConfirmation
Where QueueID > 1
PRINT 'Deleting records from table tbl_QueueDueDates'
Delete from tbl_QueueDueDates
Where QueueID > 1
PRINT 'Deleting records from table tbl_CloseConfirmation'
Delete from tbl_CloseConfirmation
Where QueueID > 1