Having a little trouble here. Hope one of you can help… I have a script that is 99% wonderful. Once a week it fails, and it fails in such a way that it doesn’t recover. The script times out, and presents a dialog that says it timed out, do I want to edit, or quit.
The step in question is accessing a database (Helix). It basically gets a number from a “Global” relation, which in Helix terms is a relation with 1 record, where one can store all sorts of parameters that you increment when you want to (and lots of other things). The story here is that its not pulling out 10K records, just one field value from 1 record.
I have a try and on error in there which should respond to any error that Helix might throw. However its not giving me an error its just timing out. I think what is happening is that the Helix Server is just busy and its not processing the request. This particular database wasn’t designed very well (not done by me) and it has the capability to get overwhelmed with the right series of events. I have a ‘with timeout’ statement in there, outside the try statement, but I don’t know how to manage things if it does timeout.
For example, try has an on error part that lets you do things when you get an error. Does timeout have a “on timeout” feature ? Is there a way to create one?
What do you folks do when you don’t get a response in a certain amount of time ?
TIA, Lenny