Link to home
Start Free TrialLog in
Avatar of terrypba1
terrypba1

asked on

VFP9 Server Can't lock file

Hi
After several years of plain sailing, I've twice this week had the server (Windows 2008) fail to lock the same file file in a VFP9 application. This happened a few years ago and the solution was to reboot the server--worked then and worked now, but I am concerned that it has happened twice now in a week. Is there anything I should be looking at? This is happening on one particular PC (all W7 Pro).
Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Rob-Nilsen
Rob-Nilsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of terrypba1
terrypba1

ASKER

Thanks Rob-
1. This is a file that is only updated by one user on a 20 user system--pretty sure no one else was running that program. The file itself is rarely accessed otherwise.
2. The AV is certainly a possibility, but seems unlikely to only affect one particular file?
3. The controller configuration issue is something I'll ask the network supplier about, but again, why the same file?
I am going to double check that I disabled write behind caching on the individual PC.
Terry
SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hmm. Others do use the file, but the error has only been reported by the one user.
EXCL is set off by default on all forms, and this multi-user app has been running for 5 years, with no similar issues.
The forms update tables via local views, with buffering set to 5, Optimistic Table Buffering.
I have to admit I've never heard of SMB2. Since this has not been an issue before, I assume it's been set correctly?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Excellent point Olaf--I'll certainly look at the SMB2 settings.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'd hate to think I'm running into size issues. This particular file has 13,000 records, total size 3 meg. The form uses three other additional files, all smaller.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Oops, for got to link to the article in my last post!

Here:

http://www.tek-tips.com/viewthread.cfm?qid=657369
Thanks Rob--
Getting a list of things to check Monday, when I'll be in to check things out. Certainly disabling write caching is on my checklist setting up any PC but I'll be double checking that on this PC and the one other that makes use of this particular file.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for all the input. Looks like step one will be to swap out the PC tomorrow.
I'm checking out the server from home and don't see the option to disable caching in the device manager.
Drive is Adaptec Raid 1 SCSI Disk Device. There is no policies tab.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have swapped out the suspect workstation and am watching to see if the error recurs. (Lost 10 minutes and a few grey hairs trying to figure out the grading system here. All answers were very helpful but apparently I have to assign points to my responses as well. I'll have to try again later.)
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
Does this mean some general EE cleanup?
Even when author did not confirm any solution this question contains valuable output from several experts. The deletion just means (to me) experts are not welcome at EE...

If you still think it should be deleted do it.
To show some respect to experts you could select ID: 41472099 as an answer.
Well, especially since terrry finally wrote he wanted to assign points, but couldn't cope with the rating system, there is value in the answers here, even though it's understood you can't choose what helped most.

Bye, Olaf.