Solving Vertical TeleVantage Error 27506


When upgrading from version 7 to 7.5, one of the procedures is to upgrade the TeleVantage Services :Upgrade  TVrecording Archive Service to the matching version. The install may fail with the following error message:

TeleVantage Services Setup Information
Error 27506. Error executing SQL Script TvArchive.sql. Line 328 [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ‘PK_Users’. Cannot insert duplicate key in object ‘Users’.(2627)


This error seems to stem from the script trying to create a user in the local MSDE instance used to catalog the recordings, but the user already exists.

To fix this issue and allow the upgrade to proceed, run setup again, this time deselecting the Archive Service. This will remove of the service, but will not harm the database. Now, rerun the setup script and add the archive component again. Setup should now complete normally.