Browse FAQs

Power Monitoring Expert Active Alarm count shows 0

Published date: 25 September 2019

Issue
Alarm count on the web application page does not update even when a known alarm has been generated

Product
Power Monitoring Expert (PME) 7.2.x, 8.x

Environment
Web Application

Resolution

Log into SQL Server Management Studio and run the attached SQL script (AlarmLogQry.sql).
If running this query  longer than 30 Seconds, reduce the number of events in the Eventlog2 table.
This can be done with an archive and trim of the Events.

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* 
  1. Open the database Manager in Management Console
  2. Login with a supervisor level user in PME
  3. Under databases, right click ION_data and select either trim or Archive. If using Archive make sure that "Remove archived data from live database" is checked
  4. Under data types, make sure only Events are selected
  5. Run the archive or trim to remove data from the EventLog2 table
Note: In later versions of PME, the Active Alarm count is based on a different table in ION_Data called Alarm log

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.