RPE-02062: Itemtype cannot be dropped as it has a running process.

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 11.1.0.6.0 – Production on Tue Jul 1 10:46:10 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Enter user-name: owf_mgr@DWHD
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.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’;

ITEM_TYP···ITEM_KEY·································BEGIN_DAT··· END_DATE···ACTIVITY
—————————————————————————————-
PKG·········WB_IK_20080627_200542_108294···27-JUN-08·····················ACTIVE
PKG·········WB_IK_20080627_200542_108294···27-JUN-08····················· NOTIFIED

OWF_MGR>

Step 2: Remove the active process

OWF_MGR>
OWF_MGR> BEGIN
2 WF_ENGINE.ABORTPROCESS(‘PKG’, ‘WB_IK_20080627_200542_108294’);
3 END;
4 /

PL/SQL procedure successfully completed.

OWF_MGR> commit;

Commit complete.

OWF_MGR>

Step 3 Redeploy the process flow

From the logs:

PKG···Create······Success

7 thoughts on “RPE-02062: Itemtype cannot be dropped as it has a running process.”

  2. The Abortprocess doesn’t work. Query Result :ITEM_TYPE ITEM_KEY BEGIN_DATE END_DATE ACTIVITY_STATUS PPF_KPI WB_IK_2008611_81055_127667 17-jul-2008 01:40:59 PM ACTIVEPPF_KPI WB_IK_2008530_115848_114682 17-jul-2008 01:40:59 PM ACTIVEAbortprocess Result:ERROR at line 1:ORA-20002: 3124: Process ‘PF_KPI’ for item’PPF_KPI/WB_IK_2008530_115848_114682′ is not active.ORA-06512: at “OWF_MGR.WF_ENGINE”, line 3472ORA-06512: at line 1Any suggestions?

    Reply

  3. I face this problem quite often in owb 10.2.0.3..nt sure abt other versions…there are two resolutions…1.restart the DB where the owb repository is installed.2.Go to the ORA_HOME(in you local machine)/owb/rtp/sql folder.There are lot of sql s listed.run the sql s named list all process first and abort process sql second.These must be executed as owb_repository owner.3.The third solution is to right click on the Process flow name and change the physical and business name and redeploy it. There have been cases when none of the above have worked also..so please donot get frustrated when none of them work…better execute the mappings via sqlplus….

    Reply

  5. Thanks a lot man, you have solved one of the recurring problems i was facing. Previously, i used to rename the process flow and deploy them. but this is much better solution. It is working fine on 10.2.0.3 version of OWB. omair

    Reply

  6. Thanks a lot
    My Problem got resolved

    Please find the sql and run using user :owf_manager

    select item_type, item_key, begin_date, end_date, activity_status
    from wf_item_activity_statuses
    where activity_status’COMPLETE’

    After getting the ACTIVE SESSIONS

    Kill the same using

    BEGIN
    WF_ENGINE.ABORTPROCESS(‘MART’, ‘WB_IK_20101115_051205_32269244’);
    END;

    Regards
    Ajay Punjabi

    Reply

Leave a comment

About heremha