The following error is occurring in when attempting to process Batches in KTM Server:
"BeforeExtraction: BeforeExtract: The execution of a locator method failed. Class = "Invoice", Locator = "DB_VendorInfo", Original error message: Database: Failed to import file. \\KCServer\CaptureSV\Path_to_DB.txt".
A common cause of this error are a permission/access issue to a database file located in the path described in the error message.
There is a known issue in which the database file can become locked by the operating system when being accessed by one extraction service, and a second extraction service is attempting to access the file at the same time.
This can be observed by taking a Process Monitor trace, and observing a “Sharing Violation” when the KTM process is accessing the database text file.
Level of Complexity