Dynamic groups are not being populated after upgrade to 8.4
Unified Infrastructure Manager 8.4
Database: Any supported SQL Server
The CM_GROUP table is not properly updated and the trellis probe is throwing exceptions in the log.
You can confirm by setting the following and restarting trellis.
loglevel = 5
format_sql = true
show_sql = true
Then search for any exceptions related to column
usm_visible not being found.
1) Run the following SQL
declare @defname varchar(100),
set @defname = (select name from sysobjects so
join sysconstraints sc
on so.id = sc.constid
where object_name(so.parent_obj) = 'CM_GROUP'
and so.xtype = 'D'
and sc.colid = (
select colid from syscolumns where id =
and name = 'usm_visibile'
set @cmd = 'alter table CM_GROUP drop constraint ' + @defname;
alter table CM_GROUP drop column usm_visibile;
alter table CM_GROUP add usm_visible bit default 1;2) Restart the trellis probe - the issue should now be resolved.