Vault 2.06 and MSDE sp4 ok?

[mchean]

Will upgrading present any problems with Vault 2.06?

Mike

[jclausius]

MSDE2000 / SQL Server 2000 SP4 is only about 4 days. We haven't done any testing on this update.

[jclausius]

We've been able to confirm a problem within SP4 when a repository is deleted. Note, this is a bug in SQL Server SP4. SQL Server SP3 and SQL Server Security Update to SP3 are not affected by this problem.


Microsoft has been notified of the problem, and they are currently looking at a work around or hot fix for the problem. Once there is some sort of resolution, we will post a follow up to the problem.

[jclausius]

For the sake of completeness, here is the error you will find in your server's log file when deleting a repository with SQL Server SP4:

--SSL Disabled Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.

[jclausius]

Microsoft has provided a work-around. Four foreign keys have to be re-created in a specific order.

Running the following script (as provided), should allow you to delete the repository.

Code: Select all

USE sgvault
GO

ALTER TABLE [dbo].[tblfsobjectshares] DROP CONSTRAINT 
[fk_tblfsobjectshares_objid_tblfsobjects] 
GO

ALTER TABLE [dbo].[tblfsobjectshares] ADD CONSTRAINT
[fk_tblfsobjectshares_objid_tblfsobjects] FOREIGN KEY 
(
	[objid]
) REFERENCES [tblfsobjects] (
	[objid]
) 
ON DELETE CASCADE 
GO


ALTER TABLE [dbo].[tblfsobjectversions] DROP CONSTRAINT
[fk_tblfsobjectversions_tblfsobjects] 
GO

ALTER TABLE [dbo].[tblfsobjectversions] ADD CONSTRAINT
[fk_tblfsobjectversions_tblfsobjects] FOREIGN KEY 
(
	[objid]
) REFERENCES [tblfsobjects] (
	[objid]
) ON DELETE CASCADE 
GO


ALTER TABLE [dbo].[tbltransactions] DROP CONSTRAINT
[fk_tbltransactions_tblrepositories] 
GO

ALTER TABLE [dbo].[tbltransactions] ADD CONSTRAINT
[fk_tbltransactions_tblrepositories] FOREIGN KEY 
(
	[repid]
) REFERENCES [tblrepositories] (
	[repid]
) ON DELETE CASCADE 
GO


ALTER TABLE [dbo].[tbldeletions] DROP CONSTRAINT
[fk_tbldeletions_objid_tblfsobjects] 
GO
ALTER TABLE [dbo].[tbldeletions] ADD CONSTRAINT
[fk_tbldeletions_objid_tblfsobjects] FOREIGN KEY 
(
	[objid]
) REFERENCES [tblfsobjects] (
	[objid]
) ON DELETE CASCADE 
GO

[gmagana]

Will this be built into upcoming versions of Vault?

[jclausius]

Yes. Upgrading to Vault 3.1 (post Beta 1 as well as 3.1 release) will execute the script upon upgrade.

And if you're on Vault 3.1 Beta 1, Beta 2 will also run the script.