FIX: Applications that use the OLE DB Provider for AS/400 and VSAM or the Biztalk Adapter for Host Files may crash when the APPC parallel session limit is reached

Applications that use the OLE DB Provider for AS/400 and VSAM or the Biztalk Adapter for Host Files may crash when the parallel session limit that is configured in the APPC mode definition is reached.

When you use the Biztalk Adapter for Host Files, the following errors may be logged in the application event log.

Error 1

Event ID: 5804
Event Source: Biztalk Server 2006
Description: A response message sent to adapter "HostFiles" on Receive Location: "Receive Location Name" with URI:"URI" is suspended.
Error details: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure. MessageId: GUID InstanceID: GUID

Error 2

Event ID: 5778
Event Source: Biztalk Server 2006
Description: The Messaging engine failed to process a message submitted by adapter:HostFiles Source URL:HostFiles:URL.
Details:The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

Error 3

Event ID: 5743
Event Source: Biztalk Server 2006
Description: The adapter failed to transmit message going to send port "Send Port Name" with URL "HostFiles:URL". It will be retransmitted after the retry interval specified for this Send Port.
Details: An error occurred while opening the cursor. Internal message: Invalid connection ID. This could either occur if the statement being executed is not valid or if the Metadata data assembly is not loaded. If the statement is correct, ensure that the Metadata assembly can be loaded either as a local or globally available assembly, and ensure the assembly has been registered in its current location using Regasm.exe.

When this problem occurs, the application cannot start any new connections to the IBM host mainframe or iSeries (AS/400) system by using the OLE DB Provider for AS/00 and VSAM. In addition, the application cannot close any of the existing connections that were successful before the APPC parallel session limit being reached.

Microsoft Host Integration Server 2004 Service Pack 1 (SP1)

Hotfix Information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

To apply this hotfix, you must have Host Integration Server 2004 Service Pack 1 (SP1) installed.

Restart Requirement

You do not have to restart the computer after you apply this hotfix.

Hotfix Replacement Information

This hotfix does not replace any other hotfixes.

File Information

The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Note Because of file dependencies, the most recent hotfix that contains these files may also contain additional files.

Microsoft Host Integration Server 2006 and Microsoft Biztalk Adapters for Host Systems

Service pack information

To resolve this problem, obtain the latest service pack for Host Integration Server 2006. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

Hotfix Information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

No prerequisites are required.

Restart Requirement

You do not have to restart the computer after you apply this hotfix.

Hotfix Replacement Information

This hotfix does not replace any other hotfixes.

File Information

The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
32-bit (x86) version
64-bit (x64) version
Note Because of file dependencies, the most recent hotfix that contains these files may also contain additional files.

To work around this problem, increase the parallel session limit in the APPC mode definition to a value larger than the maximum number of concurrent session requests that are expected in the environment.

Note You must change the APPC mode definitions in both the Host Integration Server configuration and on the IBM host system to change the parallel session limit.

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

When the Biztalk Adapter for Host Files allocates APPC (LU 6.2) sessions, it establishes one APPC session for each message batch. The number of APPC sessions allocated at a time is equal to the number of concurrent batches being processed by the adapter. Consider this allocation process when you determine the optimal APPC parallel session limit.

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base: