Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: SQL connection leak when you use WCF-based SQL Adapter one-way send port to return a result set from a database in BizTalk Server 2010 or in BizTalk Server 2013

FIX: SQL connection leak when you use WCF-based SQL Adapter one-way send port to return a result set from a database in BizTalk Server 2010 or in BizTalk Server 2013

View products that this article applies to.

Symptoms

Assume that you use a one-way send port that uses the Microsoft Windows Communication Foundation (WCF)-based SQL Adapter in Microsoft BizTalk Server 2010 or in Microsoft BizTalk Server 2013 to process messages. After some time, you receive the following error message:
The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

↑ Back to the top

Cause

This issue occurs because the related SQL connection in the SQL adapter is not released when the message processing generates the results.

Notes:
  • Connections are only released back into the connection pool when the BizTalk host instance is recycled. When the connection buildup exceeds the specified MaxConnectionPoolSize value of the connection pool, you will receive the above error message.
  • This issue occurs when you use one-way send ports.

↑ Back to the top

Resolution

Cumulative update package information

For BizTalk Server 2013

The hotfix that resolves this issue is included in cumulative update package 2 for BizTalk Server 2013.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2892599 Cumulative update package 2 for BizTalk Server 2013

For BizTalk Server 2010

The hotfix that resolves this issue is included in cumulative update package 6 for BizTalk 2010.

For more information about how to obtain this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2855367 Cumulative update package 6 for BizTalk Server 2010


↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More Information

For more information about the MaxConnectionPoolSize binding property, go to the following MSDN website:

Working with BizTalk Adapter for SQL Server Binding Properties

For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:

2003907 Information about BizTalk Server hotfixes

↑ Back to the top

Keywords: kb, kbqfe, kbfix, kbsurveynew, kbexpertiseadvanced

↑ Back to the top

Article Info
Article ID : 2855762
Revision : 1
Created on : 1/7/2017
Published on : 10/31/2013
Exists online : False
Views : 463