VMware Cloud Community
tuensel2k
Contributor
Contributor

Performance Charts are not working as supposed on Host / VM level

Hello Everybody,

I have the problem that the Performance Charts in my vCenter for host and VM objects only work in the time range "Realtime" if i select another option i get following error:

"General report generation exception" the strange thing is that on my Cluster view it´s working correct.

I´m using an Oracle 10.2.04 Database with the Oracle instant Client, my vCenter is running as VM (Windows 2003 Server R2 64 bit) on a DELL Poweredge R710.

I allready tried following steps to fix the problem without success:

  • increasing Tomcat timeout form 1 to 3 minutes (but database speed themes fine)

  • adding the hostname in the file C:\VMware\Infrastructure\VirtualCenter Server\extensions\com.vmware.vim.stats.reportéxtension.xml (but DNS is working fine)

  • copied ojdbc14.jar to C:\VMware\Infrastructure\tomcat\lib

Has anybody a clue how to get rid of this problem?

Best regards

Daniel

Reply
0 Kudos
5 Replies
Troy_Clavell
Immortal
Immortal

maybe this will help?

http://kb.vmware.com/kb/1012812

tuensel2k
Contributor
Contributor

Hello,

i checked the the link you posted and checked the listed options but i couldn´t find a configuration error.

Here is the error that occurs in stats.log

com.vmware.vim.stats.webui.chart.StatsChartProcessor : An error occurred during Stats Report generation. Transform to Error Report.

com.vmware.vim.stats.report.ReportException: Unable to extract raw stats data (from DB or VC). Details: Error wile extracting stats data from DB.

at com.vmware.vim.stats.report.impl.service.StatsReportGeneratorService.generate(Unknown Source)

at com.vmware.vim.stats.webui.chart.StatsChartProcessor.generateStatsReport(Unknown Source)

at com.vmware.vim.stats.webui.chart.StatsChartProcessor.process(Unknown Source)

at com.vmware.vim.stats.webui.chart.StatsChartServlet.handleChartImage(Unknown Source)

at com.vmware.vim.stats.webui.chart.StatsChartServlet.doGet(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.valves.CometConnectionManagerValve.invoke(CometConnectionManagerValve.java:248)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)

at java.lang.Thread.run(Thread.java:595)

thanks in advance and best regards

Daniel

Reply
0 Kudos
AndreTheGiant
Immortal
Immortal

Have you enabled the SQL Browser service in your vCenter Server?

Andre

Andrew | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
Reply
0 Kudos
tuensel2k
Contributor
Contributor

Is this services needed for a oracle 10.2.04 database?

regards

Daniel

Reply
0 Kudos
tuensel2k
Contributor
Contributor

I finally was able to fix this problem.

The problem is located in the tsnnames.ora :

--> vcenter connects to the database by "example.world."

--> the tomcat connects to the dabtabase by "example"

After i changed my tsnnames.ora all is working fine.

EXAMPLE.WORLD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = DB)(PORT = 1521))

)

(CONNECT_DATA = (SID = EXAMPLE)(SERVER = DEDICATED))

)

EXAMPLE =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = DB)(PORT = 1521))

)

(CONNECT_DATA = (SID = EXAMPLE)(SERVER = DEDICATED))

)

regards

Daniel

Reply
0 Kudos