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

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.
Vlastnosti

ID článku: 2771299 - Poslední kontrola: 11/28/2012 23:07:00 - Revize: 1.0

Microsoft Host Integration Server 2010

  • kbqfe kbfix kbexpertiseinter kbbug kbsurveynew KB2771299
Váš názor