Error: Violation of PRIMARY KEY constraint 'PK_Version'. Cannot insert duplicate key in object 'd (4314665)

While upgrading Archive Manager, the following error is logged:

Incorrect timestamps on a row in the version table.

Run the following script:

use ArchiveManager
select * from version

This will return a list of database upgrades, with associated dates and timestamps similar to the output below.

4.1.0.85 2009-04-17 10:05:11.443 4.1.0.366
4.1.0.86 2009-04-17 10:05:11.553 4.1.0.366
4.1.0.87 2009-04-17 10:05:11.423 4.1.0.366
4.1.0.88 2009-04-17 10:05:11.440 4.1.0.366
4.1.0.89 2009-04-17 10:05:11.500 4.1.0.366

In this example, the last entry in the list is not the latest timestamp. 4.1.0.86 shows as 10:05:11.553 and this means that the installer considers this to be the latest version.

Use the following SQL script to make the last entry in the version table the most recent timestamp:

update version set InstallTime = '2009-04-17 10:05:11.600' where version = '4.1.0.89'

The timestamp used in the update query should be customised to match the results of the select query.