Trying to upgrade a Vault 3.5.2 installation to 4.0.4 fails during db upgrade, any ideas? I couldn't find anything usefull in the forum.
OK
Configuring your new Vault Installation
Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for an existing databases...Found.
Asking for database's fate...Keep existing.
Upgrading the existing source control database...
This may take a long time. Do NOT stop this process!
Checking the installed database version...OK
Grant database access to tamtam\paulb...OK
Upgrading SourceGear master database schema...OK
Upgrading SourceGear source control database schema...Violation of PRIMARY KEY constraint 'pk_serialnumbers'. Cannot insert duplicate key in object 'dbo.serialnumbers'.
Violation of PRIMARY KEY constraint 'pk_groups'. Cannot insert duplicate key in object 'dbo.groups'.
Violation of PRIMARY KEY constraint 'pk_users'. Cannot insert duplicate key in object 'dbo.users'.
Violation of PRIMARY KEY constraint 'pk_groupmembers'. Cannot insert duplicate key in object 'dbo.groupmembers'.
Dropping extended properties
Dropping foreign keys from [dbo].[tblgroupmembers]
Dropping foreign keys from [dbo].[tblcheckoutlistitems]
Dropping foreign keys from [dbo].[tblfsobjectlabelchanges]
Dropping foreign keys from [dbo].[tbldelayusersecuritychanges]
Dropping foreign keys from [dbo].[tblusersecuritychanges]
Dropping foreign keys from [dbo].[tblsessions]
Dropping foreign keys from [dbo].[tblsessionlabelqueries]
Dropping foreign keys from [dbo].[tblsessionbranchsandbox]
Dropping foreign keys from [dbo].[tblclientoptions]
Dropping foreign keys from [dbo].[tbluserrepositories]
Dropping foreign keys from [dbo].[tblloginattempts]
Dropping foreign keys from [dbo].[tblfsobjectlabels]
Dropping foreign keys from [dbo].[tbltransactions]
Dropping foreign keys from [dbo].[tblhistoryfavorites]
Dropping foreign keys from [dbo].[tblsessionrecursivelabelqueries]
Dropping foreign keys from [dbo].[tblsessionfolderexports]
Dropping foreign keys from [dbo].[tblcloaks]
Dropping foreign keys from [dbo].[tblwatchers]
Dropping constraints from [dbo].[tblusers]
Dropping constraints from [dbo].[tblusers]
Dropping constraints from [dbo].[tblusers]
Dropping constraints from [dbo].[tblusers]
Dropping constraints from [dbo].[tblusers]
Dropping constraints from [dbo].[tblusers]
Dropping constraints from [dbo].[tblgroupmembers]
Dropping constraints from [dbo].[tblgroups]
Dropping constraints from [dbo].[tblgroups]
Dropping constraints from [dbo].[tblloginattempts]
Dropping constraints from [dbo].[tblsessions]
Dropping index [idxuserlogins] from [dbo].[tblusers]
Dropping index [idxsessionsuserid] from [dbo].[tblsessions]
Dropping [dbo].[spcleansessions]
Dropping [dbo].[spdeletesession]
Dropping [dbo].[spaddsession]
Dropping [dbo].[splogin]
Dropping [dbo].[spgetlogininfo]
Dropping [dbo].[spdeletelicensekey]
Dropping [dbo].[spdeleteserialnum]
Dropping [dbo].[spaddserialnum]
Dropping [dbo].[spgetserialnums]
Dropping [dbo].[spcleanloginattempts]
Dropping [dbo].[spchangepassword]
Dropping [dbo].[spgetgroupmembers]
Dropping [dbo].[spgetgroups]
Dropping [dbo].[spdeletegroupmembers]
Dropping [dbo].[spaddgroupmember]
Dropping [dbo].[speditgroup]
Dropping [dbo].[spaddgroup]
Dropping [dbo].[tbllicensekeys]
The statement has been terminated.
Dropping [dbo].[tblloginattempts]
Dropping [dbo].[tblsessions]
Dropping [dbo].[tblgroups]
The statement has been terminated.
Dropping [dbo].[tblgroupmembers]
The statement has been terminated.
The statement has been terminated.
Rebuilding [dbo].[tblusers]
Caution: Changing any part of an object name could break scripts and stored procedures.
Creating primary key [pk_tblusers] on [dbo].[tblusers]
Adding constraints to [dbo].[tblusers]
Adding foreign keys to [dbo].[tbluserrepositories]
Adding foreign keys to [dbo].[tblusersecuritychanges]
Adding foreign keys to [dbo].[tblfsobjectlabels]
Adding foreign keys to [dbo].[tblclientoptions]
Adding foreign keys to [dbo].[tblhistoryfavorites]
Adding foreign keys to [dbo].[tblwatchers]
Adding foreign keys to [dbo].[tblcloaks]
Adding foreign keys to [dbo].[tbldelayusersecuritychanges]
Adding foreign keys to [dbo].[tblfsobjectlabelchanges]
Adding foreign keys to [dbo].[tbltransactions]
Adding foreign keys to [dbo].[tblcheckoutlistitems]
The database update failed
Error during Vault upgrade script.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280
Install error vault 4.0.4
Moderator: SourceGear