|
Problem IC63767
|
Status: Closed |
INADEQUATE ERROR MESSAGE WHEN TRANSACTIONTIMEOUT IS REACHED WHILE READING ROWS VIA IFXDATAREADER |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Error when TransactionTimeout is reached while reading rows via
IfxDataReader
-99999 ERROR [24000] [IBM] CLI0115E Invalid cursor state.
SQLSTATE=24000
The error message is misleading and hard to catch because it
does not point to the problem.
Customer expects an error message which is related to the cause
of the problem.
After catching an error the application has to take the
appropriate action.
This is not possible when the error message does not point to
the problem. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* INADEQUATE ERROR MESSAGE WHEN TRANSACTIONTIMEOUT IS *
* REACHEDWHILE READING ROWS VIA IFXDATAREADERError when *
* TransactionTimeout is reached while reading *
* rowsviaIfxDataReader-99999 ERROR [24000] [IBM] CLI0115E *
* Invalid cursor state.SQLSTATE=24000The error message is *
* misleading and hard to catch because itdoes not point to the *
* problem.Customer expects an error message which is related *
* to thecauseof the problem.After catching an error the *
* application has to take theappropriate action.This is not *
* possible when the error message does not pointtothe problem. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to IBM Data Server Provider for .Net 9.7 Fix Pack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 3 This fix
should be applied on the client. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69931
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.10.2009
11.11.2010
11.11.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
