RE: Errors 258 and 259

-----Oorspronkelijk bericht----- Van: Steve Giles [mailto:fixer007@hotmail.com] Verzonden: maandag 14 juni 2004 13:59 Aan: informix-list@iiug.org Onderwerp: 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, Did you check this with a dbaccess form the prompt on your AIX ? Entering a simple command ? > 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. Yep a restart of your application will start new cursor's 1: New user do things diffenently bringing new bug to the surface 2: Maybe a other error condistion is nice catched by your appl. but not handled later on in the application where it expacts the cusros is still open. Good lucy /ARthur Things are getting mighty weird here... sending to informix-list