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/5290c7ea.3080...@san-dc.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.
