The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
vCenter Server fails to populate performance charts and displays an error message when using a custom JDBC SQL port (1021202)
- While populating the performance charts, vCenter Server might display the error message:
Perf Charts service experienced an internal error
- This might happen when you use a custom SQL server database with a custom Java Database Connectivity (JDBC) SQL port
- This issue does not occur with Oracle or DB2 databases that are configured with custom JDBC ports.
To ensure that the Performance Overview plug-in properly works with the custom JDBC SQL port, you must edit this file:
- In vCenter Server 4.0 – statsreport.xml
In vCenter Server 4.1 – vcdb.properties
In vCenter Server 5.0 – vcdb.properties
Note: These files are located at C:\Documents and Settings\All Users\Application Data\VMware\VMware VirtualCenter\ For Windows 2008 these files are located at C:\ProgramData\VMware\VMware VirtualCenter
To edit the vcdb.properties or statsreport.xml file:
- Open the vcdb.properties or statsreport.xml file.
- Comment this line in the file:
- Set these parameters:
Note: The integratedSecurity parameter depends on this.
SQL DB authentication mode:
- SQL only mode: integratedSecurity should be set to false
- SQL & Windows (Mixed) mode and VMware VirtualCenter Management Webservices is running under Domain\User service account: integratedSecurity should be true
url = jdbc:sqlserver://<hostname>:<port>; databaseName=<VC database name>
integratedSecurity = <true|false>
driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
dbtype = mssql
- Restart the VMware VirtualCenter Management Webservices service on the vCenter Server. For more information, see Stopping, starting, or restarting vCenter services (1003895).
For additional information, see Performance Chart fails after changing the default port on the SQL Server (1035561).
For more information on how to identify the JDBC SQL port being used, see What TCP Port is SQL Server running under ?.
Note: The preceding link was correct as of October 08, 2012. If you find the link is broken, provide feedback and a VMware employee will update the link.
This Article Replaces
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.