When deploying a process flow using the control center of OWB (11r1), following error is raised:
Error: RPE-02062: ItemType PKG cannot be dropped as it has running Processes. You must first abort all the running processes using the Oracle Workflow Monitor.
INFORMATIONALRPE-02071: Deployment has been aborted due to a previously reported critial error.
I used following steps to solve the issue:
Step1: Find the running processes:
SQL*Plus: Release 220.127.116.11.0 – Production on Tue Jul 1 10:46:10 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: owf_mgr@DWHD
Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
OWF_MGR> SELECT item_type, item_key, begin_date, end_date, activity_status
2 FROM wf_item_activity_statuses
3 WHERE activity_status’COMPLETE’
4 AND item_type = ‘PKG’;
Step 2: Remove the active process
2 WF_ENGINE.ABORTPROCESS(‘PKG’, ‘WB_IK_20080627_200542_108294′);
PL/SQL procedure successfully completed.
Step 3 Redeploy the process flow
From the logs: