• 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

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

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></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

• • For vCenter Server 6.x, restart the VMware Performance Chart Service in the vSphere Web Client. For more information, see Start, Stop and Restart Services in the VMware vSphere 6.0 Documentation Center.
  • For vCenter Server 5.5.x, restart the VMware VirtualCenter Management Webservices service. For more information, see How to stop, start, or restart vCenter Server Appliance services and How to stop, start, or restart vCenter Server services.

• 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.

Additional Information