Problems upgrading from 3.0.7 to 5.0

[tx.daniel]

Hi,
We recently purchased the upgrades from 3.0.7 to 5.0. During the upgrade process, we've ran into problems during the database conversion. I've tried upgrading to 3.1.9 first, to 4.0.6 and to 5.0.3 directly (all done on a backup of our production vault of course!). The last few lines of the installation log are:
Read vault_upgrade.sql from our resources.
Upgrading SourceGear Vault database schema...Vault Setup is exiting due to a failure or cancellation. Error Code = -1280
Database 'sgvault' is already open and can only have one user at a time.
Database 'sgvault' is already open and can only have one user at a time.
Caution: Changing any part of an object name could break scripts and stored procedures.
The statement has been terminated.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280ExitCode on exit: -1280

The upgrade is being done with a dbo user to the database server.

[Beth]

Were you on the last upgrade from Vault 4.1.4 to Vault 5.0.4 when you received that last error?

If you still have your database at the point of upgrading from Vault 4.1.4 to Vault 5.0.4, then I can have you try that step again after one change. Open your SQL Server Management Studio, expand databases, right-click sgvault and select properties. Click on the Options link, then scroll down to the last setting on the right side of the window. Change the Restrict Access setting from Single to Multiple and click OK. Now try running the upgrade from Vault 4.1.4 to Vault 5.0.4 again.

[tx.daniel]

Hi Beth,
Thank you for your response. Actually, this error is happening on any upgrade after 3.0.7. Our database is currently stuck on version 3.0.7 and haven't been able to upgrade any further.

Thanks!

[Beth]

I'd like you to try the same actions for putting the database into multi user mode and then try upgrading. It should give you a different error.

It sounds like you may have tried upgrading multiple times. The single user mode error usually pops up after a failed upgrade, because the first failure leaves the database in single user mode. By changing that setting and trying again, I hope to see the real reason it wouldn't upgrade the first time.

[tx.daniel]

Hi,
I tried a couple of different things. I restored a backup of the vault database (at 3.0.7) (since i'm still in the testing phase, it's no big deal), made sure it was on Multi_user, and ran the 3.1.9 upgrade. I'm attaching the log for this process as 1st_vault_install.txt. I went to the db and it was indeed on single_user mode. I changed it back to multi-user, and reran the upgrade. The log for that try is vault_install.txt.

Thanks for your help!

[Beth]

I have something that may take care of the upgrade of the database from 3.0.7 to 3.1.9, but I'll have to send it via email. Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread? Then we'll just take this offline.

Email was received and issue was resolved offline.
HS: 220889