fcoa
Contributor
Contributor

vCenter 4.1 U3 causes error in Performance Overview and Storage Views

I wanted to share this issue and workaround for the good of the order.  Please be aware that VMware has been notified of this issue and the workaround described below may not be supported by VMware.  Please also be aware that there are several other known issues with similar symptoms.  If your issue does not match the symptoms described below, then this workaround is likely not for you.

The issue began after upgrading vCenter from 4.1 U2 to U3.  The symptoms are:

  • Performance Overview indicates the "Report application initialization is not completed successfully"
  • Storage Views "the storage service is not initialized"
  • vCenter Service Status has a "Storage Management Service" error of "Service initialization failed"
  • Licensing Reporting Manager has an error
  • sms.log has "[Microsoft][ODBC Driver Manager] Invalid string or buffer length" errors

Microsoft KB2653857 indicates that this is a known issue with SQL Server 2008 R2 prior to SP2 (as of 12/21/2012, SP2 is not supported by VMware), as well as SQL Server 2008 SP3.  The issue occurs with JBDC connections when "Force Encryption" is enabled on the SQL Server.

To workaround this issue, perform the following steps:

  • Download Java SE 6 U27 and install on a test Windows Server x64 VM.
  • On the vCenter Server:
    • Stop the "VMware VirtualCenter Management Webservices" service
    • Rename "C:\Program Files\VMware\Infrastructure\jre" folder (retain this folder as a backup)
    • Copy the "jre6" folder from the test VM to "C:\Program Files\VMware\Infrastructure\jre"
    • Start the "VMware VirtualCenter Management Webservices" service
Tags (5)
0 Kudos
1 Reply
fcoa
Contributor
Contributor

UPDATE: I have confirmed that Cumulative Update 6 for SQL 2008 R2 SP1 resolves this issue.  While there is no public documentation to support this, I've been told by VMware support that CU6 is supported by VMware.  To obtain CU6, see KB2653857 link above.

0 Kudos