[cosyxu]

Hi Amo,

Could I ask how to delete a case which has been canceled? I have many cases of this process and I don't want to delete all the cases from the design page.

And because of this case, I can't delete the task which caused the error, please see attached screenshot.

Thanks,
Yuan

[amosbatto]

There are two ways to get around this problem.
1. Go to Designer, select the process in the list and then click on the Delete Cases button. This will delete all cases in the process.
2. Run a case in the process with the Debug Mode activated, so you can see the ID of the PROCESS system variable. Then, from the command line of your PM server, do this:

Code: Select all

mysql -u root -p
mysql> DELETE FROM wf_workflow.APP_DELEGATION WHERE APP_UID IN (
SELECT APP_UID FROM wf_workflow.APPLICATION WHERE APP_STATUS='CANCELLED' 
AND PRO_UID='16054562159e4c5fc01f2f5060283216');
mysql> DELETE FROM wf_workflow.APPLICATION WHERE APP_STATUS='CANCELLED' 
AND PRO_UID='16054562159e4c5fc01f2f5060283216';
mysql> exit;

Where wf_workflow is the name of your workspace's database and 16054562159e4c5fc01f2f5060283216 is the ID of the process.
This will only delete the CANCELLED cases in the process.