# Alarm journal not displaying correct alarm information for label **URL:** \ **Category:** Ignition\ **Created:** [September 29, 2021, 7:40pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-displaying-correct-alarm-information-for-label/51464 "2021-09-29T19:40:50Z")\ **Posts on this page:** 1\ **Showing post:** 6
**Author:** ![AIO](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aio/32/87549_2.png) [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Post date:** [August 10, 2023, 8:05pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-displaying-correct-alarm-information-for-label/51464/6 "2023-08-10T20:05:23Z")
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)](https://forum.inductiveautomation.com/t/nclob-in-alarm-journal-not-in-db-tables-oracle/77711/2): > > 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… --- _[View the full topic](https://forum.inductiveautomation.com/t/alarm-journal-not-displaying-correct-alarm-information-for-label/51464)._