- This topic has 1 reply, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Hello All,
Thanks to 'BizTalk Receipes' Book and Steven Thomas samples, I'm able to extract my message from a batch using envelopes.
Simply, for each message I use content based routing and map to call a stored procedures.
everyting is fine, but my stored procedures takes time to be executed, so I receive timeout (note, I don't have an orchestration)
secondly, I got some errors becuase sql server is not able to process all that large number of requests.
I tried to use BizTalk 2006 throttling, but I couldn't configure it (lake of knowledge actually).
Is theres is solution for the timeouts (I tried to increate the time out in the adaptor configuration, but it doesn't save my new value)
I got alot of warning (it is embrassing me, my boss sees them)….
Any helpl is appericated
-
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.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.