Record Is Being Updated - Access Denied

Dennis Malen dmalen at malen.com
Thu Jun 13 11:07:33 PDT 2013


Ken,

The following are comments concerning your three suggestions in your email
below:

(1) explicitly unlocking the file.  KEN, DO YOU MEAN TO ACCESS "? - filePro
Directory" AND UNLOCK THE FILE? This does not work for me.

(2), closing the file, which removes all locks - KEN, HOW DO YOU CLOSE THE
FILE? I KNOW HOW TO DO SO WITH A PROCESSING COMMAND. IS THAT WHAT YOU ARE
REFERRING TO?

(3) exiting (or being killed) which closes all open files - KEN, DO YOU MEAN
FOR EACH USER TO EXIT THE FILE. IF SO, THAT IS MY PROBLEM AS EVERYONE IS
LOGGED OFF WHICH IS CONFIORMED BY THE "WHO" COMMAND AND THE RECORD IS STILL
LOCKED.

Dennis
-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Thursday, June 13, 2013 10:26 AM
To: Dennis Malen
Cc: filepro-list at lists.celestial.com
Subject: Re: Record Is Being Updated - Access Denied

On 6/12/2013 5:41 PM, Dennis Malen wrote:
> I do all of that. Just need to know when all that fails is there any 
> other way to unlock the record without a reboot.
>
> It is starting to happen more often.
[...]

The only way to have a file/record lock removed is to have the process that
owns the lock remove it.  This can be done by (1) explicitly unlocking the
file, (2), closing the file, which removes all locks, or (3) exiting (or
being killed) which closes all open files, which in turn unlocks them.

Use showlock to see which process has it locked, and if it's "happening more
often", figure out what that person is/was/doing.

--
Kenneth Brody



More information about the Filepro-list mailing list