"back-end property provider" error while adding new datastore in vSphere Web Client

Products

• VMware vCenter Server

Issue/Introduction

This article provides steps to resolve the error back-end property provider when adding a datastore through the vSphere Web Client.

Symptoms:

• Adding a datastore using the vSphere Web Client fails with the error:
  
  The query execution timed out because of a back-end property provider 'com.vmware.vsphere.client.storage.impl.StoragePropertyProvider' which took more than 120 seconds.
   
• In the /var/log/vmware/vsphere-client/logs/vsphere_client_virgo.log file, you see entries similar to:
  
  [ERROR] data-service-pool-461 70000291 100004 200005 com.vmware.vise.data.query.impl.DataServiceImpl Error occurred while executing query:
  QuerySpec
  QueryName: urn:vmomi:HostSystem:host-975:c6e66619-2daa-43c3-8dcd-257bed54910c.properties
  ResourceSpec
  Constraint: ObjectIdentityConstraint
  TargetType: null
  Target: ManagedObjectReference: type = HostSystem, value = host-975, serverGuid =c6e66619-2daa-43c3-8dcd-257bed54910c
  PropertySpec[1]
  ProviderType: HostSystem
  Relationship: null
  Properties[1]
  PropertyName: storageSystem
  ResultSpec:
  Offset: null
  MaxResultCount: null
  OrderingCriteria
  OrderPropertySpec[1]
  ProviderType: Object
  Relationship: null
  SortType: ASCENDING
  OrderingProperties[1]
  PropertyName: id
  Facets: null
  Options: null
  com.vmware.vise.data.query.DataServiceException: The data service execution was interrupted

Environment

VMware vCenter Server 6.0.x
VMware vCenter Server Appliance 6.0.x

Cause

This issue occurs due to a query execution timeout on the Inventory Service Database to fetch Host-System properties taking more than 120 seconds.

Resolution

To resolve this issue, increase the timeout in the query-server-config.xml file to 90:
 

1. Connect to the vCenter Server Appliance with an SSH sessions and root credentials.
2. Navigate to /usr/lib/vmware-invsvc/lib/server/config/ with this command:
   
   cd /usr/lib/vmware-invsvc/lib/server/config/
    
3. Open the query-server-config.xml file with this command:
   
   vi query-server-config.xml
    
4. Search for <property name="xdbMemPercentage" value="XX" />.
    
5. Change the value to 90.
   
   For example:
   
   <property name="xdbMemPercentage" value="90" />
    
6. Restart Inventory service. For more information, see Stopping, starting, or restarting VMware vCenter Server Appliance 6.x services (2109887).
    

Note: For VMware vCenter Server 6.0.x, edit the query-server-config.xml file located at C:\Program Files\VMware\vCenter Server\invsvc\lib\server\config\ folder.

Additional Information

Stopping, starting, or restarting VMware vCenter Server Appliance 6.x services
vSphere Web Client で新しいデータストアを追加するときに「バックエンド プロパティ プロバイダ (back-end property provider)」エラーが発生する
在 vSphere Web Client 中添加新数据存储时发生“后端属性提供程序 (back-end property provider)”错误