Vault 3.5.2 Server Upgrade Failure

[jclausius]

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