Knowledge Base

Troubleshooting

1. Open Windows Explorer.
2. Navigate to:
   
   %ProgramFiles%\VMware\Infrastructure\tomcat\logs\
   
   Note: In vCenter Server 4.1, the stats.log file is located at C:\ProgramData\VMware\VMware VirtualCenter\Logs\.
   
   
3. Search the stats.log file for the words [ERROR] or [FATAL].
4. Record any events that have been logged with the above words. Proceed to Causes to troubleshoot these events.

Causes

TCP Port Usage

[ERROR] com.vmware.vim.stats.webui.startup.StatsApplicationLauncher : Task execution produced an error. Re-initialization attempt #62 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.

1. Click Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.
2. Click SQL Server 2005 Network Configuration > TCP/IP > TCP/IP Properties > IP Addresses.
3. Confirm the TCP Port setting in IP1, IP2 and IPAll.
4. If changing the port, input the port in IP1, IP2 and IPAll, then click OK.
5. Restart the VirtualCenter Management Webservices. For more information, see Stopping, starting, or restarting vCenter services (1003895).
   
   Note: If you are using a different version of Microsoft SQL or a different database service, consult the vendor documentation on how to change the TCP/IP settings for your database server.

1. Click Start > Programs > Microsoft SQL Server 2008 > Configuration Manager
2. Click Protocols for MSSQLSERVER > TCP/IP > TCP/IP Properties > IP Addresses
3. Confirm the TCP Port setting in IP1, IP2 and IPAll.
4. If changing the port, input the port in IP1, IP2 and IPAll, then click OK.
5. Restart the VirtualCenter Management Webservices. For more information, see Stopping, starting, or restarting vCenter services (1003895).
   
   Note: If you are using a different version of Microsoft SQL or a different database service, consult the vendor documentation on how to change the TCP/IP settings for your database server.
   

 

[ERROR] com.vmware.vim.stats.webui.startup.StatsApplicationLauncher : Task execution produced an error. Re-initialization attempt #62 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.

1. Stop the VMware VirtualCenter Management Webservices service on the vCenter Server. For more information, see Stopping, starting, or restarting vCenter services (1003895).
2. Open Windows Explorer.
3. Locate the file context.xml at ProgramFiles%\VMware\Infrastructure\tomcat\webapps\statsreport\META-INF\.
   
   Note: In vCenter Server 4.0 Update 1, the configuration file is located at C:\Program Files\VMware\Infrastructure\tomcat\conf\Catalina\localhost\statsreport.xml.
   
4. Open context.xml and locate the line that appears similar to:
   
   <Resource auth="Container" name="jdbc/StatsDS" url="jdbc:sqlserver://<serverName>:<port>;instanceName=<instanceName>;
   databaseName=<databaseName>;integratedSecurity=true" />
   
5. Change the url= statement to explicitly state the JDBC connection with a port number.
   
   Note: Ensure that the line is not commented using the <!-- and --> characters.
   
   For example, if you are using an Oracle database, change the url= statement to:
   
   url="jdbc:oracle:thin:@<ip/fqdn or netbios name of oracle server>:<port of oracle server>:<SID>"
   username="<dbUsername>"
   password="<dbPassword>"
   
   Note: Only use a username and password when absolutely necessary. If SYSTEM_DSN is used then there is a bridge between the ODBC cached username/password to the Oracle JDBC driver and the credentials do not need not be specified here.
   
   If you are using a Microsoft SQL database change the url= statement to:
   
   <Resource auth="Container" name="jdbc/StatsDS" url="jdbc:sqlserver://VCS:1433;instanceName=SQLEXP_VIM;databaseName=
   VIM_VCSDB;integratedSecurity=true;" />
   
   Notes:
   
   • The content within the < > brackets must be set to your servername, port, instancename and databasename.
   • If no instanceName is available, the instanceName value is the same as the SQL servers NETbios name.
   • The plugin uses Java Database Connectivity (JDBC) to connect to the database. In the URL, ensure that the sqlserver shortname, port, instance name and database name are configured correctly.
   • For remote SQL servers, when using SQL authentication you may have to change integratedSecurity=true to integratedSecurity=false. If the line does not exist in the file, you can insert it.
     
