After upgrading the ump we can log into UMP but USM does not come up we get an error.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After upgrading to a new version of UMP, USM will not load and you get an pop up error with the following message:

An unknown error has occurred.
Refreshing your browser may resolve the issue.

Details:
com.firehunter.ump.exceptions.DataFactoryException : null
Info:

select g.grp_id, g.grp_type, g.pgrp_id, g.name, g.description, g.priority, g.is_unified,        g.name_token, g.description_token, r.path as more_report, 1 active  from CM_GROUP g    left join umpGroupMoreReport r on g.grp_id = r.grp_id  where g.pgrp_id IS NOT NULL


Stack Trace:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'is_unified'.

Environment

UIM 8.47 UMP 8.47This has been seen on other upgrade version as well.

Cause

An update scripts fails during the upgrade process.

 

Resolution

You will need to run the below query from either the SLM SQL query window or from SQL studio on the database server on the UIM database.

Alter table CM_GROUP Add IS_UNIFIED INT default '0' not null;