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.