Upgrade VirtualCenter to 40644 Patch 2 errors 25014

[mwiseley]

Tried to upgrade Virtual Center to the latest patch and I get this error during upgrade. Error 25014. Setup failed to upgrade the vpxd_stats_rollup procedure in the Virtual Center database. I can understand why as when I look in the database the SP is vpx_stats_rollup. Is this a bug or am I missing something. Please advise.

thanks,

[RichEB]

Do you have Patch 1 installed?

[tla-scc]

I have the same issue and do have Patch 1 installed. After receiving this error the Virtual Center Server will not start. It starts after doing a repair on the application. Unfortunately I cannot reboot the server to see if that resolves the issue.

I've considered copying the vpx_stats_rollup stored procedure to vpxd_stats_rollup but am concerned I may be introducing other problems in doing so.

DB - MS SQL 2005

OS - W2K3 SP1 fully patched

[GabbyIRL · Accepted solution]

Did you follow the Pre-Upgrade tasks for SQL Server in the release notes?? THere are 2 one which specifically mentions Performance Stats Roll-up. I use an Oracle database and had similar Pre-Upgrade steps after which the upgrade to 40644 went without a problem. Here is the section you need

Pre-Upgrade Tasks for Microsoft SQL Server:

Note that for Microsoft SQL Server or Microsoft SQL Server 2005, the SQL Server ODBC driver is the only driver supported for use with VirtualCenter Server. Verify that the ODBC driver configured for the database is the SQL Server driver—if it’s not, you must re-configure using the SQL Server driver prior to attempting to upgrade or install this update, or the installation will not succeed.

If you implemented the "VirtualCenter Performance Stats Rollup Workaround" (a VMware support document that provides instructions for setting up three scheduled SQL Server jobs to circumvent the deadlock issue), you must remove these jobs from the Microsoft SQL Server job scheduler (using SQL Server Enterprise Manager) prior to installing this update. If you did not configure scheduled jobs as a workaround, you can disregard this pre-upgrade task. However, be sure to backup your database prior to upgrading.

[frapposelli]

If you're using SQL Server it's probably the ODBC Driver, don't use SQL Native Client, use SQL Server.

HTH,

Fabio

[meistermn]

I think if your virtual center server os is windows 2003 sp1 or R2 Release

you have no upgrade to do for the odbc driver.

"To upgrade the SQL Server ODBC drivers, you will need to install what Microsoft calls MDAC (Microsoft Data Access Components). The latest MDAC can be downloaded from Microsoft at www.microsoft.com/data. \[6.5, 7.0, 2000] Updated 2-20-2006"

Source http://www.sql-server-performance.com/odbc_oledb.asp

Meistermn

[Andreas_Kinzl]

check if there is a procedure vpxd_stats_rollup[/b] in the db.

(use Enterprise Manager or SQL Mangement Studio).

if there is a procedure rename it and try the update again -> for me this was the solution

[tla-scc]

Thanks for the help !

Changing to SQL Client from SQL Native Client allowed the upgrade to complete.

I did have one issue with one of my VI 3.0.1 boxes. I could not reconnect to it until I ran the vpx-upgrade-esx-6-linux-40644 script from C:\Program Files\VMware\VMware VirtualCenter 2.0\upgrade. After running this script all is well.