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
maybe this will help?
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
Have you enabled the SQL Browser service in your vCenter Server?
Andre
Is this services needed for a oracle 10.2.04 database?
regards
Daniel
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