Loading

×Sorry to interrupt
CSS Error

Refresh

Cookie Preference Center

General Information on cookies

When you visit our website, we use cookies to ensure that we give you the best experience. This information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience on the site and the services we are able to offer. Further information can be found in our

Cookie Policy.

Strictly Necessary

Strictly Necessary

Always Active

Strictly Necessary

Strictly necessary cookies are always enabled since they are essential for our website to function. They enable core functionality such as security, network management, and website accessibility. You can set your browser to block or alert you about these cookies, but this may affect how the website functions. For more information please visit www.aboutcookies.org or www.allaboutcookies.org.

Cookie Details‎

Performance

Performance

Performance

Performance cookies are used to analyze the user experience to improve our website by collecting and reporting information on how you use it. They allow us to know which pages are the most and least popular, see how visitors move around the site, optimize our website and make it easier to navigate.

Cookie Details‎

Please confirm your settings by refreshing the page.

Functional

Functional

Functional

Functional cookies help us keep track of your past browsing choices so we can improve usability and customize your experience. These cookies enable the website to remember your preferred settings, language preferences, location and other customizable elements such as font or text size. If you do not allow these cookies, then some or all of these services may not function properly.

Cookie Details‎

Advertising

Advertising

Advertising

Advertising cookies are used to send you relevant advertising and promotional information. They may be set through our site by third parties to build a profile of your interests and show you relevant advertisements on other sites. These cookies do not directly store personal information, but their function is based on uniquely identifying your browser and internet device.

Cookie Details‎

Advertising Cookies

Consent Leg.Interest

Select All Vendors

Select All Vendors

Select All Hosts

Select All

Clear Filters

Information storage and access

Apply

Confirm My Choices Reject All Allow All

My Subscriptions

Loading

Knowledge Base

Unable to see performance charts in vCenter Server (1026433)

Last Updated: 6/18/2020Categories: TroubleshootingTotal Views: 13541Language:
English

Subscribe to get an email
newsletter with new updates

Please provide article feedback:

Symptoms

Performance charts fail to load in vCenter Server

Unable to see performance data in the vSphere Client when connected to vCenter Server

Viewing performance statistics from vCenter Server is not possible

The stats.log file contains entries similar to:

[05 Aug 10, 11:42:01] [INFO] com.vmware.vim.stats.webui.util.VcDbConnectionInfo : VC DB connection initialized from WinRegistry with parameters: DbUrl = jdbc:sqlserver://vCenterSQLServer;instanceName=SQL_VIM;databaseName=VCDB; DbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver; DbUser = vcuser
[05 Aug 10, 11:42:02] [ERROR] com.vmware.vim.stats.webui.startup.StatsApplicationLauncher : Task execution produced an error. Re-initialization attempt #1264 will startup after 60 seconds... java.util.concurrent.ExecutionException: java.lang.IllegalStateException: com.vmware.vim.stats.webui.StatsReportException: Unable to open VC DataSource.
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205)
at java.util.concurrent.FutureTask.get(FutureTask.java:80)
at com.vmware.vim.stats.webui.startup.StatsApplicationLauncher$1.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.IllegalStateException: com.vmware.vim.stats.webui.StatsReportException: Unable to open VC DataSource.
at com.vmware.vim.stats.webui.startup.StatsApplicationLauncher$1$1.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:65)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:172)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676)
... 1 more
Caused by: com.vmware.vim.stats.webui.StatsReportException: Unable to open VC DataSource.
at com.vmware.vim.stats.webui.startup.VcDataSourceInitializer.init(Unknown Source)
at com.vmware.vim.stats.webui.startup.StatsReportInitializer.createInitializers(Unknown Source)
at com.vmware.vim.stats.webui.startup.StatsReportInitializer.init(Unknown Source)
... 9 more
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.vmware.vim.stats.webui.startup.VcDataSourceInitializer.openVcDataSource(Unknown Source)
... 12 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 14 more

Resolution

The messages recorded in the stats.log file indicate that the connection has been refused by the SQL server.

To determine why the connection was refused:

Determine what port is being used on the SQL server, and ensure that this port is included in the connection string.

Note: The ports can vary from site to site due to security reasons. The onsite DBA (Database Administrator) should have these details.

If the database is running on an instance of your SQL server, Tomcat may encounter issues while trying to connect to the database through its jdbc connection. Creating an alias may resolve these issues. To create an alias if your SQL instance is on vCenterSQLServer\SQL_VIM:

Note: This procedure modifies the Windows registry. Before making any registry modifications, ensure that you have a current and valid backup of the registry and the virtual machine. For more information on backing up and restoring the registry, see the Microsoft Knowledge Base article 136393.

The preceding link was correct as of March 13th 2013. If you find the link is broken, provide feedback and a VMware employee will update the link.

On vCenter Server, click Start > Run, type regedit, and click OK.

Navigate to HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo .

Create a new string value where the name is SQL_VIM and the value is DBMSSOCN,vCenterSQLServer\SQL_VIM.

Go to the ODBC Data Sources by clicking Start > Programs > Administrative Tools > Data Sources (ODBC).

Edit the DSN settings by changing the SQL server name from vCenterSQLServer\SQL_VIM to SQL_VIM.

Ensure that the vCenter Server and your Database Server are able to resolve each other's DNS names. If DNS resolution is not working correctly in both directions, then connections may be refused.

Look for messages or errors in the event logs of the SQL Server concerning DNS registration issues.

Verify DNS configuration using the Windows NSlookup Utility.

Related Information

The stats.log file can be found in these locations:

vCenter Server 4.0.x running on a 32-bit version of Windows:

C:\Program Files\Vmware\Infrastructure\Tomcat\Logs\

vCenter Server 4.0.x running on a 64-bit version of Windows:

C:\Program Files (x86)\Vmware\Infrastructure\Tomcat\Logs\

vCenter Server 4.1.x running on 64-bit version of Windows 2003:

C:\Documents and Settings\All Users\Application Data\VMware\VirtualCenter Server\Logs\

vCenter Server 4.1.x running on 64-bit version of Windows 2008:

C:\ProgramData\VMware\VirtualCenter Server\Logs\

For additional information relating to DNS, see these Microsoft articles:

Verifying DNS Design and Configuration

How to Use the DNS Resolver to Verify DNS Configuration

How to Use Nslookup to Verify DNS Configuration

Note: The preceding links were correct as of October 15, 2010. If you find the links are broken, please provide feedback and a VMware employee will update the links.

Detectable by VMware SkylineTM

Actions

Copy

link to clipboard
copied!

Print

Language:
English

Attachments

Additional Resources

KB
•
End Of General Availability of the Free vSphere Hypervisor (ESXi 7.x and 8.x) (2107518)

KB
•
在 VMware Converter 3.0 中进行转换后静态 IP 设置丢失 (1005595)

KB
•
vCenter Server 上报错：“登录失败: 尚未在该计算机上授予此用户所请求的登录类型” (2148054)

Results 1-3 of 3

Ask The Community

Get answers quickly from VMware experts in the community

Post Subject

CONTINUE IN COMMUNITIES

Related Products:

VMware vCenter Server

Related Versions:

VMware vCenter Server 4.1.x

VMware vCenter Server 4.0.x

Take Our Survey

Support Assistant