Agree with Joe, however I'd add that this behaviour (I'm from the UK ;)) must be frustrating for the end user. I'd suggest creating some kind of staging form which runs the functionality server side, the user can then refresh and check it has completed correctly.
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: 22 September 2008 16:48 To: arslist@ARSLIST.ORG Subject: Re: Timeout Error ** It depends on what operation the user is attempting.. Such errors are usually indicative of the fact that the database couldn't process the the call in time, the AR System waits for the database to respond for a while, and having got no response, stops waiting for it to respond and hence the message.. These errors are generally due to a table scan that is occuring during the operation. There has been a search that used a bad query against a large table, resulting in a table scan. I would be looking in that direction, and narrow down on the various searches that occur when the user performs the operation that times him/her out.. Since you say its a home grown system it is very likey that your developers who have developed the system have not created the necessary indexes to help with the searches that occur during the execution of the workflow that they have designed during that operation. Hope this helps.. Joe ----- Original Message ---- From: Viji.PK <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, September 22, 2008 6:57:42 AM Subject: Timeout Error Hi All, There is one user action in our home grown remedy system, such it executes for 3 to 3.5 minutes. The operation is successfully completed by the database, but user gets an Time out Error message (ARERR 92), before even he realises the succesfull completion. Is there any setting on the Server configuration to increase this interval? Please pass your thoughts, Thanks, Viji __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
