FIX: OLE DB Provider for DB2 parameters are not populated correctly in an SQL error message in a Host Integration Server 2010 environment

Article translations Article translations
Article ID: 2771299 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

In a Microsoft Host Integration Server 2010 environment, you try to provoke an SQL error message. When the error message includes more than one diagnostic value in the SQL Communication Area (SQLCA), the Microsoft OLE DB Provider for DB2 parameters are not populated correctly.

For example, when you try to provoke SQLCODE -803, the SQL error message may resemble the following:
AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE INDEX IN INDEX SPACE XPEI01?00001A6E04 CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X''

However, the SQL error message SQLCODE -803 should resemble the following:
AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX SPACE indexspace_name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X record_id

Resolution

Cumulative update information

The fix that resolves this issue is included in cumulative update package 6 for Host Integration Server 2010. 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:
2752426 Cumulative update package 6 for Host Integration Server 2010

Status

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

Properties

Article ID: 2771299 - Last Review: November 28, 2012 - Revision: 1.0
Applies to
  • Microsoft Host Integration Server 2010
Keywords: 
kbqfe kbfix kbexpertiseinter kbbug kbsurveynew KB2771299

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com