Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: raza990 on March 18, 2015, 11:32:54 AM

Title: Need Confirmation On Alarm Reaction
Post by: raza990 on March 18, 2015, 11:32:54 AM
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.
Title: Re: Need Confirmation On Alarm Reaction
Post by: Kubig on March 18, 2015, 11:55:22 AM
From your description, the configuration seems to be properly.
Title: Re: Need Confirmation On Alarm Reaction
Post by: Fra on March 18, 2015, 02:02:57 PM
[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?
Title: Re: Need Confirmation On Alarm Reaction
Post by: raza990 on March 18, 2015, 07:05:12 PM
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.
Title: Re: Need Confirmation On Alarm Reaction
Post by: cavagnaro on March 18, 2015, 08:09:48 PM
??? ??? ???
What am I missing? If problem is on DBServer <> DB where does IXN restart fixes the issue and even minimizes downtime?  :o
Title: Re: Need Confirmation On Alarm Reaction
Post by: Fra on March 19, 2015, 08:34:53 AM
[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.