-457 ERROR MESSAGE

}:jmejia@cdcnet.uniandes.edu.co (Juan Gabriel Mejia) }: Does anybody know what are the general possibles causes of the -457 error? }: (not the trivial causes that informix help gives). The -457 err. is communly }: complemented with an ISAM error code, But in my case I haven't got an ISAM }: err. code. }June Tong <junet@informix.com> }It would help to know which engine you are running, and which version. } }If this is OnLine, pre-DSA, then probably your sqlturbo has died. Check your }online.log for error messages. R/ Some days ago I posted something such: **************************************************************************** ************ } We am working with PowerBuilder Enterprice 4.0 (under Windows 3.11 - } in a PC 486 DX266 16MB RAM) } Informix OnLine 5 and I-Net 5.0 (under Unix on a Unisys machine) } The net works with TCP/IP (win 32 or PCTCP) } } Sometimes and sudenly when the application executes a Datawindow } Retrieve (SELECT) instrucction, I-net reports the error num. -457 that means } something like "Yor process have been kill" (well, you know the text of this } error) and my PB aplication is disconected from informix (this is: the } sqlturbo process hangs!! expontaniusly!!!!!!). } This error happens very often - so you can imagine what } the users are saying! } } (Another error like "To many hosts variables are passed to the server" (-257) } were also reported, but we have avoided it using a tric in PB!) } } Trying to solve the -457 error we have made the changes in the } system parameters (Unix and Informix): } } Informix Parameters: } SPINCNT } BUFFERS } MEMORY SEGMENTS } TIMEOUTS } Etc. } } Unix Parameters: } The ones related with semafores } The ones related with shared memory segments size } We are looking for timeouts, but the are no clues. } } } Now are almost convinced that the source of the problem is the NetWork. But } who knows? } } And the amazing thing is that the online.log file reports nothing more but: } "09:40:16 Process Aborted Abnormally: pid=7371 user=1681 us=800e51a4 flags=1" } And, we are also "surprised and dismayed that *no* page errors/bitmap } errors, etc., showed up in the log". ???????? } } By internet I have received some clues that point to the following sorces of } our problem: } } -BUG in I-NET 5.0WF1 } -BUG in Informix Online 5.01 } -BUG in PowerBuilder } -Unix timeouts settings } -Network timeout settings, sockets settings **************************************************************************** **************** Thanks in advance! Any clues are appreciated! _______________________ Juan Gabriel Mejia jmejia@uniandes.edu.co _______________________