Errors 258 and 259
Hello all, We have a client who is getting sporatic -258 and -259 messages while trying to insert a record. A little background on the application; It is an OLTP environment that passes through financial transactions. It is a 9.21.UC3 with AIX5.1 environment. I understand that the errors have to do with cursors and the fact that it cannot be found. What I'm not sure is why this is happening. Our application declares and opens a cursor before every transaction (I know it is not necessary to declare the cursor every transaction, but I think that is another matter), and then closes it when it is done. I've been talking to Informix and they say it must be a flaw in our code (we use ESQL), but if it was a flaw I'm thinking that this would be occuring more often (it has only happened twice in the past two days). Also we have other client sites running the same code and this has never happened. Does anyone have any thoughts as to what could be happening? Thanks in advance Steve.
Steve Giles wrote: > Hello all, > > We have a client who is getting sporatic -258 and -259 messages while > trying to insert a record. > A little background on the application; It is an OLTP environment that > passes through financial transactions. It is a 9.21.UC3 with AIX5.1 > environment. > > I understand that the errors have to do with cursors and the fact that > it cannot be found. What I'm not sure is why this is happening. Our > application declares and opens a cursor before every transaction (I > know it is not necessary to declare the cursor every transaction, but > I think that is another matter), and then closes it when it is done. > I've been talking to Informix and they say it must be a flaw in our > code (we use ESQL), but if it was a flaw I'm thinking that this would > be occuring more often (it has only happened twice in the past two > days). Also we have other client sites running the same code and this > has never happened. > > Does anyone have any thoughts as to what could be happening? > > Thanks in advance > > Steve. Maybe the cursor is being autofreed ? -- rh
Richard Harnden <richard.harnden@lineone.net> wrote in message news:<40c706b3$0$6320$65c69314@mercury.nildram.net>... > Steve Giles wrote: > > > Hello all, > > .... > > > > > > Thanks in advance > > > > Steve. > > Maybe the cursor is being autofreed ? How can I determine that? I know there are no explicit free statements in the code. I've been examining some logs today and I can see the cursor being opened before the error, it's like the cursor just disappears.