How to stop all work
When the performance of WorkFusion SPA becomes a concern: Control Tower is slow, WorkSpace is not opening Manual Tasks, it is advisable to check the number of active Business Processes (BP). If active BPs include many obsolete ones, it is recommended to stop all running BPs and re-enable only necessary ones. To understand which BP runs are queued up or draining hardware resources, check the Execution queue monitoring topic.
note
Most of the queries below change the system state. Use them mindfully and with the understanding of the risk you are taking.
Check active BPs
You can identify running BPs via the following query:
select status, count(*)
from Run
where status IN ('MACHINE_PROCESSING', 'PROCESSING')
group by status;
Stop BPs
If BP instances contain active manual steps, the easiest way is to stop them via API.
If BPs consist of bot steps only, you can stop them via database queries. However, the Tomcat server should be stopped during the query execution.
update Run
set status = 'PAUSE'
where status = 'MACHINE_PROCESSING';
Stop schedules
To perform the operation, stop the Tomcat service:
update ScheduledUploadRequirement
set status = 'PAUSED'
where status = 'STARTED';