Received File Locked Message During Import But There's No One Else Opening That File
Release Date: 10/31/2023
Version: 7.x & Up
Q - Elliott's COP Billing Selection CSV Import works well. But on the printing output, we get an error message stating
***
Original File Could Not be Deleted, Was Open in Another Program
See sample screen below:
We confirmed there is no other application opening this file. What may cause this to happen?
A - We investigated this issue together with the user and found this to be a permission issue. We first tried to cut and paste the file from the source folder and we noticed that there's a security elevation prompt asking the user to permit or deny.
Generally speaking, any NTFS security settings that will cause UAC security elevation to prompt "permit" or "deny" will not work well with Elliott's import program. The typical Elliott import program will try to delete the ASCII file upon import. Since Elliott can't interact with the UAC security elevation prompt, the import will be problematic. In this case, the user is part of the Administrator group. So the security policy will prompt the user to elevate security. To avoid UAC security elevation prompt, users should be granted explicit NTFS rights to the folder. Do not rely on the implicit rights (e.g. user implicitly has the right because user is part of the admin group.)
For more information on UAC security elevation, see the following KB article:
EMK
Related Articles
Feature - Added Phantom Locking to Customer File Maintenance
Release date: 6/4/2018 In the past, when a user brought up a customer master record in Customer File Maintenance Change mode, the customer record would be locked. Any other users who tried to update that customer record -- including when printing a ...Feature - Added Phantom Locking to Item File Maintenance
Release date: 6/4/2018 In the past, when a user brought up an item master record in Item File Maintenance Change mode, the item record would be locked. Any other users who tried to update that item record -- including quantity on hand, on order, or ...Received Message "Must Run COP Setup First"
Q - Elliot froze up for about 90 seconds with this message: Must run COP Set Up First After 2-3 minutes everyone could get back in. Is this something we should be concerned about? A - Someone locked the COP Setup File to cause this problem. This ...Btrieve Error USE on COP Lock File
Q - Today, for whatever reason, we experienced a large amount of locking issues in the warehouse. Several times today we ran into the problem with printing invoices where we received a message "Btrieve Error USE on COP Lock File," and it stops ...Feature: Send an Email to the User Locking a Record
Release Date: 1/26/2023 Versions: Elliott V8.5 and Above Background Some Elliott tasks, like COP Order Entry / Change Order, will cause a record to be locked while the task is executing. Subsequently, another user will start a task, like COP Order ...