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: Databa

Issue

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".

Solution

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 

Easy

Applies to