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 ...Sales Order Import Interrupt Error Message
Release Date: 12/6/2019 Version: All Q - How does the below message come about? Should I rename DAL.TX$ to DAL.TXT and have them re-import? Interface file m:\macola67\salesorderimport\DAL.tx$ exists. This usually indicates a failure of the previous ...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 ...What to Do with Locking Conflicts Between WMS and Posting Routine
Release Date: 10/01/2022 Version: 8.5 & Up An issue arose when the database of one of our Elliott users became inconsistent and caused some operational difficulty. After investigating the issue, we found out the problem was due to a user performing ...