Re: SYSTEM call from trigger error

Jonathan Oei wrote: > > We are using Informix On-Line 7.20.UC3 and have a simple trigger on a > table that fires after an insert. During the trigger, we build a > string that contains a path to an external .4ge program. > > So far, so good, this has been working for months. > > But now, we get this error from the trigger trace: > > exception : looking for handler > SQL error = -668 ISAM error = -172 error string = = ""> exception : no appropriate handler > > Using finderr on the numbers doesn't give much help. > ------------------------- > -668 System command cannot be executed. > > A system call failed in the operating system. The following example > shows a statement that might cause an error: > > SYSTEM 'hello'; > ------------------------ > > So, it seems that the trigger can't find the executable. But, the > path statement is fine (it is a full path). The directory tree has no > permission problems and if we execute the external from the shell it > works fine. > > ----------------------- > -172 ISAM error: Unexpected internal error. > --------------------- > > The online.log file shows nothing. > > Any clues? > The mysterious part is that everything was working and nothing > (as far as the external program) was changed. The shell forked by the SYSTEM call will have the environment of the online server, I presume. Have you changed this? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/