cancel
Showing results for 
Search instead for 
Did you mean: 

HANA alert closure

Former Member
0 Kudos

Hi Folks,

I have a doubt, we are frequently getting alerts saying that "1 alerts occurred".

We are already aware of the issue and its being worked, can this alert be closed. Since we are getting too many emails for the HANA alerts.

Is there a way to close the alert in HANA.

Message was edited by: Tom Flanagan

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


As you might have already noticed all EVENTS are generated with HOST, PORT and ID of the alert

For example an alert for Replication parameter mismatch looks like the following:

ReplicationError with state INFO with event id 1234 occurred at 2015-MM-DD MM:SS on

<HOSTNAME>:30201(Port number) Additional info: parameter mismatch

Such an event could then be marked as resolved by executing the below SQL statement

ALTER SYSTEM SET EVENT HANDLED '<HOSTNAME>:<PORT>'<ID>

You can find such a hint to resolve the EVENTS along with the email that sends the alert message

Former Member
0 Kudos

Sunil,

Great point have you tried this option?

Former Member
0 Kudos

Will it not affect the future alerts?

Former Member
0 Kudos

as you are required to specify the event ID in the statement. Hence, it will not effect the other alerts