AnsweredAssumed Answered

EPDM Database error

Question asked by Charley McGowan on May 16, 2012
Latest reply on May 16, 2012 by Charley McGowan

So... we are trying to add a replicated vault to one of our branches, and we continue to get the error below. I dug around here and found similar posts for issues in 2010 that had a hotfix, but nothing for 2012.... any advice?

 

 

Error running query in SpDbOdbc

State=23000

Msg=[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'IX_ArchiveServers'. Cannot insert duplicate key in object 'dbo.ArchiveServers'. The duplicate key value is (VAULT SERVER).

 

 

========= LAST COMMAND ========

Exec Arc_AddServer N'VAULT SERVER', 3030, N'<local>\Archives', N'MAIN VAULT'

 

 

Server: SQL SERVER

 

 

Database: PDMWE_MAINVAULT

Outcomes