Browse FAQs

Alarms tab in PME Web stopped showing alarms

Published date: 10 June 2020

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.2 Data Center Edition (PMEDC 7.2.2)

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'

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.