Browse FAQs

Alarms tab in PME Web stopped showing alarms

Published date: 10 May 2019

The 'Alarms' tab in PME web component 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 Data Center 7.2.2 (PMEDC 7.2.2)

note: While the problem was only seen on the above version, it could apply on the most recent versions as well.


Too many events 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.

*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 EventLog2 table (in ION_Data database) to less than 50,000 records.

Recommendation is 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 more recent and remove more events. Repeat the process until the problem is fixed.
Here is a couple queries to count and delete the events.

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

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

*Warning: The date in the above queries need to be adjusted.*

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.