Environment:

Ephesoft Transact 2019.1 on Windows with MSSQL database.

Issue:

There is an issue in Ephesoft Transact 2019.1 where the FINISHED batches in the Batch Instance Management screen do not get cleaned up using the CLEANUP job. The following error appears in the dcma-report-all.log

com.ephesoft.dcma.report.service.EtlServiceImpl – ess-sync_hist_manual_steps_in_workflow – An error occurred, processing will be stopped:

Couldn't execute SQL : MERGE hist_manual_steps_in_workflow AS TARGET

The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.

Solution:

A Hotfix has been deployed to resolve this issue. Download the hotfix and follow the steps below to deploy:

  1. Stop the Ephesoft Transact Service.
  2. Download and extract the HOTFIX_EEN-22958_2019.1_DB_MSSQL.zip to a temporary location.
  3. Navigate to the <ephesoft_home>\Application\WEB-INF\classes\META-INF\dcma-reporting\Migration

    Note: Replace <ephesoft_home> with the location where the Ephesoft Transact service is located.

  1. Backup the existing .ktr file and delete the original.
  2. Copy the backup .ktr file to the <ephesoft_home>\Application\WEB-INF\classes\META-INF\dcma-reporting\Migration
  3. Navigate to the <ephesoft_home>\Application\WEB-INF\classes\META-INF\dcma-reporting\Dashboard
  4. Backup the existing .ktr file and delete the original.
  5. Copy the extracted .ktr file to <ephesoft_home>\Application\WEB-INF\classes\META-INF\dcma-reporting\Dashboard
  6. Start the Ephesoft Transact service.
  7. Verify the batches in FINISHED state no longer appear on the Batch Instance Management You have successfully applied the hotfix.