Ignition 8.3 - Audit logs default column name changes

Ignition
,
1

Noticed issue upgrading 8.1 → 8.3.3.

We noticed an issue on our audit table column names being messed up. After further investigation it was noticed default Audit table column names changed from UPPERCASE to lowercase during migration.

8.1:

image
image1301×1230 41.3 KB

8.3:

image
image750×785 25.5 KB

Doesn't affect SQL queries directly. But Perspective tables using database bindings generate lowercase headers (instead of UPPERCASE) for column names. Case matters there.

image

Though to let people know if they encounter a similar issue.

Note: Only happens when audit database is regenerated and Ignition recreates the tables. Tested on 8.3.3.

2

Good work on the recon! For additional info, I believe some of this was outlined in the migration guide:

https://docs.inductiveautomation.com/docs/8.3/getting-started/installing-and-upgrading/ignition-8-upgrade-guide/81to83-upgrade-guide/#audit-profile-schemas

3

Good to know! Also good that they were re-cased to lower case to support databases like postgre so you don't have to use quotes everywhere when referencing fields