VMware API data source does not pull any metric rows.

Document ID : KB000047038
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

Though VMware API data source is able to produce the list of hosts when click on "Select resources from Data source", no metric or only configuration metric data is loaded into Data Manager.

Background:

vmware.vim25.RestrictedByAdministrator is the error in DM.log and ca_ccc-stderr*.log files.

1.jpg

This error occurs due to the limitation on Performance charts there by restricting VMware API request processing.

Instructions:

To change the limitation for performance charts you must perform two tasks:

  • Edit the config.vpxd.stats.maxQueryMetrics key in the advanced settings of vCenter Server, or vCenter Server Appliance.
  • Edit the web.xml file.

Change the config.vpxd.stats.maxQueryMetrics Key

  1. In a Web browser, log in to vSphere Web Client.
  2. Navigate to a vCenter Server and click the Manage tab.
  3. On the Settings tab click Advanced Settings.
  4. On the Advanced vCenter Server Setting page, click Edit.
  5. Navigate to the config.vpxd.stats.maxQueryMetrics key and change the value.

    Note: If this is the first time you edit the key, you cannot see it in the list of advanced vCenter Server settings. You must first add the config.vpxd.stats.maxQueryMetrics key. If you added the key incorrectly, you can delete it from C:\ProgramData\VMware\VMware VirtualCenter\vpxd.cfg.

  6. Enter the name of the key and its value, and then click Add.

    The default value is 64. To disable the limit, set a value to -1.

Edit the web.xml File for vCenter Server and vCenter Server Appliance
  1. Navigate to the web.xml file:
    • For vCenter Server Appliance 6.0.x, open /usr/lib/vmware-perfcharts/tc-instance/webapps/statsreport/WEB-INF
    • For vCenter Server Appliance 5.5.x , open /usr/lib/vmware-vpx/tomcat/webapps/statsreport/WEB-INF/web.xml
    • For vCenter Server 6.0.x, open C:\ProgramData\VMware\vCenterServer\data\perfcharts\tc-instance\webapps\statsreport\WEB-INF
    • For vCenter Server 5.5.x, open C:\Program Files\VMware\Infrastructure\Tomcat\webapps\statsreport\WEB-INF
  2. Open the web.xml file using an text editor.
  3. Find the maxQuerySize parameter and change the value in the <param-value> tag. To disable the limit, set a value 0:

    <context-param>
    <description>Specify the maximum query size (number of metrics)for a single report. Non-positive values are ignored.</description>
    <param-name>maxQuerySize</param-name>
    <param-value>64</param-value>
    </context-param>
  4. Save and close the web.xml file.
  5. In the vSphere Web Client, restart the VMware Performance Chart Service.
    For more information, see Start, Stop and Restart Services in the VMware vSphere 6.0 Documentation Center.
Selecting maxQuerySize Value
 
Caution: If you increase the value of the config.vpxd.stats.maxQueryMetrics setting, or if you disable its limit, you might send larger queries to the vCenter Server database. This might cause the following problems:
  • Deterioration in the general responsiveness of the vCenter Server
  • Increased response time to display some of the charts

When you see the Request processing is restricted by the administrator message, if you are in doubt about the value you should set the maxQuerySize parameter, you can start with a value that is above the largest number of virtual machines or hosts in the cluster.

In addition, you can open the vpxd log file and look for the message that displays the number of metrics that exceed the limit.
To see the exact value that exceeds the limit, search the the vpxd.log file for a message similar to the following:
The query size of 65 metrics exceeded the vpxd.stats.maxQueryMetrics limit of 64 metrics. Dropping.
To see data in the performance charts, set the maxQuerySize value to a number greater than 65.
 

Source: VMware Knowledge base 2107096