abnormal program termination

sourceuno · Post by **sourceuno** » Tue Jul 10, 2001 11:52 am

I'm running a script that retrieves data. I usually let this script run overnight. When I check it, usually hours after I start the script, I get the error "Abnormal program termination". Do you have any ideas what might be causing this?

Post by **Kai** » Tue Jul 10, 2001 12:05 pm

Are there any error messages printed out or in the vortex.log that pertain to that script? How exactly is the script retrieving data; via <fetch>, <timport>, <read>? What is it doing with the data? What SQL statement(s) might have been executing at the time of the error?

sourceuno · Post by **sourceuno** » Tue Jul 10, 2001 12:27 pm

There are no error messages in the log file that pertain to the script. The script is retrieving data using <fetch> and then inserting the text of the page along with a few other fields into some tables. I haven't really investigated where the exactly the script is stopping. It might be possible that it exits before an insert.

Post by **Kai** » Tue Jul 10, 2001 2:02 pm

Try to narrow down the exact SQL statement that was running at the error. Also, what version of Vortex is this (texis -version)?

sourceuno · Post by **sourceuno** » Tue Jul 10, 2001 2:24 pm

Here's the version info:
Texis Web Script (Vortex) Copyright (c) 1996-2001 Thunderstone - EPI, Inc.
Commercial Version 3.01.984682785 of Mar 15, 2001 (i686-intel-winnt)

I'll try insert some dummy statements to find out where the error is occuring and let you know where it stops if I see it.

Post by **mark** » Tue Jul 10, 2001 2:48 pm

Vortex will generally print a script name and line number when there's an error in a script, or otherwise bails out. Make sure you're not suppressing putmsg output.