In Ignition version 8.1.20, two alarms associated with a single tag went active and were then acknowledged. However, the event of these alarms transitioning to the active state and being acknowledged is not appearing in the alarm journal. The alarms have not been cleared, only acknowledged. It's been about two hours and still nothing in the alarm journal. what could be the reason? note: this has not happened before and alarm journal has lots of events in it.
The alarm journal relies on the SQL table alarm_events and alarm_event_data. Perhaps something happened to the connection where it is no longer saving data there. The alarm status pulls from Ignition's internal alarm state.
The SQL table does not display the alarm event. Although the alarm journal shows events before and after, it skipped the two alarm events, which are still active but not indicated as active or acknowledged
Can you double check if you have any Data Filters applied that prevented that tag from being recorded. I can see the last time an event for that specific tag was back on the 23rd. The eventflags is 0 which indicates it is the entry for when it became Active.
Also, another possibility is that the gateway has recently restarted and the "Active Time" column will show the time of the gateway System Startup (or a few minutes after). This may be the reason why the 29 Feb 2024 10:07:57 is not found and will not match the eventtime of 2024-02-23 14:29:47. Try removing the "WHERE" clause in your query and see if you have any System Startup events. However, this doesn't explain the lack of Acknowledged event...so I would still look at the health of the database connection.
What is the priority of the alarm? Perhaps the priority is lower than the min setting in the alarm journal setting in the gateway webpage. I think by default, diagnostic alarms will not be stored.