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

After migrating the vCenter Server database to a new host, the VMware VirtualCenter Management WebServices service does not function correctly (2010958)

  • 16 Ratings

Symptoms

  • After migrating the vCenter Server database to a new machine with a different hostname and IP address, the VirtualCenter Management Webservices service has connections which persist to the old host.
  • In the vSphere Client, Performance Overview Charts report the error:
General report generation exception
Perf Charts service experienced an internal error.
Message: Report application initialization is not completed successfully. Retry in 60 seconds.

  • Search feature in the vSphere Client does not function.
  • vCenter Service Status shows a red alert for the VirtualCenter Management Webservices service and a number of services are marked as offline.
  • You see an entry similar to:

    Unable to retrieve health data from https://localhost:8443
    Service initialization failed.

Cause

When migrating a vCenter Server database to a new location, you must change the DSN connection to point to the new server. However, this does not modify the Tomcat server settings (VirtualCenter Management Webservices), which maintains a persistent connection to the vCenter Server database that is not controlled through the ODBC/DSN connection.

Resolution

To resolve this issue, you must modify the location of the database settings for the Tomcat server in the configuration file that is named as dabase_name.properties, where dabase_name is the name of the vCenter Server database.This file is located at:

  • Windows 2003 – C:\Documents and Settings\All Users\Application Data\ VMware\VMware VirtualCenter\
  • Windows 2008 – C:\ProgramData\VMware\VMware VirtualCenter\

To modify the location of the database settings for the Tomcat server:

  1. Open the dabase_name.properties file using a text editor.
  2. Locate this entry:

    url=jdbc:sqlserver:// DB_hostname\\DB_instance;databaseName\=database_name;integratedSecurity\=true

  3. Modify the required fields to match the new host name and the location of the database.
  4. Restart the VMware VirtualCenter Management Webservices service in Windows or reboot the vCenter Server machine.
To restart the VMware VirtualCenter Management Webservices service:
  • Log in to the server that is running vCenter Server as an administrator.
  • Click Start > Run, type services.msc, and click OK.
  • In the list of services, right-click VMware VirtualCenter Management Webservices and click Restart.

See Also

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

  • 16 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.
  • 16 Ratings
Actions
KB: