Technical FAQs

Ask a Question

Alarms tab in PME Web stopped showing alarms

Issue
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)
This problem may not appear on most recent versions due to performance improvements as a result of changes for retrieving alarms.

Environment
PME Web

Cause
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.

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 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 ?