Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides

Search the VMware Knowledge Base (KB)

View by Article ID

Upgrading from vCenter Server 4.x to 5.0 fails with the error: Exception thrown while executing SQL script (2032658)

Symptoms

Cannot upgrade from vCenter Server 4.x to 5.0
Upgrading from vCenter Server 4.x to 5.0 fails
You see the error:

Exception thrown while executing SQL script
In the %temp%\VCDatabaseUpgrade.log file, you see entries similar to:

Exception Thrown While Executing SQL Script
[8/1/2012 10:24:19 AM] Error: Failed to execute command: ALTER TABLE VPX_DATASTORE_INFO DROP COLUMN TAGGED_FOR_VMFSUPGRADE_FLG;
[8/1/2012 10:24:19 AM] Got exception: ERROR [42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]ALTER TABLE DROP COLUMN failed because column 'TAGGED_FOR_VMFSUPGRADE_FLG' does not exist in table 'VPX_DATASTORE_INFO'.
[8/1/2012 10:24:19 AM] Error while upgrading: ERROR [42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]ALTER TABLE DROP COLUMN failed because column 'TAGGED_FOR_VMFSUPGRADE_FLG' does not exist in table 'VPX_DATASTORE_INFO'.

Cause

This issue occurs because the vCenter Server installation fails to drop TAGGED_FOR_VMFSUPGRADE_FLG column from VPX_DATASTORE_INFO table because it does not exist in the table.

Resolution

To resolve this issue, log in to the SQL server Management Studio and create a dummy column TAGGED_FOR_VMFSUPGRADE_FLG in the VPX_DATASTORE_INFO table.

To create the dummy column:

Open SQL Server Management Studio.
Enter your login credentials to connect to the SQL server.
Navigate to your vCenter Server database and click Tables.
Double-click dbo.VPX_DATASTORE_INFO.
Right-click Columns and click New Column.
Under Column Name enter TAGGED_FOR_VMFSUPGRADE_FLG.
Select the Allow Null option.
Click File > Save TAGGED_FOR_VMFSUPGRADE_FLG.
Restart the upgrade process.

Note: The dummy column created is removed during the upgrade process.

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.

Feedback

1 2 3 4 5
1 Ratings

1 2 3 4 5
1 Ratings

Actions

Bookmark Document

KB:

Did this article help you?
This article resolved my issue. This article did not resolve my issue. This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)