BIzTalk Server connection with SQL server Time out Issue

Hi All,

we are running data extract from SQL Server using Biz Talk. Sometime it is throwing the time. if we are rerunning after sometime  the extract running fine without any issues.  If we are running SQL Stored  Procedure  separatly, which is taking very less time.  Here i am not able to find why it is happening. I have increased   send/receive port timing also.

Please share your valuable suggestions.

Regards,

August 20th, 2015 1:33am

Hi ,

You can try  setting  WCF.SendTimeout in your message assignment shape .

SQL_Request(WCF.SendTimeout)= 00:10:00;

Also try running SQL Profiler to see what is happening on SQL box when BizTalk tries to commit the transaction .

 There are four timeout properties in the Biztalk WCF SQL adapter. You can set them to more than 50 secs but by default they are more than that. You can check http://msdn.microsoft.com/en-us/library/dd787981(v=BTS.10).aspx

Other links which you can refer :

http://social.msdn.microsoft.com/Forums/en-IE/biztalkr2adapters/thread/bfc2c635-de90-453b-b9ce-d2bd44548efd
http://social.msdn.microsoft.com/Forums/en-US/biztalkr2adapters/thread/68792a75-db56-481e-85a4-1a9b617ae14b

Thanks

Abhishek

Free Windows Admin Tool Kit Click here and download it now
August 20th, 2015 1:52am

Hi Thiru,

Can you let me know which type of adapter you are using? 

If you have checked the connection correctly, your server might be taking too much time to finish the command you are executing in backend. It can be either your server is taking more time than the timeout time or some problem ending your procedure. One more thing I can think is the database object might be locked by some other application and your instance and you got timeout while waiting for that to be released. 

Also please check the size/performance of your database and the current number of connections.

Please refer below links that will help to resolve your issue,

https://msdn.microsoft.com/en-us/library/dd787981.aspx?f=255&MSPPError=-2147217396

https://blog.tallan.com/2015/02/06/biztalk-wcf-timeout-issue/

http://blogs.msdn.com/b/psssql/archive/2013/10/22/sql-connection-pool-timeout-debugging.aspx

https://msdn.microsoft.com/en-us/library/aa560429.aspx?f=255&MSPPError=-2147217396

August 20th, 2015 4:16am

Hi ,

You can try  setting  WCF.SendTimeout in your message assignment shape .

SQL_Request(WCF.SendTimeout)= 00:10:00;

Also try running SQL Profiler to see what is happening on SQL box when BizTalk tries to commit the transaction .

 There are four timeout properties in the Biztalk WCF SQL adapter. You can set them to more than 50 secs but by default they are more than that. You can check http://msdn.microsoft.com/en-us/library/dd787981(v=BTS.10).aspx

Other links which you can refer :

http://social.msdn.microsoft.com/Forums/en-IE/biztalkr2adapters/thread/bfc2c635-de90-453b-b9ce-d2bd44548efd
http://social.msdn.microsoft.com/Forums/en-US/biztalkr2adapters/thread/68792a75-db56-481e-85a4-1a9b617ae14b

Thanks

Abhishek

Free Windows Admin Tool Kit Click here and download it now
August 20th, 2015 5:44am

Hi,

Can you please try setting Ambient Transaction to false means not using DTC for transactions?

Cheers

August 23rd, 2015 4:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics