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 ha…

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)

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?

The .jar file I remember uploading was called ojdbc8.jar

[image] 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. [image] michael.black: The .jar file I remember uploading was called ojdbc8.jar Okay, that's something at least. We'll probably have to inves…

Alarm journal not displaying correct alarm information for label

Ignition

AIO August 10, 2023, 8:05pm 6

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.