Need Confirmation On Alarm Reaction

[raza990]

Hi,

I need to setup Alarm condition & Alarm reaction, if Ixn server lost the connectivity from database.

Last Month, Customer patched the MSSQL and then we experienced the issue twice times in 15 days that IXN Server lost connectivity with MSSQL and we were not aware of this for many hours until the issue report.

For this I need to create alarm condition & reaction by which IXN Server application will restart automatically.

When I see in logs, I found 2 events related to database and both events have alarm detect code in "interaction_server.lms".

23013|TRACE|msg_submit_failed_db|Database failure while processing request '%s' from client %d:%d, reference id: %d
23052|TRACE|msg_no_database_connection_available|No database connections available while processing request '%s' from client %d:%d, reference id: %d

So, I create an alarm condition in CME with on IXN Server application with detect code "23013" and "23052", and create alam reaction where I select "Restart an application who is generating the alarm".

So, Guys this solution will work ? I do not have testing environment and I test it in production environment that is the reason I am confirming you before present to the customer.

[Kubig]

From your description, the configuration seems to be properly.

[Fra]

[quote author=raza990 link=topic=8757.msg38904#msg38904 date=1426678374]
Hi,

I need to setup Alarm condition & Alarm reaction, if Ixn server lost the connectivity from database.

Last Month, Customer patched the MSSQL and then we experienced the issue twice times in 15 days that IXN Server lost connectivity with MSSQL and we were not aware of this for many hours until the issue report.

For this I need to create alarm condition & reaction by which IXN Server application will restart automatically.

When I see in logs, I found 2 events related to database and both events have alarm detect code in "interaction_server.lms".

23013|TRACE|msg_submit_failed_db|Database failure while processing request '%s' from client %d:%d, reference id: %d
23052|TRACE|msg_no_database_connection_available|No database connections available while processing request '%s' from client %d:%d, reference id: %d

So, I create an alarm condition in CME with on IXN Server application with detect code "23013" and "23052", and create alam reaction where I select "Restart an application who is generating the alarm".

So, Guys this solution will work ? I do not have testing environment and I test it in production environment that is the reason I am confirming you before present to the customer.

[/quote]

How would restarting IXN fix a DB connectivity issue?

[raza990]

It would not fix a DB connectivity issue, but for the time being we are setting up this solution so we wont have too much downtime again.

[cavagnaro]

What am I missing? If problem is on DBServer <> DB where does IXN restart fixes the issue and even minimizes downtime? 

[Fra]

[quote author=raza990 link=topic=8757.msg38913#msg38913 date=1426705512]
It would not fix a DB connectivity issue, but for the time being we are setting up this solution so we wont have too much downtime again.
[/quote]
It will potentially increase the downtime.