How to Delete a Batch Instance Stuck in RESTART_IN_PROGRESS

Issue:

Batch instances are stuck in the RESTART_IN_PROGRESS status and do not restart. This is a known issue and has been resolved in Ephesoft Transact 3.1.2.9 and above. 

Root Cause:

Batch instances may get stuck in the RESTART_IN_PROGRESS status due to back-end processes that do not allow Transact to complete the restart process.

Solution:

To delete a batch that is stuck in the RESTART_IN_PROGRESS status, alter the record for the batch instance by running the following SQL command:

update batch_instance set batch_status=’ERROR’ where batch_status =’RESTART_IN_PROGRESS’;

Once the batch status has been changed,  you can properly delete or restart the batch instance.