none
BizTalk, enlist a web service with database transaction through WS-AT RRS feed

  • Question

  • we expose a BizTalk web service, the web service then calls a database, sometimes the database took longer time, the data was changed though the web service time out, in this case, the caller thinks the call failed however the data is already changed. (e.g. the client account is already debited)

    How to achieve the end to end transaction in this scenario, would enabling the WS-AT transaction helps?


    https://ninithepug.wordpress.com/

    Thursday, February 4, 2016 8:32 PM

Answers

All replies

  • Hi,

    You need to change the connection timeout property in Orchestration as well as your Receive and send ports .

    Below are the steps :

    • Change WCF Connection timeout Property in Orchestration .
    SQL_Request(WCF.SendTimeout)= “00:10:00″;
    • Change execution time out property in web.config for the exposed service
    <configuration>
        <system.web>
             <httpRuntime executionTimeout=”00:05:00”>
        </system.web>
    </configuration>
    

    Refer MSDN link :

    https://msdn.microsoft.com/en-us/library/dd297484(BTS.10).aspx?tduid=(a00887b88dde1d5ca4036501c8d63e6c)(256380)(2459594)(TnL5HPStwNw-KYyy7r6E3hqITnz94bSizw)()

    • Set WCF SQL adapter  receiveTimeout to the maximum time 24.20:31:23.6470000.

    Thanks

    Abhishek


    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply

    Thursday, February 4, 2016 9:06 PM
  • Hi,

    Did you expose an orchestration or schema's as a web service? The service is hosted in IIS and enabled through the receive port/location. Here you can set the time-outs for the service (see screenshot below as an example).

    For configuration see the following MSDN article. It denpends a bit what binding you have chosen.

    Another post I would suggest is the following: BizTalk WCF Timeout Issue

    Kind Regards,

    Steef-Jan Wiggers (Microsoft Azure MVP)


    BizTalk

    Tuesday, February 16, 2016 1:39 PM
    Moderator