Alarms tab in PME Web Applications stopped showing alarms

Issue
The 'Alarms' tab in PME Web Applications does not show any alarms whether they have been acknowledged or not. Prioritizing on alarm date or priority does not have any effect either.
All other components function as normal.

Product Line
Power Monitoring Expert 7.2
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024

Environment
Web Applications Alarms

Cause
Too many events are getting generated in the system. While the alarms tab may be able to display alarms for large number of events, at some point in time it may fail.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio and proficient in writing SQL statements. Databases should be backed up prior to performing this procedure.*

Trim the EventLog2 table in the ION_Data database to less than 50,000 records. It is recommended to delete the events prior to a specific date in batches, then test to see if it has fixed the problem. If not, change the date to a more recent date and remove more events. Repeat the process until the problem is fixed. Refer to the two example queries below, and change the '2000-01-01' part of the queries to a proper date to begin trimming.

1. This query returns the number of events prior to a specific date:
select count(*) from EventLog2 where TimestampUTC < '2000-01-01'

2. This query removes the events prior to a specific date:
delete from EventLog2 where TimestampUTC < '2000-01-01'

Released for: Schneider Electric Canada