error upgrading to Vault 5.0.2 (19281) to 6.0.1.598

[allanh]

I have two vault 5.0.2 servers. Both on Amazon VMs. Windows 2008 server R2, SQL server 2008 R2

One was originally created in version 5 with only recent data from C#projects.
The other is older with data upraded from version 3.1.5 and source off site before that and Visual source safe before that.

The only reason we have two is due to the older one was stuck at v3.1.5 for a while and wouldn't updrade to V4.1 (says our previous admin). But we needed a V5 for C# projects in Visual Studio, so we ran two separate ones. I have since upgraded it to v5 no problem.

Now when I am upgrading them both to V6 with a desire to recombine them back into one server, the one with the old data won't upgrade. The newer one upgraded fine and I have everything setup pretty much the same on both amazon servers.

during the install after successfully authenticating I get this:

Code: Select all

upgrading SourceGear source control database schema...The statistics 'pluginurlhash' is dependent on column 'triggerevent'.
The statistics 'pluginname' is dependent on column 'triggerevent'.
ALTER TABLE ALTER COLUMN triggerevent failed because one or more objects access this column.
Vault Standard Setup is exiting due to a failure or cancellation. Error Code = -1280

I get left in single user mode which I fixed, but even after restoring the sgvault database i can't connect to it via a V5 or V6 client. i think the IIS services are not functioning anymore. I assume that is solvable, but i really would rather push through and get this install up to V6.

What can I do?

Thanks,

Allan

[Beth]

Are you able to upgrade the Vault server that you returned to Vault 5.0.2 up to Vault 5.1.2?

All the previous installer versions can be found on this page: http://www.sourcegear.com/vault/downloads2.html. See if it will go up to that level, and then try to bring up the web client and login from there. The web client is at http://<your Vault server>/vaultservice/vaultweb.

[allanh]

Oops, my bad. I am already on 5.1.2

[Beth]

Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread?

[allanh]

Thanks to a very prompt online remote session with Beth, the problem is solved.

Apparently if one's vault data that has gone through a few rounds of upgrades, the table tblPlugins in the sgvault database may have some 'statistics' referencing the triggerEvent column. The Vault Standard V6 installer needs to modify that column and can't while these statistics exist. After a fair amount of investigative work we discovered that all we have to do is manually remove the statistics named pluginName and pluginUrlHash and the install will complete fine. Vault 6 doesn't use them.

deletestatistics2.gif (21.14 KiB) Viewed 5249 times

I would like to thank Source Gear in general and Beth in particular for helping me with this upgrade issue so quickly. Often the support from companies start with several rounds of canned responses that make it clear they never read the reported issue all that closely. To get someone actually qualified to assist with a problem of such a technical nature on such short notice via remote session is remarkable indeed and deserves recognition.

Allan Holder
Kalibur Solutions Inc.

[Beth]

Thanks for posting the update.

I'm not sure that what you saw resulted from updating from updating from older versions of Vault. It's possible as well for a named statistic to have been put in place by a past admin since all the information is there. This hasn't been seen yet with other customers.

For other customers, you see this same issue, please place a report of it on this thread.

[allanh]

I only speculate that the statistics are left over from previous versions. Perhaps there is another explanation.

But I don't think anyone at my organization would have created these statistics manually.

Either way i am just glad it's solved and if it can save others a day of work then it will have been worth it. Ideally the V6 installer will take care of this in the future.

Thanks Again.