- YES, it's an intermittent error that happens once in a while. It's happen more often when we have a lot of activity.
- No I don't close the files (DBF) myself. The close table option is checked in the configuration.
- YES, I'm using the default error handler
the error is 108 ..
108 File is in use by another user.
this error I don't have it
109 Record is in use by another user.
130 Record is not locked.
1705 File access is denied.
- NO I n'ever open file exclusively.
In all my programs I have this lines on top:
SET EXCLUSIVE OFF
SET REPROCESS TO 5
Sent by FoxWeb Support on 05/12/2014 12:39:08 PM:
You stated that you start to get the error when you have a lot of activity. Does this mean that you continuously get the error once you get it initially, or is it an intermittent error that happens once in a while, but goes away shortly?
You also stated that the file is always open. Does this mean that you don't close the file yourself and that you have disabled the Close Tables option in the FoxWeb Control Center?
A USE statement should only cause error 108, if the underlying file is locked. Do you ever open the file exclusively?
By the way, the FoxWeb Error Handler has some special code to deal with errors 108, 109, 130 and 1705. If one of these errors is encountered, it continuous retrying the statement that caused the error, before logging it and returning an error message. This suggests that the problem is in place for at least 4 seconds and is not a result of a momentary lock. I assume that you are using the default error handler, rather than replacing it with your own code.
FoxWeb Support Team
Sent by Martin Martin on 05/12/2014 11:49:10 AM:
I try to solve this problem for a long time now.
When I have lot of users and activity, I starting getting error that make no sense for me :
ERROR 108 : File is in use by another user.
When I go to the source code at the specified line number, it's a simple USE statement.
USE LOGIN IN 0 ALIAS LOGIN
I'm only use FREE TABLE so there are no .DBC
This file is always open. There are no way to open it exclusively. This script was executed over 20,000 times per day.
The error seems to be completely random in time and always on the a USE statement (first 2 or 3 lines of the program)
So, is it possible, if the same program was call on the same foxweb channel then foxweb run into problem?
Is this related to CLOSE TABLE option in the configuration tab ?
How can I solve this?
Thanks for your Help