Vault fails to install due to DB upgrade Fail

[Kahlid74]

Installing on a fresh Server 2008 R2 instance with a DB from 3.1.2 that is fully detected and asks if I want to upgrade. I say yes and then the install fails:

Looking for IIS Version
Configuring your new Vault Installation
Requesting the IIS Process User...Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for 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
Creating SourceGear master database schema...Cannot create file 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\sgmaster.mdf' because it already exists. Change the file path or the file name, and retry the operation.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280


Any ideas?

[Beth]

You will want to upgrade in steps per our Upgrading Guide: http://support.sourcegear.com/viewtopic ... 13&t=11648&.

I'm not sure what the Vault server installs will think of Windows Server 2008 R2. The only one supported on that version is the latest. We haven't tested the older versions on the latest Windows server.

What version of SQL Server are you using? Is it on the same machine or a different machine?

You might find fewer problems if you were to upgrade the database on a Windows 2003 server first and then move Vault to where you want it to be (instructions posted here: http://support.sourcegear.com/viewtopic.php?t=228). If SQL is on a different machine, you could leave that where it is and perform the Vault installs on an older machine up until Vault 4.1.4, and then perform the final install of Vault 5.0.4 on the final machine. The important thing is to upgrade the database in steps.

[Kahlid74]

So I followed that for updating to 3.5.3 and now when I run the 4.0.6 install on a Server 2003 box I am getting the same errors again. Any ideas?

OK
Configuring your new Vault Installation
Checking for IIS Version...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
Creating SourceGear master database schema...Cannot create file 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\sgmaster.mdf' because it already exists. Change the file path or the file name, and retry the operation.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

[Beth]

At the point that Vault upgrades to Vault 4.x, it will split into two databases. You left the old sgmaster around from the first attempt at upgrading. That needed to be removed.

I'm not sure what state it would leave your sgvault database, so I would recommend restoring the original, deleting the sgmaster entirely, and then run through the steps again.

[Kahlid74]

Thanks for the above post Beth. I wound up cutting the sgmaster.mdf and ldf out of the data directory and into another directory for temporary purposes. The 4.0.6 upgrade worked and every subsequent upgrade worked as well. So it's all good now.

Does the upgrade documentation mention that it will leave the old 3.X.X Sgmaster around and that you have to manually remove it from the directory or did my upgrade process get botched somewhere along the lines and I am just special.

[Beth]

There is no sgmaster as part of Vault 3.5. That's just something that got left around from the failed upgrade.

[mwhitlatch]

I get the following error trying to update from 5.0.1 to 5.0.4

Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for 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 NT AUTHORITY\NETWORK SERVICE...OK
Upgrading SourceGear master database schema...OK
Upgrading SourceGear source control database schema...Could not allocate space for object 'sys.sysobjvalues'.'clst' in database 'sgvault' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

any ideas?

[Beth]

Upgrading SourceGear source control database schema...Could not allocate space for object 'sys.sysobjvalues'.'clst' in database 'sgvault' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Open your SQL Server Management Studio. Right-click sgvault and select Properties. Click on the Files link. Change the restrictions to allow more space and remove the limit on how much space it can use or change the limit to a larger amount.

Also, check your server disk space to make sure you have enough disk space available. If you do not, then you may need to either move the databases to a drive with more room first, or create more room on the current drive, or consider moving to a server with more space.