6. Start the VirtualCenter Management Webservices service. For more information, see Stopping, starting, or restarting vCenter services (1003895).
   
   Note: In some cases restarting the VirtualCenter Management Webservices is not required.
   

Registry or Configuration File Settings

1. Click Start > Run, type regedit, and click OK.
   
   Note: For 64-bit Windows operating systems, type %systemroot%\syswow64\regedit and click OK.
   
   
2. Navigate to the key \HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\<odbc_name> on 64 bit systems or \HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<odbc_name> on 32 bit systems.
   
   Note: The <odbc_name> represents the name of the appropriate ODBC connection.
   
   
3. Click Edit > New > String value.
4. Edit the name column to Server.
5. Edit the value column include the SQL Server's fully qualified domain name (FQDN).
6. Restart VirtualCenter Management Webservices. For more information, see Stopping, starting, or restarting vCenter services (1003895).

This issue can occur if your browser settings are incorrect. For more information, see Performance Overview charts do not work (1028501).

[FATAL] com.vmware.vim.stats.webui.startup.VcDataSourceInitializer : Unable to open VC DataSource. Details: Cannot create PoolableConnectionFactory (Login failed for user org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user...

1. Click Start > Settings > Control Panel, then double-click Administrative Tools.
2. Double-click Services.
3. Right-click the VirtualCenter Server service, and click Properties.
4. On the Log On tab, change the password, and click Apply.
5. On the General tab, click Start to restart the service. For more information, see Stopping, starting, or restarting vCenter services (1003895).
6. Repeat steps 2 to 5 for the vSphere Management Webservice service.
7. Quit the Services tool.

Oracle Java Dependencies

1. Go to the Oracle Technology Network and download the ojdbc5.jar file that is distributed with Oracle 11g or later.
   
   Note: ojdbc5.jar is compatible with both Oracle 10g and 11g databases.
   
   
2. Copy the downloaded file to %ProgramFiles%\VMware\Infrastructure\tomcat\lib.
3. Click Yes when prompted to overwrite the existing file.
4. Restart VirtualCenter Management Webservices. For more information, see Stopping, starting, or restarting vCenter services (1003895).

1. Click Start > All Programs > VMware > VMware Tomcat > Configure Tomcat.
2. In the Java tab, ensure the Java Virtual Machine (JVM) entry points to %ProgramFiles%\VMware\Infrastructure\jre\bin\server\jvm.dll.
3. Restart the VirtualCenter Management Webservices. For more information, see Stopping, starting, or restarting vCenter services (1003895).

• com.vmware.vim.stats.webui.StatsReportException: Unable to open VC DataSource.
• Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The connection to the named instance has failed. Error: java.net.SocketTimeoutException: Receive timed out.)
• Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the named instance has failed. Error: java.net.SocketTimeoutException: Receive timed out.

1. Connect to the SQL server running the vCenter Server database.
   
   Note: This may be local or remote to the vCenter Server. To locate the ODBC System DSN configuration settings, see vCenter Server installation fails with ODBC and DNS errors (1003928).
   
   
2. On the server with SQL installed, click Start > Run, type services.msc, then press Enter.
3. Right-click the SQL Browser service and click Properties.
4. Ensure that the SQL Browser is set to Automatic and that the Service Status is Started.

1. To check this, open a dos window and type:
   
   echo %TNS_ADMIN%
   
   
2. If it does not return the location of TNS_ADMIN (for example C:\Oracle) then set the path in the Environment Variables.
3. Add the new environment variable under System , Name the key as TNS_ADMIN and set the Value to the directory containing the tnsnames.ora file. For example, C:\Oracle.
4. Click OK to save the settings.
5. Restart the Web Services and check if the issue persists.