“性能”选项卡上的“常规报告生成异常”警告

Products

• VMware vCenter Server

Issue/Introduction

本文提供将 DatabaseName 添加到 vcdb.properties 文件以解决“性能”选项卡概览报告“常规报告生成异常”问题的步骤。

Symptoms:
免责声明：本文为 "General report generation exception" warning on Performance tab (2148236) 的翻译版本。尽管我们会不断努力为本文提供最佳翻译版本，但本地化的内容可能会过时。有关最新内容，请参见英文版本。

---

• 在选择日/周/月/年时，“概览”性能图表报告：常规报告生成异常 (General report generation exception)，但实时工作正常。
  
• 对于过去的日、周、月和年，高级选项可以正常工作。
• 在 %ALLUSERSPROFILE%\VMWare\vCenterServer\logs\perfcharts\stats.log 文件中, 您会看到类似以下内容的条目:
  
  
  SQL [FAILED!]: SELECT stat_id, device_name, entity, sample_interval, sample_time, stat_value FROM vpxv_hist_stat_daily WHERE (((entity IN ('vm-298599')) AND (stat_id=? AND (device_name IN ('')))) AND sample_time BETWEEN ? AND ?) UNION SELECT stat_id, device_name, entity, sample_interval, sample_time, stat_value FROM vpxv_hist_stat_weekly WHERE (((entity IN ('vm-298599')) AND (stat_id=? AND (device_name IN ('')))) AND sample_time BETWEEN ? AND ?) UNION SELECT stat_id, device_name, entity, sample_interval, sample_time, stat_value FROM vpxv_hist_stat_monthly WHERE (((entity IN ('vm-298599')) AND (stat_id=? AND (device_name IN ('')))) AND sample_time BETWEEN ? AND ?) UNION SELECT stat_id, device_name, entity, sample_interval, sample_time, stat_value FROM vpxv_hist_stat_yearly WHERE (((entity IN ('vm-298599')) AND (stat_id=? AND (device_name IN ('')))) AND sample_time BETWEEN ? AND ?) ORDER BY entity, sample_time, sample_interval
  --36 ERROR com.vmware.vim.stats.webui.chart.StatsChartProcessor] An error occurred during Stats Report generation. Transform to Error Report.
  com.vmware.vim.srs.ReportException: Error while extracting stats data from DB.
  at com.vmware.vim.srs.impl.sql.DatabaseRetriever.getHistorical(Unknown Source)
  at com.vmware.vim.srs.impl.CompositeHistoricRetriever.getHistorical(Unknown Source)
  at com.vmware.vim.srs.impl.StatsReportGeneratorService$2.retrieve(Unknown Source)
  at com.vmware.vim.srs.impl.StatsReportGeneratorService.exatrctAllMetrics(Unknown Source)
  at com.vmware.vim.srs.impl.StatsReportGeneratorService.generate(Unknown Source)
  at com.vmware.vim.srs.impl.StatsReportGeneratorService.generateHistorical(Unknown Source)
  at com.vmware.vim.srs.impl.StatsReportGeneratorService.access$000(Unknown Source)
  at com.vmware.vim.srs.impl.StatsReportGeneratorService$1.visit(Unknown Source)
  at com.vmware.vim.srs.query.HistoricReportQueryBean.accept(Unknown Source)
  at com.vmware.vim.srs.impl.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)

Environment

VMware vCenter Server 5.5.x

Cause

当 vcdb.properties 文件没有有关 DatabaseName 的信息时，便会发生此问题。

Resolution

要解决此问题，请将 DatabaseName 添加到 vcdb.properties 文件中：

1.停止 vCenter 服务和 Web 管理服务

2.创建 vcdb.properties 文件的备份

3.将 databaseName\=VCENTER_DATABASE_NAME 添加到 vcdb.properties 文件下，如下所示:

usevcdb=true

url=jdbc:sqlserver://SQL_SERVER_NAME;databaseName\=VCENTER_DATABASE_NAME;

dbtype=mssql

driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

4.启动 vCenter 和 Web 管理服务。

Additional Information

"General report generation exception" warning on Performance tab