Re: 113 error with 5.01
Jack, The -113 error is exactly what I was getting on 5.01.UD3. Informix says that it is a BUG (of all things!). They are sending me 5.02.UC6 to repair the problem (and introduce some new ones). Of course, the weird thing about my situation is that we had been running this version for about 10 months with no problems then all of the sudden we started getting the errors. Hope this saves you some effort. Christopher -------------------------------------------------------------------- Christopher Cale Internet: chrisc@spamis.jcdc.eta.gov Systems Administrator Metrica, Inc. Voice: 1-800-598-5008 205 6th St. San Marcos, Tx USA (This space reserved for a cute logo) 78666-9007 All opinions are from the voices in my head and nowhere else. -------------------------------------------------------------------- On Mon, 29 Aug 1994, Jack Parker wrote: > > Surprise! Our production Online engine was upgraded to 5.01 while my nose > was somewhere else. We are now experiencing a 113 error during sessions > which try to do more than one thing in a single session (i.e. for productive > users). The user in question ran one application and then tried to run > another. The second application errored with a 'Cannot create temp table' > - 'file is locked'. She had not tried to previously create the temp table > in question. She exited out and came back in and all was fine. > > A second datapoint: A script generates SQL and then runs it. The SQL > creates a temp table. This also gets the 113. > > Thoughts? This sounds very like the 'Need help with errors...' thread from > two weeks ago (also a 5.01 engine). > > j. > _____________________________________________________________________________ > Jack Parker | > Hewlett Packard, BSMC Boise, Idaho, USA| He who talks most, talks least. > jparker@hpbs3645.boi.hp.com | > _____________________________________________________________________________ > Any opinions expressed herein are my own and not those of my employers. > _____________________________________________________________________________ >