The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Search the VMware Knowledge Base (KB)
View by Article ID
VirtualCenter 2.5 database upgrade fails
Symptoms
VirtualCenter 2.5 database upgrade fails
The%temp%/vcdatabaseupgrade.log file shows the error:
DROP PROCEDURE delete_stats_proc Error: Failed to execute SQL procedure. Got exception: ERROR [42S02] [Microsoft][SQL Native Client][SQL Server]Cannot drop the procedure 'delete_stats_proc', because it does not exist or you do not have permission.
Resolution
The VirtualCenter installer copies SQL scripts to the VirtualCenter machine (the default location is C:\Program Files\VMware\Infrastructure\VirtualCenter Server\dbupgrade).
This error is caused by a script located in Upgrade-v4-to-v5\T-SQL\upgrade_mssql_update3.sql. This script attempts to drop 3 stored procedures:
delete_stats_proc
load_stats_proc
purge_stat1_proc
Note: If you are upgrading to VirtualCenter 2.5 Update 4, the script is located in upgrade_mssql_update4.sql.
You must determine if these procedures exist. If they do not, you must recreate them.
To determine if the procedures exist:
Launch Management Studio Express.
Expand VirtualCenter, Programmability, and Stored Procedures.
A standard VirtualCenter 2.5 installation has these procedures:
delete_stats_proc
load_stats_proc
purge_stat1_proc
purge_stat2_proc
purge_stat3_proc
stats_rollup1_proc
stats_rollup2_proc
stats_rollup3_proc
To recreate the procedures:
Restore a backup of the VirtualCenter database.
Copy all of the scripts located in Upgrade-v4-to-v5\T-SQL to the SQL 2005 machine:
delete_stats_proc_mssql.sql
load_stats_proc_mssql.sql
purge_stat1.proc_mssql.sql
purge_stat2.proc_mssql.sql
purge_stat3.proc_mssql.sql
stats_rollup1_proc_mssql.sql
stats_rollup2_proc_mssql.sq
stats_rollup3_proc_mssql.sql
As database owner of VirtualCenter database, execute the scripts.
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.
