hello i have a application(biztalk) that executes a stored procedure automaticaly from my sql server. From time to time i get this error Error Description: Microsoft.XLANGs.Core.XlangSoapException: AN_EXCEPTION_HAS_HAPPENED_Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
is there any way to catch this error of why this is happening, i checked sql server's log , i don't see any deadlocks, no jobs running at that time, no other heavy transactions either. When i execute this sp manually i see it only takes a few seconds to run, that's why i don't see what can the problem be.