Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk Sql Server – Timeout › Re: Biztalk Sql Server – Timeout
December 22, 2006 at 10:24 AM
#17062
Are you getting an adapter timeout or a sql timeout error?
Note to boss. Retry warning as a sign of proper programming and retry engineering. The problem that I have seen is that the retry interval and number of cycles is set for the adapter and therefore when given a large load, it tends to cycle rather than spreading the work load.
Make sure you catch the final error after the number of retries and reinitiatize the sequence. Do that and do some optimization on the procedure if possible.