Unable to clear Active Alarms in PME Web Applications

Issue
When viewing the Alarms tab within the PME Web Applications, a user may see active alarms that are no longer active.



The Management Console Deactivate Alarms tool does not display the alarms in question.



Product Line
Power Monitoring Expert 7.2.x Base/Healthcare/Data Center

Power Monitoring Expert 8.x   Base/Healthcare/Buildings/Data Center

Power Monitoring Expert 9.0

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment
Web Applications "Alarms"

Cause
The Alarm is still showing as active because the dropout condition for the alarm was never logged.

Resolution

*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. The Web Applications "Alarms" page pulls data from the vAlarmLogview in the ION_Data database
2. Query, the vAlarmLog view in the ION_Data database to determine the ID of the alarm that needs to be removed

Be sure to backup the ION_DATA database before running any SQL queries

Example:

Use ION_Data
Select * from vAlarmLog
where SourceID = 7
order by TimestampUTC desc

3. Once you have determined the ID of the alarm that needs to be removed run the following query in SQL against the ION_Data database

For Power Monitoring Expert 7.2.x:

DELETE FROM EventAcknowledgement where EventLogID IN (1414)
DELETE FROM EventLog2  where ID IN(1414)

DELETE FROM AlarmLog  where ID IN(1414)
DELETE FROM EventAcknowledgement where EventLogID IN (1414)
DELETE FROM EventLog2  where ID IN(1414)

DELETE FROM AlarmEvent  where EventID IN(1414)
DELETE FROM EventAcknowledgement where EventLogID IN (1414)
DELETE FROM EventLog2  where ID IN(1414)

Publicado para: Schneider Electric España