SourceGear Support

Got version 4.1.2 server and client. When checking in a file i got this error. This did not happen unitl 2 weeks ago. Does this mean our DB is shot? And how do fix it ? [3-11-2008 14:15:38] Checking out file $/VU/Portal/Mainline/VU/VU.Security/SSO.cs [3-11-2008 14:15:38] Checked out file $/VU/Portal...

Log started at 29 Feb 2008 - 21.59.25 Custom action assembly location: C:\inetpub\wwwroot\VaultService\bin\CustomActionExe.exe Custom Action version: 4.1.0 FileVersionInfo: File: C:\inetpub\wwwroot\VaultService\bin\CustomActionExe.exe InternalName: CustomActionExe.exe OriginalFilename: CustomActionE...

Also see my previous post: http://support.sourcegear.com/viewtopic.php?t=8856 Again this upgrade fails with the error that the db is in single user mode. Why put the db in single user more? WHY? Now the upgrade is still failing and I have to wait for the DB restore to go back to 3.5.2. This takes a ...

It was already an upgraded DB. I know how to remove the single user setting

If i used a different user it does work. So it seemed to be security related

We have SQL2005,Vault 3.5.2 We want to upgrade this to 4.0.5 we get the following error during the upgrade 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 databa...

We are currently running Vault 3.5.2 with a couple of repositories. one for each Business Unit. It turns out that a repository with MANY projects ( a couple for each of our customers ) makes working with vault, client and ide, quite slow. We want to move to a situation where we have many repositorie...

Not that we have any real problems with this, but I do agree that this should be a repository of server option !

We are running vault 3.5.1 and want to "clean" up one of our repositories.
The first project we wanted to export failed

I guess there is an error in our DB.

Is there a way to repair/fix this and possibly other errors?

Great! and not that i am aware of

I have a , hopefully small, feature request. It happens almost once a day that one of our developers has an issue with vault and the local caches on his disk. It would be very handy to have a small button on the vault (client) toolbar to invalidate the local ( node / checkoutlist ) caches for the ac...

USE [sgvault]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[spdeletecheckoutlists]
@repid = 4,
@daysold = 3

SELECT 'Return Value' = @return_value

for ( repid 2-9 ) next repid

seems ok now.

Question remains, why this sproc would (B)LOCK access to the DATABASE.

I had a look in the tables tblcheckoutlists rowcount 25040 tblcheckoutlistitems rowcount 540478 Could it be that this is causing the dreaded blocking? Can i remove records from these tables? Cause i saw a lot of checkout lists that were created 9 days ago. Please? i have 10 developers who cannot con...

It blocking AT 16:30. no real information here I guess. People checkout files. Hardly any folders of files. we have around 40 users SQL and vault run on a Dual Xeon 2Gb machine ( with HyperThreading makes 4 ) And the vault db is on a mirror scsi raid. This is a decent server :) I changed the Checkou...

For two days in a row we got a blocking spdeletecheckoutlists at around 16h30. It blocks access to sgvault on our the SQL 2005 server. Our situation: - SQL 2005 - sgvault ( in SQL CompatiblityMode 90 ) - Vault 3.1.8 - 6 repositories - 130.000 files - 13.000 folders I changed the compatibity mode bac...

Is there a verdict on the support and performance of Vault on SQL2005/Sp1 ?

I think it went Gold a couple of days ago..