Install error vault 4.0.4

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
paulb
Posts: 10
Joined: Fri Feb 13, 2004 5:39 pm

Install error vault 4.0.4

Post by paulb » Mon Oct 15, 2007 9:57 am

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

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Mon Oct 15, 2007 10:55 am

Is there an sgdragnet database on this same instance of SQL Server?
Linda Bauer
SourceGear
Technical Support Manager

paulb
Posts: 10
Joined: Fri Feb 13, 2004 5:39 pm

Post by paulb » Tue Oct 16, 2007 1:26 am

There is an sgmaster database.

Post Reply