how to delete used process?

, ,
1

hi.

Now we’re using wm71 with MWS.

is there any solution to delete used process?

please advice

2

Try Archive and Delete the process instead just Deleting the process…

3

But, how do you archive?

4

Oh, I got it. It’s in the “Getting_Started_with_Business_Process_Management_7_1.pdf”. Search for “Delete unused”.

In detail,
select * from analysis7.bam_pt_process_meta where process_name = ‘%YourProcessName%’

To find the process you want to delete.

5

if it can, could you explain more detail?

6

I found Delete unused. but there is no solution.

how to delete used process? could you explain more detail?

7

Did you try

delete from analysis7.bam_pt_process_meta where process_meta_id = (select process_meta_id from analysis7.bam_pt_process_meta where process_name =‘%YourProcessName%’)

After this, you should refresh your browser.

8

I would recommend, using the Data Managment → Archive link in MWS to remove or archive used process instances.

9

For deleting a used process; we have first delete the whole instances that were completed/started or in any status of that particular process. This can be achived by using the below scripts.

Delete from wmprocessassoc where rootcontextid in(
Select b.Rootcontextid from wmprocessassoc b,wmprocess a
where
a.rootcontextid=b.rootcontextid and
a.processkey =‘SampleProject/Sample’)

delete from wmprocessrecent where processkey =‘SampleProject/Sample’

delete from wmprocessstep where rootcontextid in(
Select b.rootcontextid from wmprocessstep b,wmprocess a
where
a.rootcontextid=b.rootcontextid and
a.processkey =‘SampleProject/Sample’)

delete from wmprocess where processkey =‘SampleProject/Sample’

After running and commiting the above script in ur webMethods schema; Login to MWS as Administrator
Navigate to Administration>Business>BusinessProcess.
The process that is to be deleted(Sample) will have enabled check box.Click on the checkbox and click delete.!!

1 Like
10

Hi,

When ever there is a update/modify/delete being done on a process model, to make the changes effective either restart the Server or reload WmPRT package manually.