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
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 ...User Received Lock Message on NSCTLFIL 000000100 in Sales Desk
Release Date: 7/10/2019 Version: 7.0 & up Q - A user received this lock message when searching for a customer. We never see locks on the NSCTLFIL and I know they can cause issues for everyone if they happen. I do not know what user DUDA was doing. ...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 ...Presales Import
Release Date: 3/1/24 Revised: 8/29/24 Version: 8.6 and Above The Presales import will have similar functionality as the warehouse receiving CSV import. 1. Receipt File Name: CSV file name to be imported. Defaults to SH*.CSV. Press F1 to change import ...How to Remove Order Locked Message During Invoice Printing
Release Date: 03/10/2023 Version: 8.x & Higher Q - During invoice printing, we may receive the following message box popup: Order XXXXXX Customer Name..... is locked See sample screen below: If we click "OK" on the message, then the order is skipped ...