# 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:** 6\ **Page:** 1
**Author:** ![michael.black](https://avatars.discourse-cdn.com/v4/letter/m/ee7513/32.png) [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Post date:** [September 29, 2021, 7:40pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-displaying-correct-alarm-information-for-label/51464/1 "2021-09-29T19:40:50Z")
I have an alarm journal that worked perfect when I had one gateway and one connection to a local mariadb database. Now I have broken up the front and backend gateways so the backend has the connection to the plc and also has the tag historian module. The frontend has perspective, reporting, and has a DB connection. The DB is now Oracle. My alarm journal worked perfect before and I haven’t changed anything except for using the Oracle DB instead of the MariaDB connection. My current alarms are showing up fine, but my alarm journal is not displaying the label correctly anymore. I see the alarms but the label is not showing up correctly. This is what I see… ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/b/8b33589061674e0aa06db73391427bb47f1327cd.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 29, 2021, 7:56pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-displaying-correct-alarm-information-for-label/51464/2 "2021-09-29T19:56:22Z")
Oof, interesting. What’s the Oracle DB version, and what’s the version of the JDBC driver .jar file? (on disk, don’t trust the gateway web page) ---
**Author:** ![michael.black](https://avatars.discourse-cdn.com/v4/letter/m/ee7513/32.png) [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Post date:** [September 29, 2021, 8:08pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-displaying-correct-alarm-information-for-label/51464/3 "2021-09-29T20:08:31Z")
The database itself is located remotely so not sure which version it is. I am accessing the oracle DB using Oracle sql developer version 21.2.1.204. Not sure if there is a way to get the oracle DB version from the developer or not. Quick way to see the version of the JDBC driver .jar file? ---
**Author:** ![michael.black](https://avatars.discourse-cdn.com/v4/letter/m/ee7513/32.png) [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Post date:** [September 29, 2021, 8:12pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-displaying-correct-alarm-information-for-label/51464/4 "2021-09-29T20:12:54Z")
The .jar file I remember uploading was called ojdbc8.jar ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 29, 2021, 9:07pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-not-displaying-correct-alarm-information-for-label/51464/5 "2021-09-29T21:07:13Z")
> [@michael.black](#): > > Not sure if there is a way to get the oracle DB version from the developer or not. `SELECT * FROM v$version;`, apparently. > [@michael.black](#): > > The .jar file I remember uploading was called ojdbc8.jar Okay, that's something at least. We'll probably have to investigate 'in-house'. Is the `strvalue` column of the `alarm_event_data` [table](https://docs.inductiveautomation.com/display/DOC81/Alarm+Journal#AlarmJournal-TableDefinitions) actually an `NCLOB` type? That's probably wrong; you might be able to change the column definition to a more 'plain' type (VARCHAR, etc) and get the right results in your journal table. ---
**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…