Use of handle.exe or Process Monitor from Sysinternals, run on the server, will always show if there are open handles on it. We have a site where like idiots they are backing up all their VFP data using MozyPro, and if VFP files end up in the MozyPro upload queue then this sort of thing happens.
On Sat, Nov 23, 2013, at 03:21 PM, Jeff Johnson wrote: > I have seen this before. A file gets stuck in the open position with no > program attached to it. You can't open it exclusive even though there > is nothing running in the task manager that is holding that file. > Rebooting the server solved the problem. > > Jeff > > Jeff Johnson > SanDC, Inc. > (623)-582-0323 > > www.san-dc.com <http://www.san-dc.com> > www.cremationtracker.com <http://www.cremationtracker.com> > www.arelationshipmanager.com <http://www.arelationshipmanager.com> > > > On 11/22/2013 9:03 AM, Jeff Johnson wrote: > > On 11/22/2013 8:54 AM, Tracy Pearson wrote: > >> Jeff Johnson wrote on 2013-11-22: > >>> I have a site that has been working fine for years. All of a > >>> sudden one > >>> file is throwing the above error on one table only. You can view the > >>> table fine. The problem is on add. There is a stored procedure that > >>> bumps up the primary key on add. When the stored procedure is > >>> called it > >>> throws an error number 3 File In Use. Here is the stored procedure. > >>> * Lock until user presses Esc > >>> SET REPROCESS TO AUTOMATIC > >>> IF NOT USED('id') > >>> USE broker!ID IN 0 > >>> ENDIF > >>> SELECT ID > >>> ********************** > >>> SET ORDER TO TAG TABLE > >>> ********************** > >>> SEEK (tcAlias) > >>> IF FOUND() > >>> IF RLOCK() > >>> lnID = ID.nextid > >>> REPLACE ID.nextid WITH ID.nextid + 1 > >>> UNLOCK > >>> ENDIF > >>> ENDIF > >>> SELECT ID > >>> USE > >>> SELECT (lnoldarea) > >>> SET REPROCESS TO lcoldreprocess > >>> Any ideas? > >> Jeff, > >> > >> I suspect it is on the USE command. I have customers get this > >> behavior when > >> they have aggressive anti-virus or on demand backup tools that will > >> put a > >> temporary lock on a file that was just updated. > >> > >> Tracy Pearson > >> PowerChurch Software > >> > > > > Tracy: The stored procedure is working on all the other tables except > > this one. It just started yesterday. > > > > Jeff > > > > Jeff Johnson > > SanDC, Inc. > > (623)-582-0323 > > > > www.san-dc.com <http://www.san-dc.com> > > www.cremationtracker.com <http://www.cremationtracker.com> > > www.arelationshipmanager.com <http://www.arelationshipmanager.com> > > > > > > > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/alternative > > text/plain (text body -- kept) > > multipart/related > > text/html > > image/jpeg > > --- > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1385280123.18719.51345649.40b4b...@webmail.messagingengine.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.
