ds-blue-logo
Preview  |  SOLIDWORKS USER FORUM
Use your SOLIDWORKS ID or 3DEXPERIENCE ID to log in.
CMCharley McGowan16/05/2012

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