ā12-01-2011 06:00 AM - edited ā03-14-2019 08:58 AM
Hi Experts!
We are testing a number of "exceptions" with our 2 x UCCX servers HA" and now we will start using DB Read, GET and Write in our UCCX scripts. To be sure that the script will continue work if you loose your Backend office SQL servers is there anything that you need to consider like "On exception" goto in the script.?
Questions summary:
1. Will the SQL enabled script continue to work if you loose Backend office SQL?
2. IF the UCCX failover (HA setup) will the DSN connection from UCCX to SQL continue to work in the new elected UCCX Master?
SQL=2008
UCCX = 8.02SU3
rgds, Ronnie
ā12-01-2011 07:40 PM
1. Will the SQL enabled script continue to work if you loose Backend office SQL?
That depends on you. The Read step has a Timeout branch and the Write step has a Connection Not Available. You would need to account for these conditions in your script. There are a few exceptions related to the database but I have not seen these set often:
2. IF the UCCX failover (HA setup) will the DSN connection from UCCX to SQL continue to work in the new elected UCCX Master?
Sure if the other UCCX engine can access the DSN. Each engine would attempt its own ODBC connection.
ā12-02-2011 07:34 AM
Hi Jon!
Thank you for answer!
So you now that it works in real life!? I actually tested to change the IP address on the DSN connection to a "not working" IP address and tried to call into my script and then saw (in a debug) that it was just sitting there on the DB read without continue!
Thx, Mikael
ā12-02-2011 10:55 AM
Hi
Yes, it should fail to the timeout branch. Give it plenty of time, it might be just waiting longer than you think to timeout. I've not had the privilege of doing a DB integration on an 8.x system yet, but since most other things are bug riddled in these versions a default java-style 30 second timeout wouldn't be a surprise :-)
Aaron
ā12-07-2011 12:13 AM
Hi there!
I tried the Timeout which seemed to default to about 7 seconds!
I cut the connnection to the SQL DB, stopped the SQL server .etc. and it branched to the "connection not available"
most of the times.
Thx, it worked and now i sleep better!
Rgds, Mikael & Ronnie
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide