Error upgrading server - "Error Code = -1280"

javierpelaezt · Post by **javierpelaezt** » Fri Jul 18, 2008 5:48 pm

Hello everyone,

First I tried to upgrade Vault Server from version 3.1.6 to version 4.1.1, and I kept getting the following error:

"Upgrading SourceGear Vault stored procedures...Database 'sgvault' is already open and can only have one user at a time.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280"

I found the following thread about a user that had a similar issue:

http://support.sourcegear.com/viewtopic.php?=&p=30226

But.... since its a Gold Support only forum, I couldn't post there...

Anyway, I followed one of many advices posted there and tried to do incremental upgrades, and somehow I managed to ugrade to 3.1.9 without doing anything special. But after that, the error appeared again and I haven't been able to install any other version.

I took a look at the installation log, but it doesn't say anything to me... perhaps someone here can help me... I really need some help because the server is right now not usable (vaultservice is not operational, so nobody can work).

I have a backup of the database prior to the first upgrade attempt. I'm executing the installer as a domain Administrator, and using Windows Authetintication to connect to the SqlServer 2005 database (which is in a server that is part of the domain).

Also I'm attaching the installation log file.

Thanks in advance for your help,

Javier

lbauer · Post by **lbauer** » Fri Jul 18, 2008 11:00 pm

If you need to work right away, I'd suggest restoring the 3.1.6 backup and reinstalling Vault 3.1.6. We'll need to have a developer take a look at this and our offices are closed over the weekend.

Keep a copy of the database that failed to upgrade. We may want to take a look at it.

Email support at sourcegear.com Attn: Linda, and include a link to this forum post. I'll have some questions for you.

mskrobul · Post by **mskrobul** » Sun Jul 20, 2008 10:42 am

You should try installing 4.1.2 instead of 4.1.1. There was fix in 4.1.2 for occasional upgrades failing due to "Vault db in single-user mode".

Here are the 4.1.2 release notes:

http://support.sourcegear.com/viewtopic.php?t=10343

You can download 4.1.2 from here:

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