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: Microsoft BizTalk Adapter for DB2 fails to call a stored procedure containing more than 84 parameters returning SQLCODE -290

FIX: Microsoft BizTalk Adapter for DB2 fails to call a stored procedure containing more than 84 parameters returning SQLCODE -290

View products that this article applies to.

Symptoms

Assume that you run the Microsoft BizTalk Adapter for DB2 and call a stored procedure with parameters. When the parameter list exceeds 84 parameters, then you may receive the following error message:

The request for the host resource failed. SQLSTATE=HY000 SQLCODE=-290


↑ 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

Resolution

This issue is fixed in the following cumulative update for Host Integration Server:

Note The Microsoft BizTalk Adapter has been modified to allow more than 84 parameters to be passed.

↑ Back to the top

References

Learn about the terminology that Microsoft uses to describe software updates.

↑ Back to the top

Keywords: Host Integration Server 2016, kbContentAuto, kbSupportTopic, kb, kbfix, kbqfe, kbHotfixAuto, CI100495, SQLCODE= -290

↑ Back to the top

Article Info
Article ID : 4328281
Revision : 9
Created on : 4/12/2019
Published on : 4/12/2019
Exists online : False
Views : 240