Are the channels not restarted after a few seconds? Does fw_start.log contain any useful info, such as channel restart messages? How about the task manager? Count the number of VFP.EXE processes (or fwserver.exe, if you are using the VFP Run-Time DLL). These should be equal to the number of channels you are running, plus any other instances of VFP you have opened manually. While you are there, look for dw15.exe or dw20.exe processes. These would almost certainly be the cause.
One possibility is that the script contains code that intermittently pops up a dialog box (such as the Open Table dialog). If after examining fw_start.log and the task manager you don't find useful clues, you should try running FoxWeb as a regular app (as opposed to a system service), with the channel windows visible (you can do so from the tray icon). Once the problem occurs, examine the channel windows for any visual clues.
FoxWeb Support Team
Sent by Jeff Grippe on 09/12/2011 11:45:50 AM:
I have one script (out of hundreds) that seems to periodically crash FW. The script works most of the time but sometimes it locks up all the channels and requires me to restart FW. As soon as I restart FW, it works fine again.
As scripts go, it is one of the simpler ones. It contains two SQL queries and a loop that displays the results in a table.
My two question are:
1. Can you suggest debugging techniques to find it. I realize that intermittent problems are the hardest to find since most of the time, the script works just fine.
2. We are currently on FW 3.0 and VFP 7. Would you recommend and upgrade to FW 4.5 and VFP 9.0? Other than some queries which will need SET ENGINEBEHAVIOR 70, are there other problems that we can anticipate?