Procedure is not executing in WCF Custom Adapter RRS feed

  • Question

  • Hi,

    I have a stored Procedure that BizTalk is calling and retrieving data....sometimes that Procedure is not executing on given time interval. When i have set set useAmbientTransaction is false then procedure has executing in time interval but i am getting an error also in event viewer below 

    The timeout period elapsed prior to completion of the operation or the server is not responding. 

    Please let me know your suggestions.

    Thursday, June 27, 2019 6:03 AM

All replies

  • The issue is most likely on the SQL server side.   You will have to look at how long the stored procedure takes to execute, look the execution plan of the stored procedure and see if there are places where it is too slow, check for deadlocks and other issues.   
    Thursday, June 27, 2019 9:21 PM