After upgrade the UMP from 8.2 to 8.47 I got an error message on the USM page

Document ID : KB000006354
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After an upgrade at UMP from version 8.2 to version, 8.47 or 8.50 or 8.51 and you get this type message:

umpAlarmAnnotations.bmp

The above print it is for a Portuguese language but below are the English message:

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

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

SELECT DISTINCT aa.nimid, aa.alarmSource FROM umpAlarmAnnotations aa

Environment:
From UMP version 8.2 to any version above 8.4 sp2 at Microsoft SQL or Oracle database.
Cause:

The table umpAlamrAnnotations is missing or the varchar number on the columns is different what the UMP expected.

 

columns size.jpg

Resolution:

Execute the query:

Select * from umpAlarmAnnotations

make sure you have all this 5 columns as below:

select alarmannotations.jpg

Don't matter if all the fields are null.

If you don't have this table you must create the table with this command:

This command is for Oracle DB

CREATE TABLE umpAlarmAnnotations (
nimid VARCHAR2(50) DEFAULT NULL,
created date DEFAULT NULL,
username VARCHAR2(64) DEFAULT NULL,
annotation VARCHAR2(1024) DEFAULT NULL,
alarmSource VARCHAR2(50) DEFAULT NULL) 

For the Microsoft SQL

CREATE TABLE umpAlarmAnnotations (
nimid VARCHAR(50) DEFAULT NULL,
created date DEFAULT NULL,
username VARCHAR(64) DEFAULT NULL,
annotation VARCHAR(1024) DEFAULT NULL,
alarmSource VARCHAR(50) DEFAULT NULL) 

 

If you have the table please just execute this command to adjust the columns size:

For Oracle DB:

ALTER TABLE umpAlarmAnnotations MODIFY nimid VARCHAR2(50);

ALTER TABLE umpAlarmAnnotations ADD alarmSource VARCHAR2(50);

UPDATE umpAlarmAnnotations SET alarmSource = 'NAS';

For Microsoft DB:

ALTER TABLE umpAlarmAnnotations alter column nimid VARCHAR(50);

ALTER TABLE umpAlarmAnnotations ADD alarmSource VARCHAR(50);

UPDATE umpAlarmAnnotations SET alarmSource = 'NAS';