Search the VMware Knowledge Base (KB)
View by Article ID

Performance charts are empty and displays the error: Request processing is restricted by administrator (2107096)

  • 17 Ratings
Language Editions

Details

  • When you select a cluster and view the performance charts, you see the error:

    Request processing is restricted by administrator.


    This message is displayed when you attempt to view performance charts for clusters, resource pools, or other objects. You may see this message for overview charts and for advanced performance charts.

  • When you right-click a host in the vSphere Client and select Report Performance, you see the error:

    A specified parameter was not correct. querySpec.size
    Call "PerformanceManager.QueryStats" for object "PerfMgr" on vCenter Server" failed.


  • In vSphere 5.5 Update 2d and later, a limit is set to the number of entities that are included in a database query. The limit protects the vCenter Server database from receiving large queries.
  • This message is displayed, if entities in the query exceed the limitation:

    Request processing is restricted by administrator

Solution

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 values are 64 for vCenter Server 5.5 and 6.0, and 256 for vCenter Server 6.5
  7. 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.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 a 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. Restart the vCenter service responsible for the performance charts
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.

Note:
  • Cluster metrics are dependent on host or VM metrics. 
  • A single cluster metric value might depend on a single or multiple host or VM metrics. 
  • The maxQueryMetrics limit is exceeded when the metric query count exceeds the default value (64 for vCenter Server 5.5 and 6.0, and 256 for vCenter Server 6.5). 
  • You can set the maxQueryMetrics value 256 for vCenter Server 5.5 and 6.0.
 

Additional Information

For translated versions of this article, see:

Update History

10/31/2016 - Added Product Version 6.5

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 17 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 17 Ratings
Actions
KB: