UMP dynamic groups not showing any devices after upgrading from 8.31 to 8.4; including Service Pack 1 and 2.

Document ID : KB000046545
Last Modified Date : 14/02/2018
Show Technical Document Details

 

Issue:

 

Dynamic groups are not being populated after upgrade to 8.4

 

Environment:  

 

Unified Infrastructure Manager 8.4

Database: Any supported SQL Server

 

Cause: 

 

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.

 

Resolution:

 

1) Run the following SQL

Part One:

declare @defname varchar(100),
  @cmd varchar(1000);

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 =
        object_id('dbo.CM_GROUP')
        and name = 'usm_visibile'
    )
)
set @cmd = 'alter table CM_GROUP drop constraint ' + @defname;
exec(@cmd);

alter table CM_GROUP drop column usm_visibile;

Part Two:

alter table CM_GROUP add usm_visible bit default 1;2) Restart the trellis probe - the issue should now be resolved.