Last week I successfully upgraded my test cluster from 3.5
to vSphere 4.0 and everything works normally with one exception. For every host
and VM the performance overview tab displays the error (see attached), “*Perf Charts service experienced and
internal error. Message: Report application initialization is not completed
successfully. Retry in 60 seconds*.” I have looked everywhere for clues but
so far nothing has come up.
Here’s some background information:
I have a mixed environment with 2-ESX 4 hosts and 7-ESX 3.5
hosts.
VirtualCenter was installed without any errors and all old
VC services were stopped prior to running the install.
VirtualCenter has its DB off box running SQL 2005 using NON-default ports. I have found
which addresses a different Perf Overview error by changing the SQL ports to
default which I can’t do. I really hope this isn’t the fix and it’s a terrible
workaround.
The Apache Tomcat service is starting normally and adjusting
the memory pool hasn’t made a difference.
If anyone has any ideas I would greatly appreciate the help.
Thanks,
Nick
Just in the process of upgrading myself, and am experiencing the same error. Everything else works so far (am up to step 5 on the vSphere upgrade guide, but the overview barfs with the internal error....
I use/administer: ESX 3.5 | VirtualCenter 2.5 | Workstation 6.5 | Vmware Server 2.0 | Windows 2003 | FreeBSD | Redhat EL
Mine has since fixed itself (maybe after a virtualcenter reboot - to upgrade vm tools).
I use/administer: vSphere 4 (ESX) | Workstation 6.5 | Vmware Server 2.0 | Windows 2003 | FreeBSD | Redhat EL
For those out there like me who find all sorts of great answers from the community I have found the solution to my original problem. The short answer is that the error has everything to do with the ports SQL is using.
I moved the database for our test VM infrastructure to a new server that was using default ports and the problem magically resolved itself. However, our production farm DB still does not use the default port and charts continue to error.
If anyone knows a way to configure VirtualCenter to use different ports for the charts please let me know.
Thanks, Nick
Hello!
I had the same problem.
I'm using SQL2005 DB and Non-standard ports.
You have to add the following line to the file "C:\Program Files\VMware\Infrastructure\tomcat\webapps\statsreport\META-INF\context.xml" on vCenter server and restart the "VMware VirtualCenter Management Webservices" service:
url="jdbc:sqlserver://[serverName[\instanceName][:portNumber]];integratedSecurity={true|false}"
The file should looks like this:
....
<Resource auth="Container"
name="jdbc/StatsDS"
url="jdbc:sqlserver://vcenterssqlserver:9876;integratedSecurity=false"
type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
initialSize="3"
....
Best regards
SA3
I have tried to change the line in content.xml, but it didn't help must:(
Our firewall dude noticed that UDP port 1434 was blocked in the firewall.
Opened this port between the VC server and SQL server, and the Overview charts works:)
This is of course if you have a firewall between these servers.
This is for your information:)