Kevin,

After upgrading PFW from build 10.0.0.719 to 11.0.0.676 the .LCK files are
now cleared successfully upon exit.

With that problem fixed I now have to tackle the larger one in which performance
of processes requiring lots of read/writes and calculations has slowed dramatically.
 A process that ran in 2 minutes in the Server 2012 environment now takes
33 minutes after all the servers were upgraded to Server 2019.

The server upgrades were all of in-place type so the settings should theoretically
have stayed the same but somehow 2019 is throttling read/writes across the
network of the PFW files.

Quelle nuisance!

Bradley Wood

"Kevin Zawicki" <numberjack@wi.rr.com> wrote:
>
>
>LCK files seem to mysteriously hang around in the PRIV sometimes.
>
>The appCrash is interesting, maybe whatever is causing the lck file delete
>failure is resulting in that? Hard to tell what comes first, failed delete
>or appcrash causes skipping the deletion.
>If Paradox crashes, LCK files are orphaned. Long ago on my larger systems
>I created a nightly sweep (or on reboot) that deletes all files s in all
>users PRIV folder and deletes the NET file. It solved many issues.
>
>Does your code have any attached table vars or not closed tcursors? Something
>like that?
>
>>
>Since the Remote Desktop server from which the application is run was upgraded
>from Server 2012 to 2019 the .LCK files in the user's private directory
are
>no longer being deleted when exiting PFW.
><
>
>Where are the application files?
>Do the users RDP to a server and run Paradox on it? Or is Paradox installed
>on each PC?
>
>If on a server, can you log into the server directly without RDP, open paradox,
>edit a table, see the LCK file in your PRIV, close table, close paradox
and
>see LCK file delete?  (not using RDP)
>
>Server 2012 to 2019 seems to be where to look, but if nothing else changed,
>rights, architecture, NET file location same for all users, it seems odd.
>
>What about UAC on the machines?
>Liz suggested running as admin, try that, but not only login as admin, “RUN
>AS” administrator.
>
>Lastly, delete the NET file.
>
>
>
>
>
>Liz McGuire <liz@paradoxcommunity.com> wrote:
>>What happens if you run as administrator?  Just for testing purposes. 
That
>would help
>>determine if it's a rights issue.  (Just because the users can do it does
>not mean
>>that an app, even if run as that user, has the rights.)  Also, have you
>tried running
>>Paradox in some compatibility mode - working backward - to see if that
works?
>>
>>Oh, finally, make sure all antivirus software is set to ignore the Paradox
>executable
>>and all directories where it and the database files live.
>>
>>Liz
>>
>>
>>On 25 Aug 2023 09:10, Bradley Wood wrote:
>>> Steve,
>>> 
>>> Thanks for your responses!
>>> 
>>> 1. Local Share in the BDE was set to true.
>>> 
>>> 2. I was able to configure the startup and associated cleanup into a
bat
>>> file as a temporary work around but I was hoping to identify some setting
>>> (likely related to network security) that would prevent the AppCrash
event
>>> on exit when it attempts to delete the .lck files.  It's interesting
that
>>> it does cleanup all the temporary files in the :PRIV: dir that start
with
>>> the "__.." prefix but stumbles over the .lck files.
>>> 
>>> Again, thanks for your help.
>>> 
>>> Bradley Wood
>>> 
>>> Steve Green <steve@oasistradingpost.com> wrote:
>>>>> As a final configuration point, SMB2/3 has been disabled on the RD
&
>>>>> App servers, SMB1 has been enabled, and OpLocks has been disabled.
>>>>
>>>> and Local Share in the BDE must be TRUE.. could be the solution needed,
>>> too
>>>>
>>>>
>>>>> Since the Remote Desktop server from which the application is run was
>>> upgraded > from
>>>> Server 2012 to 2019 the .LCK files in the user's private
>>>> directory are> no longer being deleted when exiting PFW.
>>>> you should be able to easily wrap the startup in a bat file and kill
>the
>>> 
>>>> lock files first, if necessary
>>>>
>>>>
>>>> -- 
>>>> Steven Green
>>>> Myrtle Beach, South Carolina USA
>>>>
>>>> http://www.OasisTradingPost.com
>>>>
>>>> Collectibles and Memorabilia
>>>> Vintage Lego Sets and Parts
>>>> - and Paradox support, too
>>>>
>>> 
>