2 Replies Latest reply on May 16, 2012 10:34 PM by Charley McGowan

    EPDM Database error

    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


      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