"Cannot retrieve the data. View Director server event logs for further information."

"Cannot retrieve the data. View Director server event logs for further information." On Citrix Director.

Note: The solution to this issue has been implemented in XenDesktop 7.15 onwards. For older versions follow the instructions below. Back up data before making any changes and then follow these steps to check for zero values:

1. Using SQL Management Studio console connect to XenApp/Xendestop Monitor database hosted on SQL server.

2. Navigate to MonitorData.DesktopGroup

3. Right-click this file and then choose "Select Top 1000 rows"

4. When the query runs, check the Id field for any strings with '00000000-0000-0000-0000-000000000000' values.
   

If a record with id '00000000-0000-0000-0000-000000000000' exists, run the following command to delete it: declare @did uniqueidentifier set @did = '00000000-0000-0000-0000-000000000000' delete from MonitorData.Session where machineid in (Select Id from MonitorData.Machine where DesktopGroupID = @did) delete from MonitorData.ResourceUtilizationSummary where DesktopGroupId = @did delete from MonitorData.ResourceUtilization where DesktopGroupId = @did delete from MonitorData.ApplicationInstanceSummary where DesktopGroupId = @did delete from MonitorData.DesktopGroupApplications where DesktopGroupId = @did delete from MonitorData.SessionActivitySummary where DesktopGroupId = @did delete from MonitorData.FailureLogSummary where DesktopGroupId = @did delete from MonitorData.ServerOSDesktopSummary where DesktopGroupId = @did delete from MonitorData.DesktopOSDesktopSummary where DesktopGroupId = @did delete from MonitorData.Machine where DesktopGroupId = @did delete from MonitorData.DesktopGroup where id = @did