Re: Errors 258 and 259

fixer007@hotmail.com (Steve Giles) wrote in message news:<4170fcc.0406090342.4f8ff509@posting.google.com>... > 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. Just a followup, We had more problems over the weekend. As well as 258 and 259s, at one point the database just stopped, no errors or anything. The logical logs were NOT full. Are there any other reasons for this happening? A recycle of the application was all it took to reconnect. Things are getting mighty weird here...