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

Products

• DX Infrastructure Management
• NIMSOFT PROBES

Issue/Introduction

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:

<Please see attached file for image>

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

Cause

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

 

<Please see attached file for image>

Environment

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

Resolution

Execute the query:

Select * from umpAlarmAnnotations

make sure you have all this 5 columns as below:

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AK1lAAG" alt="select alarmannotations.jpg" width="373" height="87">

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