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'.
An update scripts fails during the upgrade process.
UIM 8.47 UMP 8.47This has been seen on other upgrade version as well.
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;