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 from the Customer Support Portal Downloads page and follow the steps below to deploy:

1. Stop the Ephesoft Transact Service.
2. Download and extract the hotfix 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.

4. Backup the existing .ktr file and delete the original.
5. Copy the backup .ktr file to the <ephesoft_home>\Application\WEB-INF\classes\META-INF\dcma-reporting\Migration
6. Navigate to the <ephesoft_home>\Application\WEB-INF\classes\META-INF\dcma-reporting\Dashboard
7. Backup the existing .ktr file and delete the original.
8. Copy the extracted .ktr file to <ephesoft_home>\Application\WEB-INF\classes\META-INF\dcma-reporting\Dashboard
9. Start the Ephesoft Transact service.
10. Verify that the batches in the FINISHED state no longer appear on the Batch Instance Management screen. If they are, then you have successfully applied the hotfix.