Re: 457: SQL engine terminated unexpectedly - please help

Phuoc Ho wrote: > > I get the above error message while performing a select statement on > certain tables on an SE database (version 5.x). Can someone please tell > me what it means. The "finderr 457" and the SE manual did not provide > any usefull information. > > Is there a fix for this? > > Thanks in advance > Phuoc Ho > NCIUG finderr v 7.12 returns: -457 Database server terminated unexpectedly. The database server process or thread with which your application program was working has terminated. The DBA may have shut the system down. The next most likely cause is an internal error. Look for operating system messages that might give more information. If the error recurs, please note all circumstances and contact the Informix Technical Support Department. Tip: Be sure to check the ISAM error code returned with this error. If it is -129, the database server has not terminated, but simply reached a limit on the number of concurrent user sessions (see the explanation of error -129). Are you running out of disk space or temporary file disk space? Is there enough room for the transaction log? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/ ---