We are running some custom procedures though the Web API. Some of them run for more than 30 seconds, so we are getting the following error:
"System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
We have increased all the timeouts settings we found in web.config and in t_defaults without success. Any ideas of what timeout could be the one triggering this error?
Thanks
I would run through your procedures piece by piece. You must have some weird join or some inefficient piece of code in there.