vSphere 4.1 to 5 Upgrade, Database Update Fails.

GlobalChange · ‎10-18-2011

So I'm trying to update our development VirtualCenter server to 5 and the upgrade fails when it tries to upgrade the database with the error "Exception thrown while executing SQL script". Looking in the VCDatabaseUpgrade.log file I find it's getting stuck on this command:

exec sp_rename 'VPX_LIC_METADATA', 'VPX_LIC_METADATA_OLD';

[10/19/2011 4:18:02 PM] Error: Failed to execute command: exec sp_rename 'VPX_LIC_METADATA', 'VPX_LIC_METADATA_OLD';

[10/19/2011 4:18:02 PM] Got exception: ERROR [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]No item by the name of 'VPX_LIC_METADATA' could be found in the current database 'vCenter', given that @itemtype was input as '(null)'.

[10/19/2011 4:18:02 PM] Error while upgrading: ERROR [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]No item by the name of 'VPX_LIC_METADATA' could be found in the current database 'vCenter', given that @itemtype was input as '(null)'.

[10/19/2011 4:18:02 PM] Info: Exiting Upgrade Wizard

[10/19/2011 4:18:02 PM] Successfully run: alter database [vCenter] set recovery SIMPLE

After restoring the database and looking at it in SQL Explorer I see there is no VPX_LIC_METADATA table, the closest one being VPX_LICENSE.

Anyone have some insight as to why this might be occuring and what I can do to fix it? Let me know if you need any additional info or log files.

Thanks heaps!