Search the VMware Knowledge Base (KB)
View by Article ID

Upgrading VMware vCenter Server 4.0/4.1 fails with the error: Setup found that multiple schemas exist in the database (1011386)

  • 12 Ratings

Symptoms

When upgradingvCenter Server, you experience these issues:
  • The Upgrade Wizardfails
  • You see theerror:

    Setup found that multiple schemas exist in the database. Please remove the extra schemas before continuing.

Cause

This issue occurs when:
  • The vCenter Server databaseis configured with a custom schema.

    Note: This may also causefuture upgrade problems. For more information, see After upgrading or reinstalling the vCenter Server with the same database the inventory is empty (1005157).

  • You have multiple vCenter Server database entries in the ODBC connections window. Ensure that you have only a single database.
  • The vCenter Server database contains more than one schema.To determine if this is the case, execute the SQL query:

    SELECT distinct sys.schemas.name AS schema_name FROM sys.objects INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id and sys.schemas.name <>'sys'


    To list the database objects from each schema, execute this SQL query:

    SELECT sys.schemas.name,sys.objects.name AS schema_name FROM sys.objects INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id and sys.schemas.name <>'sys' and sys.schemas.name like 'Other Schema Name%'

Resolution

Note: If the vCenter Server database tables are not configured with the dbo schema, change all tables, views, and stored procedures to use the dbo schema. In the vCenter Server database table, if you see dbo .VPX_ALARM, the .VPX_ALARM is associated with the dbo schema and not a custom schema.
 
To change the schema associated with your tables, views, and stored procedures in SQL 2000 and SQL 2005, see the Microsoft Knowledge Base article 275312 . For more information on SQL 2005 and above, see Microsoft article ALTER SCHEMA (Transact-SQL).

To resolve this issue:
  1. Backup the vCenter Server database.
  2. Launch SQL Server Management Studio.
  3. Open a new SQL query window and focus on the vCenter Server database.
  4. Execute the code in the Microsoft Knowledge Base article 275312.
  5. Open a new SQL query window, focus on the vCenter Server database.
  6. Execute the code:

    exec chObjOwner 'OldUserName','dbo'

  7. Open a new SQL query window and focus on the vCenter Database.
  8. Execute the commands output from Step 6.
Note: The preceding links were correct as of October 7, 2015. If you find a link is broken, provide feedback and a VMware employee will update the link.

Additional Information

For information on upgrading a the vCenter Server database to SQL Server 2008 see SQL Express 2005 to SQL Server 2008 (1028601).

See Also

This Article Replaces

1017410

Update History

09/30/2010 - Updated to reflect newer versions of vCenter Server. 04/20/2012 - Added the SQL query to list the database objects from each schema

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

  • 12 Ratings

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)




Please enter the Captcha code before clicking Submit.
  • 12 Ratings
Actions
KB: