Data service times out with error: "com.vmware.vise.vim.security.impl.AuthorizationServiceImpl"

Products

• VMware vCenter Server

Issue/Introduction

• Data Service Timeout

"The query execution timed out because of a back-end property provider 'com.vmware.vise.vim.security.impl.AuthorizationServiceImpl' which took more than 120 seconds"

• In the Web client logs, you see a message similar to:

[YYYY-MM-DDTHH:MM:SS.XXXZ] [WARN ] http-bio-9090-exec-9         70000168 100004 200002 ProfilingUtil [viseBatch: 60] [viseQuery: ] The Data Service detected slow execution:
The query batch execution took too long: 120015 milliseconds.

The queries in the batch sent to the Data Service are:
Query[0]:

[YYYY-MM-DDTHH:MM:SS.XXXZ] [ERROR] http-bio-9090-exec-9         70000168 100004 200002 DataServiceImpl [viseBatch: 60] [viseQuery: ] Error occurred while executing query:
 com.vmware.vise.data.query.DataServiceException: The query execution timed out because of a back-end property provider 'com.vmware.vsphere.client.sso.admin.impl.SsoUserDirectoryPropertyProvider' which took more than 120 seconds.

Environment

• VMware vCenter server 7.x
• VMware vCenter server 8.x
• VMware vCenter Server Appliance 6.5.x
• VMware vCenter Server 6.5.x

Cause

The VCSA uses SSO with an AD. The AD respond very slow.

Resolution

This behavior is not a VCSA issue. Currently, there is no resolution:

Workaround:

Increase the timeout value from 120 to 300 in webclient.properties file.

 

In VCSA 7.x and 8.x, webclient.properties file located under /etc/vmware/vsphere-ui/

The file path in VCSA 6.x:  /etc/vmware/vsphere-client/

• Take SSH to vCenter server and enter into shell. 
  
  
• Check the webclient.properties file navigate through  /etc/vmware/vsphere-ui/


• Take a copy of the file by running the command:
  cp webclient.properties webclient.properties.bak
  
  
• Edit the webclient.properties file using vi
  vi /etc/vmware/vsphere-ui/webclient.properties
  
  
• Locate the entry dataservice.timeoutSeconds and change the timeout value from 120 to 300 :
  dataservice.timeoutSeconds = 120 to dataservice.timeoutSeconds = 300
  
  
• Restart the vCenter services for the change to take effect:
  service-control --stop --all && service-control --start --all