Upgrade failed to update database

[Anupreet01]

Database logs below
[4/15/2013 10:58:28 AM] Info: Beginning upgrade process....
[4/15/2013 10:58:28 AM] Info: VMware VirtualCenter has been detected as a SQL server.
[4/15/2013 10:58:28 AM] Info: DSN=VMware VirtualCenter UID= LOGFILE=VCDatabaseUpgrade.log SERVICE=vctomcat;vpxd HELPPATH=null QUIET=true
[4/15/2013 10:58:28 AM] Stopping service vctomcat.
[4/15/2013 10:58:29 AM] Stopping service vpxd.
[4/15/2013 10:59:15 AM] Original recovery mode is SIMPLE
[4/15/2013 10:59:15 AM] Successfully run: alter database [VIM_VCDB] set recovery bulk_logged
[4/15/2013 10:59:15 AM] Preparing upgrade.
DELETE FROM VPX_TABLE
[4/15/2013 10:59:15 AM] Error in RunSqlScriptNonQuery(): Got exception: ERROR [42S02] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'VPX_TABLE'.
DELETE FROM VPX_INDEX_COLUMN
[4/15/2013 10:59:15 AM] Error in RunSqlScriptNonQuery(): Got exception: ERROR [42S02] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'VPX_INDEX_COLUMN'.
DELETE FROM VPX_SCHEMA_HASH
[4/15/2013 10:59:15 AM] Error in RunSqlScriptNonQuery(): Got exception: ERROR [42S02] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'VPX_SCHEMA_HASH'.
[4/15/2013 10:59:15 AM] Done preparing upgrade.
[4/15/2013 10:59:15 AM] Info: Initiating progress bar
[4/15/2013 10:59:15 AM] Total lines to execute: 0
[4/15/2013 10:59:15 AM] Info: Upgrading database from version 4.1 to version 5.0
[4/15/2013 10:59:15 AM] Upgrade-v410-to-vMN\MSSQL\upgrade_mssql.sql
[4/15/2013 10:59:16 AM] Error while upgrading: The device is not ready.

[4/15/2013 10:59:16 AM] Info: Exiting Upgrade Wizard
[4/15/2013 10:59:16 AM] Successfully run: alter database [VIM_VCDB] set recovery SIMPLE

[turls]

EXACT same log here.  And it left my vCenter Server unusable.

[Dave_Mishchenko]

The discussion has been  moved from VMware ESXi 5 to VMware vCenter™ Server.

You might want to check the space for the transaction log file if you're able to run this again.

[cypherx]

Any updates on this?  I would like to know the solution?

[GaneshNetworks]

Make sure that you have enough free space available in transaction log drive and make sure that you followed the best practices: http://www.vmware.com/files/pdf/techpaper/vSphere-5-Upgrade-Best-Practices-Guide.pdf