Typo in site database after upgrade to XenDesktop 7.11

There is a typo in the site database after you upgrade your environment to release 7.11 of XenDesktop. The issue is discussed on http://discussions.citrix.com/topic/381495-director-dashboard-doesent-update-after-installation-of-711/ and was initially identified by Sacha Thomet.

You can test if you have this issue by executing the Get-MonitorConfiguration commandlet. To fix the issue you have to run the following SQL update scripts against your site database:

if exists (select * from [Monitor].[Configuration] where Name = 'EnableMinLevelGranulairtyProcessUtilization')
begin
update [Monitor].[Configuration]
set Name = 'EnableMinLevelGranularityProcessUtilization', ModifiedDate = GETDATE() 
where Name = 'EnableMinLevelGranulairtyProcessUtilization'
end
go
if exists (select * from [Monitor].[Configuration] where Name = 'EnableHourLevelGranulairtyProcessUtilization')
begin
update [Monitor].[Configuration] 
set Name = 'EnableHourLevelGranularityProcessUtilization', ModifiedDate = GETDATE() 
where Name = 'EnableHourLevelGranulairtyProcessUtilization'
end
go
if exists (select * from [Monitor].[Configuration] where Name = 'EnableDayLevelGranulairtyProcessUtilization')
begin
update [Monitor].[Configuration] 
set Name = 'EnableDayLevelGranularityProcessUtilization', ModifiedDate = GETDATE() 
where Name = 'EnableDayLevelGranulairtyProcessUtilization'
end
go

After having corrected the typo the commandlet Get-MonitorConfiguration will execute again with no errors.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: