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 - Customer CSV Import
Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...Error 065 File Locked on USERS SY Users Lic. File
Release Date: 03/24/2021 Version: 8.0 & Up The incident involved a user who suddenly could not run Elliott 8.5 from the workstation. An attempt was made to reinstall the Pervasive client and to reinstall Elliott 8.5 on the local workstation, but ...ARECIMNT Accounts Receivable Customers and Contacts Import Utility
Last Update: 03/20/2024 Version: 8.0 & Higher Introduction This utility was the first utility we developed to handle the import and update of customers and contacts at the same time. Since then, we have developed a separate utility to import or ...APINVIMS Accounts Payable Invoice Import Utility
A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...Duplicate Deferred Processing Can Cause Locked Errors
Release Date: 12/26/2024 Version: 7.x & Up We monitor a user's record locking activities through Elliott events. On a weekend, we received 494 deferred processing locked errors like the following: After investigation, we found out that there are two ...