Vault 3.5.2 Server Upgrade Failure

A collection of information about Vault, including solutions to common problems.

Moderator: SourceGear

Post Reply
jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Vault 3.5.2 Server Upgrade Failure

Post by jclausius » Fri Apr 27, 2007 1:05 pm

This problem was fixed in Vault 3.5.3.

In certain scenarios, upgrading the sgvault database may produce the following error: "ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'fk_tblrepositories_tblcheckoutlists'"


This error can be resolved with the following steps:

A) Make sure the sgvault database is in 'Multi-User' mode

Code: Select all

ALTER DATABASE sgvault SET MULTI_USER
B) Run the following script

Code: Select all

USE sgvault
GO
UPDATE dbo.tblrepositories SET currentcolistid = NULL
WHERE EXISTS 
   (SELECT * FROM dbo.tblcheckoutlists co WHERE co.colistid = dbo.tblrepositories.currentcolistid)
AND NOT EXISTS 
   (SELECT * FROM dbo.tblcheckoutlistitems col WHERE col.colistid = dbo.tblrepositories.currentcolistid)
C) Exit all query tools and close all connections to the sgvault database.

D) Re-attempt the Vault 3.5.2 Server installation.

Bug:11669
Jeff Clausius
SourceGear

Post Reply