Re: Biztalk Sql Server – Timeout

Home Page Forums BizTalk 2004 – BizTalk 2010 Biztalk Sql Server – Timeout Re: Biztalk Sql Server – Timeout

#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.