Learn Databases Error in Ephesoft Transact 2019.2

Applies to: Ephesoft Transact 2019.2
Resolved in: Ephesoft Transact 2020.1

Issue

In Ephesoft Transact 2019.2, when mapping a certain index field to a database field in FuzzyDB Extraction Configuration, the following error message displays: Unable to Learn databases. An issue in learning occurs when the primary key column mapped in the document fuzzy is used in mapping fields and is marked as searchable.

Figure 1. Learn Databases Error 

Workaround

To prevent this issue, perform the following:

  1. Stop Ephesoft Transact.
  2. Download this hotfix.
  3. Extract this hotfix to a temporary location
  4. Navigate to the following directory: [EPHESOFT_HOME]\Application\WEB-INF\lib\HOT-FIXES
  5. Ensure there is no JAR named dcma-fuzzydb. If there is, take a backup and remove it from this directory.
  6. Copy the extracted JAR dcma-fuzzydb_EEN-22768_30_July_2019.jar to the following directory: [EPHESOFT_HOME]\Application\WEB-INF\lib\HOT-FIXES
  7. Start Ephesoft Transact.
  8. Test and verify if you can successfully perform the LearnDB task.

Solution

To resolve this issue, upgrade to Ephesoft Transact 2020.1 or above.