Hola Miguel.
Aren't you running out of space for the temporary file required to do the
sorting ?, Does your'e configuration consider a temp dbspace ? What size is
it ? Size of the data ?...
>From: "Miguel 'ngel Ferrer (EOS Inform'tica S.A.L.)" <ma-ferrer.eos@ctv.es>
>Reply-To: "Miguel 'ngel Ferrer (EOS Inform'tica S.A.L.)"
><ma-ferrer.eos@ctv.es>
>To: informix-list@iiug.org
>Subject: Error -565 in Informix Online WorkGroup Server 7.30
>Date: Wed, 6 Oct 1999 13:51:04 +0200
>
>Error -565 in Informix Online WorkGroup Server 7.30 Windows NT
>
>Please help!
>While I am executing an Informix 4gl program the system gives me this
>error:
>SQL statement error number -565.
>Cannot read sorted rows.
>SYSTEM error number -172.
>ISAM error: Unexpected internal error>
>-565 Cannot read sorted rows.
>This is an internal error reflecting an unexpected condition while
>performing a sort. Check the accompanying ISAM
>error code for more information. If the error recurs, please note all
>circumstances and contact the Informix Technical
>Support Department.
>-172 ISAM error: Unexpected internal error
>You encountered an unanticipated internal event. Consult the online.log to
>see if OnLine's diagnostics preserved any
>further information regarding this event. If the error recurs, please note
>all circumstances and contact the Informix
>Technical Support Department.
>
>I consulted the online.log an it's all OK. Only I usually saw this message
>but I don't know it's related whith my problem:
>22:17:46 dynamically allocated new shared memory segment (size 8388608)>
>The Informix Online is up 20 days and this problem only occurs the last
>three days.
>
>Miguel 'ngel Ferrer
>ma-ferrer.eos@ctv.es
>EOS Inform'tica
>
>
Angel Gomez
TelNor, S.A.
Tijuana, B.C., Mexico.
<Angel.Gomez@telnor.com>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com