Re: Error code -346 ?

} } An Informix SE kernel release 5 is installed on a SCO pentium 90 MHz. } When we send an update command to one of the table of the database (20 } columns and a maximum of 200 rows). We get back the following error code : } -346 Could not update a row in the table. I have encountered similar problems with Release 5 running on AT&T 386 with Univel Unixware 4.2 (1.1.2). The error number was the same. However, the real problem was that we ran out of locks. For each row you update Informix allocates a lock. For some reason, Informix was not releasing the lock when the update was complete. Lock the table in SHARE mode and and run the update. That should do the trick. } } The update command is very simple (for instance update echeances set } ech_point="O" where rowid=123). } } Where is the problem, what's wrong with our system ? Any help is welcome. } } Thanks } } Fred } } +------------------------------------+--------------------------+ } | Frederic BOUQUET | Phone : (33) 77 93 57 46 | } | Cornut Informatique | Fax : (33) 77 92 51 39 | } | 24, rue de la Telematique - BP 702 | AppleLink : CORNUT.INF | } | 42950 St Etienne cedex 9 FRANCE | Compuserve: 100303,1061 | } | frederic_bouquet@ascus.com | | } +------------------------------------+--------------------------+ } } -------------------------------------------------------------------------- } U.S.A. | AppleLink : ASCUS } About Software Corporation | eWorld : ASC.US } 10601, South De Anza Blvd. |America Online : ASCUS } Suite 105 | Compuserve : 73243,36 } Cupertino, CA 95014 | Internet : info@ascus.com } general phone : (408) 725 4242 | Anonymous FTP : ftp.ascus.com } sales : (800) 55 SOFTWARE | ARA Server : (408) 725 4250 } tech support : (408) 725 4240 |FirstClass BBS : (408) 725 4252 } fax : (408) 725 4243 | bbs.ascus.com } -------------------------------------------------------------------------- } FRANCE | AppleLink : ADV.SOFT } ASC | Compuserve : 76034,2123 } 9551, route de St Laurent du Var | Internet : euro_info@ascus.com } F-06610 La Gaude | Anonymous FTP : ftp.ascus.com } general phone : +33 93 24 76 00 | ARA Server : +33 93 24 76 03 } fax : +33 93 24 76 06 |FirstClass BBS : +33 93 24 76 13 } -------------------------------------------------------------------------- } ========================================================================== == George Teachman == == Soil Scientist == == United States Department of Agriculture == == Natural Resource Conservation Service == == Fort Collins, Colorado == == 303-282-1960 == == == == george@talon.ftc.nrcs.usda.gov == == ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ == == Welcome to earth, third rock from the sun. Cause and effect. == == There are only three laws of nature, and one exception. == == 1) F=ma; 2) E=m(c squared); 3) You can't push a rope == == From these three laws all others can be derived. == == Except those explained by CHAOS THEORY. == ==========================================================================