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

Document ID : KB000006154
Last Modified Date : 12/09/2018
Show Technical Document Details
Issue:

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;