Access Denied

[Richard Kreiss]

Ken,

Should have a copy of this with my copy of 5.8. I will upload it and check after mid-night as everyone will be off the system. 

Richard
Sent from my iPhone

> On Feb 16, 2016, at 5:16 PM, Kenneth Brody <kenbrody at spamcop.net> wrote:
> 
>> On 2/16/2016 5:06 PM, Richard Kreiss wrote:
>> Having an odd problem - my client recently moved his application to a new
>> server and has run into a problem where one record is locked and causes a
>> task to hang.
>> 
>> This person's record was last accessed almost 10 years ago except by
>> reports which are run daily. (Record Is being Updated - Access Denied).
>> 
>> I am not sure if this is a filePro message or a system message.  The
>> server can be rebooted tonight after midnight if this is a OS lock.
>> (Windows Server 2012).
>> 
>> Anyone have a suggestion as to why this record would be locked when no
>> one is accessing it?
> 
> "Record is being updated - access denied" means that filePro requested the record to be locked, but the system returned an error that the record was already locked.
> 
> Unfortunately, there is no way that I know of to enumerate locks on a file on Windows.
> 
> There is a utility, "WhoHasOpen.exe", which I believe is now included in the filePro distributions.  If not, fpsupport can send you a copy.  It won't show what locks are on a file, but it will show you which processes have a file open.  Simply run it on the file's "key" file, and see if there are any processes that you didn't know about.  (Get everyone out of filePro first, if you desire.)
> 
> -- 
> Kenneth Brody