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

book

Article ID: 6154

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

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'.

Cause

An update scripts fails during the upgrade process.

 

Environment

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

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;