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

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.

com.firehunter.ump.exceptions.DataFactoryException : null

select g.grp_id, g.grp_type, g.pgrp_id,, 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: Invalid column name 'is_unified'.
UIM 8.47 UMP 8.47This has been seen on other upgrade version as well.

An update scripts fails during the upgrade process.



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;