DB2 - Problem description
Problem IC65882 | Status: Closed |
EXCEPTION WHEN NOT RETRIEVING A BYTE FIELD WHICH IS IN THE PROJECTION LIST | |
product: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problem description: | |
When connecting to IDS the following exception occurs when BYTE field is in the projection list of the SELECT but is not retrieved by DataReader ERROR [58005] [IBM][Ifx.NET] SQL0902 An unexpected exception has occurred in Process: 776 Thread 1 AppDomain: Name:PMR_69844.exe There are no context policies. Function: IfxDataReader.Read() | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Windows .NET * **************************************************************** * PROBLEM DESCRIPTION: * * When connecting to IDS the following exception occurs when * * aBYTE field is in the projection list of the SELECT but * * isnot retrieved by DataReaderERROR [58005] [IBM][Ifx.NET] * * SQL0902 An unexpected exceptionhasoccurred in Process: 776 * * Thread 1AppDomain: Name:PMR_69844.exeThere are no context * * policies.Function: IfxDataReader.Read() * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Data Server Provider for .Net 9.7 Fix Pack 2. * **************************************************************** | |
Local Fix: | |
Remove the unused BYTE column from the projection list. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in Version 9.7 Fix Pack 2. This fix should be applied on the client. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.01.2010 31.05.2010 31.05.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |