I try to upgrade Virtual Center from 2.0 to 2.5. The upgrade fails under SQL upgrade. The SQL database is on a dedicated SQL DB server. I am using SA credentials. The VCDatabaseUpgrade.log is attached.
Here is the error lines from the log. It seems that DROP VIEW VPXV_HIST_STAT is the problem:
INSERT INTO VPX_PRIV_ROLE VALUES ('VirtualMachine.State.CreateSnapshot', 7)
INSERT INTO VPX_PRIV_ROLE VALUES ('VirtualMachine.State.RemoveSnapshot', 7)
drop view VPXV_HIST_STAT
Error: Failed to execute SQL procedure. Got exception: ERROR [ODBC SQL Server Driver][SQL Server]Cannot use DROP VIEW with 'VPXV_HIST_STAT' because 'VPXV_HIST_STAT' is a table. Use DROP TABLE.
Error: Failed to execute command: drop view VPXV_HIST_STAT
Error: Aborting upgrade because of an exception. Exception details: ERROR [ODBC SQL Server Driver][SQL Server]Cannot use DROP VIEW with 'VPXV_HIST_STAT' because 'VPXV_HIST_STAT' is a table. Use DROP TABLE.
Info: Stopping progress monitor
Info: Cleaning Up Database
Info: Rolling back database from version 3 to version 2
Info: Rolling back database from version 3 to version 2
Info: Running Upgrade-v2-to-v3\T-SQL\upd_undo_mssql.sql
if exists (select 1 from sysobjects where id = object_id('VPXV_HIST_STAT') and type = 'V') drop view VPXV_HIST_STAT
create view VPXV_HIST_STAT as select SAMPLE_TIME, SAMPLE_INTERVAL, NAME as STAT_NAME, GROUP_NAME as STAT_GROUP, ENTITY_ID, DEVICE_ID, STAT_VALUE from VPX_HIST_STAT hs, VPX_SAMPLE sa, VPX_STAT_DEF sd where hs.SAMPLE_ID = sa.ID and hs.STAT_ID = sd.ID
delete from vpx_sequence where name in ('VPX_INVENTORY_SEQ')
