Hi Bjoern,
Thanks for the link, I followed the instructions but they didn't fix my problem. I'm not sure how it happened but it seems our database is missing several tables that the upgrade process looks for. After removing a couple lines from the database upgrade script (just the ones renaming the non-existant tables) I finally hit on a foreign key dependency error.
I did notice that the first part of the database upgrade script changes the database version number. Figuring that the database might be mislabelled as 4.1 instead of 4.0 (it's database looked similar to our other VirtualCenter servers which are 4.0) I tried changing the database version to see if that worked but unfortunately it didn't. I'm not entirely sure what's happened to our database but it doesn't seem to be upgradable.
I'm installing a new server and adding all the hosts back in manually. It's only our dev environment so no big loss. If I encounter the same problem with our prod servers I'll come back to this dicussion.
Thanks for your help!
- Dave
