Error Threshold on Receive Locations
Posted by biztodo on November 29, 2007
When having multiple kinds of receive locations like file (over shares)/sql etc. It gets tough to monitor when the share servers or sql servers are rebooted. Biztalk keeps polling these shares or servers every x milliseconds. In some cases its configurable. For some adapters its not.
Here’s one scenario you want to avoid. The Sql servers were rebooted and since they didnt come back up within the default error threshold of 5 the receive location on the Biztalk receive was disabled. This led to a lot of messages getting accumulated. When having many third party systems and a tightly integrated system and fairly complex we were looking in all the wrong places for the missing messages. It took some time to find out that the sql receives were disabled. So it might be a good idea to set this threshold to zero. Since zero never happens the receive is never shut down in case of a communication failure. And you dont have to worry about disparate systems getting rebooted. After all what all can you account for?
Catch is this setting varies for different adapter.
For SQL its on the SQL Adapter
For File its right on the receive location configuration.
