Alarm journal not displaying correct alarm information for label

[AIO]

Ran into the same issue, was able to resolve it following your advice. Seems like the alarm journal table creation isn't getting a VARCHAR, but a CLOB instead.

NCLOB in Alarm Journal - not in DB tables (Oracle)

Ran this series of commands to change it from CLOB to VARCHAR. Picked a length of 500 to leave room for longer descriptions (my longest was 293). --create new column alter table ALARM_EVENT_DATA add ("strvalue2" varchar2(500)); --copy clob to varchar update ALARM_EVENT_DATA set "strvalues" = dbms_lob.substr("strvalue",500,1); --rename clob, then rename new column alter table ALARM_EVENT_DATA rename column "strvalue" to "strvalueClob"; alter table ALARM_EVENT_DATA rename column "strvalue2" to "s…