I have an FPD app and a VFP app that accesses the same table with no issues, but the VFP app is a "monitor" app that opens/closes the table every 5 seconds and runs on the server. It runs for weeks/months without problems (until it needs tweaking/updating).
The VFP app creates Excel files and PDF files (Bullzip) for the FPD app and/or sends emails via Gmail. Fred On Sun, Sep 4, 2011 at 9:02 AM, Rick Schummer < pro...@whitelightcomputing.com> wrote: > Hi Kent, > > >> It does not happen very often, but when it happens it is a real hassle > and shuts down the operations.<< > > We are experiencing a problem like this with a single process that runs > 24/7, and the quick fix is to reboot the app and > all is normal again. We cannot figure it out either. > > Any chance you have a FoxPro DOS or FoxPro for Windows (the 16-bit > versions) accessing the same data? We do, which is > why I ask. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.com > > -----Original Message----- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of Kent Belan > Sent: Saturday, September 03, 2011 09:30 > To: profoxt...@leafe.com > Subject: RE: Error 1104 > > Hello Ted, > > Thanks for responding. This is not one of those "easy" problems to fix. > > This may not be a unique setup, but it is very complex (for me at least). > > Yes, all the VFP EXE's are running on the same computer, a Windows Server > 2003, Web Edition SP2. > > The VFP EXE is listening on a IP:Port to receive the incoming request > string from the VB "traffic cop". It processes the > string and then returns the answer string on the same port. There is a > custom hand shake that takes place that the VFP > EXE sends to the VB program on that port to let the VB traffic cop know it > is ready for another transaction. > > I have added a mini close/open routine that now will close the open tables > and reopen after each transaction to see if > this helps. We had this at the beginning of the project, but turned it off > so the tables would stay open to increase > speed. > > Will have to wait and see if this helps. This weekend should be a good > test. > > Go DAWGS !!! > > -----Original Message----- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf > Of Ted Roche > Sent: Friday, September 02, 2011 8:04 PM > To: profox@leafe.com > Subject: Re: Error 1104 > > On Fri, Sep 2, 2011 at 4:33 PM, Kent Belan <kbe...@mchsi.com> wrote: > > > I have an application that stays running 24/7 and during some parts of > > the day can have very heavy volume. > > > > Every once in a while and not at the same place in the code, the > > program will error with 1104 - Error reading file. "The operating > > system returned an error while VFP was attempting to read the > > specified > file" > > > > If I stop the EXE and start it right back up, everything is good. > > > > Nothing is done to the computer, no reboot or remapping of network > > drives, just restart the VFP EXE. > > > > This is a very unique setup. > > Kent: > > You may be surprised to learn that it's not. Many VFP developers have > implemented similar farms of VFP apps feed by job > queues. I've worked on a couple of projects that used something similar. > > It's a dirty little secret that apps that support pools of worker threads > like IIS or MySQL terminate the threads after > so many calls, or so much time, in order to avoid them failing in the > various modes long-running threads do: memory > bloat, failed garbage collection, etc. > > > Since VFP is not multi-threaded, there is a VB program that receives > > requests from a TCP/IP socket and then passes the request to one of > > many VFP EXE's waiting for a transaction. > > > > There can be 2 to 20 VFP EXE's running at the same time waiting and > > processing requests. > > Are they all running on the same machine? Which OS (es)? > > > > > Everything works great, until the 1104 error starts happening and then > > all VFP EXE's get the same error and all have to be shut down and > restarted. > > > > It does not happen very often, but when it happens it is a real hassle > > and shuts down the operations. > > > > Any ideas on what may cause the 1104 and a possible solution ? > > Yeah, something broke the shared file handle and all the apps lose the > connection. How is VFP getting the new job? Is is > trying to read a file or a DBF it keeps open long-term? Try closing it and > opening it only when needed. > > Google's got a couple of useful hits on "VFP Error 1104" > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksr-rEsqHpVT3RLZpCO=nDstG5yY8nMghPm=ppi82lk...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
