Can't run reports because file locked?

Kenneth Brody kenbrody at bestweb.net
Thu Sep 8 08:29:38 PDT 2005


Quoting Dan Snyder (Thu, 8 Sep 2005 11:12:47 -0400):
[...]
> If personA (anyone) goes into a specific filePro file (psales) using
> "B-Inquire, Update, Add" and then personB (anyone else) tries to go into
> "D-Request Output" for that same file personB will get the following
> error message.
>     *** A filePro Error Has Occurred ***
>     Inquire, Update, Add Function Running On This File
>     File not available.
>     Somebody else is modifying the file;  try again later.
>
> PersonA is not doing an add or update, they are simply doing an inquiry.
> If I delete the lockfile personA can get into the file in question.

Rule #1:  Never remove the lockfile while the file is in use, unless
you like getting "help, our file is corrupted!" calls in the middle
of the night.

[...]
> I have tried to use the "showlock" utility and Bob Stockler's lock.info
> shell script at <http://www.hvcomputer.com/download/public.html>
> http://www.hvcomputer.com/download/public.html to figure out what is

Rule #2:  Record locking and the lockfile have nothing to do with each
other.

[...]
> Does anyone have any idea what is causing this or how to fix it?

If you want to allow the report to run while others are in *clerk,
include the "-u" flag on the *report command line.  That's what it's
there for.

[...]

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list