After adding multiple datastores to a datastore cluster with Storage DRS enabled and set to "No Automation (Manual Mode)", it fails to generate recommendations.
After selecting "Run Storage DRS Now", the panel loads for 2 minutes and results in an empty panel with no recommendations.
This issue can occur when there are over 1,000 vm's registered in the storage cluster.
/var/log/vmware/vsphere-ui/logs/dataservice.log show similar timeout errors as below, note the storage cluster ID which will match ID from URL
YYYY-MM-DDThh:mm:ss:uuu [ERROR] nio-127.0.0.1-5090-exec-1390 70391450 116977 202073 RiseToViseResult [queryId: q-4433612:h5ui-getProperties:urn:vmomi:StoragePod:group-p12345:2e1c77f-g434-4119-b15f-3d5g22226c3c:1510553493] Returning partial results as one or more data providers responded with error. com.vmware.vise.data.query.internal.DataServiceException: The query execution timed out because of a back-end property provider 'Property provider com.vmware.vise.data.adapters.risetovise.RiseToVisePropertyProviderAdapter' which took more than 120 seconds.
vCenter 8.x
When SDRS is set to "No Automation (Manual Mode)" and multiple datastores are added to a datastore cluster which has a lot of vm's registered, the recommendations panel will time out generating the list of recommendations as there are so many vm's that need to be migrated.
Change Storage DRS automation to "Fully Automated" so the cluster can be balanced out automatically. In a large environment, this may take some time depending on how many new datastores have been added and how many vm's are registered in the cluster.
Once the migrations have been carried out, set Storage DRS automation back to "No Automation (Manual Mode)" and recommendations will be generated if any changes need to be made.