All geek questions in one place

SQL Receive Location shuts down after n-attempts

We have one place to receive SQL in our BizTalk 2010 application. It is indicated on the server hosting SQL Server and runs every day without a glitch.

Today, SQL Server was disconnected for some reason, and after 5 attempts, SQL Receive Location became disconnected.

I am looking for a way to avoid this automatic shutdown by allowing more attempts, or by disabling this feature, if possible. Does anyone have any suggestions on how I can overcome this?

+4
source share
1 answer

It is not possible to disable this AFAIK function, so your options are:

  • If you use the WCF-SQL Adapter to query SQL, in the "Adapter Binding Tab" section, set the "Close", "Open", and "Receive Timeout" values ​​that are convenient for you and those that provide enough time for BizTalk " kick out "failure. On the "Messages" tab in the "Error Handling" section, there is also the option "Disable location on failure" - disable this option.

  • If you are using the "old" SQL adapter (that is, not WCF), you just need to live with the fact that the receive location will be disconnected if it cannot connect to SQL Server.

However, it would be useful to introduce a strategy to handle these types of failures. When the receiving location is turned off, an error message is written to the application event log, some fairly simple software can check for certain errors in the event log and send alerts by e-mail. Alternatively, you can also use specialized Ops management software (SCOM / BizTalk360, etc.) to monitor the BizTalk environment and notify when a service failure has occurred.

+7
source

Source: https://habr.com/ru/post/1488247/

More articles:


All Articles