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
The table umpAlamrAnnotations is missing or the varchar number on the columns is different what the UMP expected.
<Please see attached file for image>
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';