Informix - Problem description
Problem IT12106 | Status: Closed |
WHEN AN ERROR OCCURS IN AN SPL WITH A SELECT, A -285 IS GENERATE D INTERNALLY BY THE SERVER WHICH WILL BLOCK ANY CURSORS FROM BEI | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A Java program prepares and calls an SPL repeatedly. An exception is raised in the SPL. As a result of this exception, a -285 is generated in the server attempting to close a cursor, which you could only detect if you trap for it (onmode -I 285) (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) check_traperror (oninit) sqerr (oninit) close_cursor (oninit) sq_close (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup Then if the application attempts to execute the prepared statement again, the application will get a -285 attempting to Open a Cursor C->S (92) Time: 2015-09-24 08:44:07.38726 SQ_ID 17 SQ_CURNAME "_ifxc000000000000f" [18] SQ_BIND # values: 5 0) Type.....: CHAR; NULLABLE Indicator: NOT NULL Precision: 0x0 Data.....: "BMMULTIMERY" [11] 1) Type.....: DATE; NULLABLE Indicator: NOT NULL Precision: 0x4 Data.....: 08/31/2015 2) Type.....: CHAR; NULLABLE Indicator: NOT NULL Precision: 0x0 Data.....: "A" [1] 3) Type.....: CHAR; NULLABLE Indicator: NOT NULL Precision: 0x0 Data.....: "K" [1] 4) Type.....: CHAR; NULLABLE Indicator: NOT NULL Precision: 0x0 Data.....: "" [0] SQ_OPEN SQ_EOT S->C (14) Time: 2015-09-24 08:44:07.38727 SQ_ERR SQL error..........: -285 ISAM/RSAM error....: 0 Offset in statement: 45 Error message......: "" [0] SQ_EOT | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Fetch on cursor returns error and during close of that * * cursor may return 285 error. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * **************************************************************** | |
Local Fix: | |
On the client side you could prepare the statement again as a workaround. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.11.2015 28.06.2016 28.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |