Re: Error -640: QPLAN sanity faiure (1503.0)

Jonathan Leffler (johnl@informix.com) wrote: : This is approximately the equivalent of "CAN'T HAPPEN". : It implies a fairly serious problem in the Engine, and says nothing about : the I4GL code. There is no problem in the program; there is a problem in : the Engine. A kind soul from the net mailed me a suggestion to run "update statistics". He mentioned that finderr said this, too. Well, neither my manual nor finderr said anything like this, but I checked with support and they came up with the same suggestion. Indeed, now the problem seems solved. I am quite puzzled by this, apparently the optimizer got way out of tune and crashed. I agree with Jonathan that this shouldn't happen, but there seems to be a problem which should definitely be fixed. Could this be associated with the "negative npused value" problem which was discussed in this group a while ago? I checked the systables table, everything seems to be fine. Thanks again to everybody who helped. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+