'Pending Cancel' issue

  • KM03584362
  • 31-Jan-2020
  • 26-Apr-2021

Summary

clear Pending Cancel status

Question

the a flow execution stays in the 'Pending Cancel' status for long or forever

Answer

DB:Mysql
Run the sql script the OO DB.

use $your_db_name_here;
UPDATE OO_EXECUTION_SUMMARY
SET STATUS = 'CANCELED',
CANCEL_REASON = 'MANUAL',
END_TIME_LONG = START_TIME_LONG,
RESULT_STATUS_TYPE=NULL,
RESULT_STATUS_NAME=NULL,
ROI=NULL
WHERE STATUS = 'PENDING_CANCEL';