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

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

book

Article ID: 320224

calendar_today

Updated On:

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 Appliance 6.5.x
  • VMware vCenter Server 6.5.x

Cause

The vCSA uses SSO with an AD. The AD respond very slow.
This behavior is not a vCSA issue.

Resolution

Currently, there is no resolution:

Workaround:

Increase the timeout value from 120 to 300 in webclient.properties file.
  1. Check the the webclient.properties file
 /etc/vmware/vsphere-client/
  1. Take a copy of the file by running the command:
 cp webclient.properties webclient.properties.bak
  1.  Edit the webclient.properties file
/etc/vmware/vsphere-client/
  1. Change the line:
dataservice.timeoutSeconds = 120 to dataservice.timeoutSeconds = 300
  1.  Restart the vCenter server for the change to take effect.