Error: Vault 5.1.2.1981 to 6.0.0.477 Upgrade

[HansM]

Hi,

i have a problem with upgrading my vault standard to the new 6.0.0.477 version. At step "upgrading sql databases" the error 'sgvault' is already open and can only have one user at a time.
Vault Standard Setup is exiting due to a failure or cancellation. Error Code = -1280
occurs after "Upgrading SourceGear source control stored procedures...Database". What can I do? I use windows authentication. Do the account need special permissions on the master db to reset the connection? Note, the server is a test server with a domain controler installed.

Best Regards,
Hans

[lbauer]

What version of SQL Server are you using? What operating system are you installing on?

[HansM]

Sorry for the missing infos. I use a Windows Server 2008R2 and a SQL 2008R2.

Regards,
Hans

[lbauer]

First make sure the databases are not in single user mode. you can check this in the database properties in SQL Server Management Studio.

Next I would suggest running the Vault server installer as Administrator. To do this, run the command prompt as administrator and run the installer from the command line. This will elevate the installer's privileges.

[HansM]

If i start installing the new version the db is not in single mode, but after the the install failed the db was left in singe mode. I must then restore the multi mode in the sql management studio.

I also testet the installation from an admin cmd. But the same error occurs.

I have attached the logfile if you want to see when the error happens.

Regards,
Hans

[Beth]

When you are connecting to SQL Server, are you using Windows authentication or SQL authentication?

If you are using Windows authentication, are you logged into the machine as a domain user, and does that domain user have full sysadmin access to the SQL Server?

If you are using SQL authentication, are you connecting to the SQL Server with either the 'sa' account or some other sysadmin account? The admin level account is only used during install.

[HansM]

Hi,

i use windows auth. The user has domain admin rights, is local administrator and has sql sysadminrights. If i test the installation with the sa account i get the same error.

Hans

[lbauer]

Try installing again, using the Vault 6.0.1 release. We fixed some SQL Server issues in the installer.

http://www.sourcegear.com/vault/downloads.html

[HansM]

Hi,

same problem. same error message. The only point i found out is that my db has the SQL_Latin1_General_CP1_CI_AS collation. Is this a problem? I also test some additional things. I exportet the sql upgrade script from the CustomActionExe and let the upgrade run on my database (i have a backup...). the sql script runs without an error nor setting the db to single user. So i don't understand why my db is in single user mode after running the setup program.

Hope someone can help me.
Hans

[lbauer]

We're not sure if there's a problem with the installer, or if it's something with your SQL Server configuration.

First, restore another copy of the Vault 5.1.2 databases, sgvault and sgmaster. If you have any other Vault databases, like sgnotify or sgvaultindex, delete these. These are leftovers from the failed Vault 6.0 upgrade.

We want you to start fresh, with Vault 5.1.2 databases.

Next, we want to be sure there are no connections to the Vault databases. Our installer puts the sgvault database into Single User mode when it upgrades. If there are other processes or queries connecting to sgvault, it can lock out the Vault installer.

You can run this query to see the database connections:

Code: Select all

exec sp_who2

See if sgvault or sgmaster are listed in the DBName column in the results. If so, stop those connections.

Once you're sure there are no active connections, run the installer again.

If it still fails, email support at sourcegear.com, Attn: Linda. Please include a link to this forum post and we'll do further troubleshooting.

By the way -- is either the Vault Server or SQL Server on a VM? We've seen problems upgrading the database when SQL Server was on a VM.

[HansM]

Hi,

I want to give you a little update. I have worked around the problem. Your last tipp does not help me. After running into the error and executing the sql command I only see one connection. I don't know why... So I search for another solution and restored the original version, exported my sources (are not so much), installed the new version with a new database and import the data back to this database. Hope the next update will run without problems. If not i will create a new question

Thanks,
Hans

[lbauer]

That sounds complicated -- but glad you have Vault working again. There may have been a problem with the original database, so creating a new one and importing may have gotten around that.

Let me know if we can be of assistance in the future.