Hello,
Is there any Cassandra query that I can use to delete the alarm information with the particular root alarm ID via DevCenter?
The reason I asked was that I had deleted the RTE alarm using the SLNet Client test tool and the RTE alarm was not in the alarm console anymore.
However, when I checked the DMA failover configuration, I could still see that the RTE alarm is still there. (with RTE count 1).
Therefore, I would like to check if the RTE alarm is still in the database and would like to delete it from the DevCenter.
Thank you for the help.
It's obviously important to know what the root cause for this is, e.g. communication issues towards the DB or perhaps an issue in the Cube client. Once you know, you can use the following to remove the alarm from the DB.
Alarms can be found in 3 different tables, i.e. ActiveAlarms, Alarm and the Timetrace table. So when deleting, you should delete it from all these tables. This should work using the following procedure.
ActiveAlarms
SELECT di, ei, a FROM activealarms WHERE r='123/456789' ALLOW FILTERING;
Alarm
SELECT r, ai FROM alarm WHERE r='123_456789';
Timetrace
SELECT i, t, u from timetrace where ttr='123_456789' ALLOW FILTERING;
NOTE: in the above examples, I used 123 as DMA ID and 456789 as root alarm ID.
Once the above queries return the expected result(s), then you can easily change the query into a DELETE query using the received results
e.g. looking at the ActiveAlarms query:
SELECT di, ei, a FROM activealarms WHERE r='123/456789' ALLOW FILTERING;
Turns into the following delete query per result entry
DELETE FROM activealarms WHERE di = <result> AND ei = <result> AND a = '<result>' and r = '123/456789';