Delete Worflow Instances: SWW_WI_DELETE or SWWL

[Logiest, Thierry T SI-SPOS-SPOS]

Raul, just one thing, for reporting purposes try not to just delete the =
task but also the workflow to which the task belongs to. I am not sure =
what this function will do but it's worth checking.
 
KR, Thierry
 
-----Original Message-----
From: Rivera, Raul [mailto:Raul.Rivera at absu.accenture.com]
Sent: 16 June 2004 01:52
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Delete Worflow Instances: SWW_WI_DELETE or SWWL
 
 
Thanks Jocelyn and Thierry for your inputs. We are now able to mass =
complete
work items that were hanging.
 
Aside from this, we have thousands of hanging workflow instances that we
need to delete. Because I am planning to delete them programmatically, I =
am
planning on using SWW_WI_DELETE in the program instead of transaction =
SWWL.
 
Any thoughts on this will be appreciated.
 
Thanks,
Raul
4.6C
 
-----Original Message-----
From: SAP Workflow [mailto:Owner-SAP-WUG at MITVMA.MIT.EDU] On Behalf Of
Logiest, Thierry T SI-SPOS-SPOS
Sent: Tuesday, June 15, 2004 1:34 AM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Re: Mass Job to Manually Complete Work Items
 
Raul,
 
We had the same problem, if you download the workitems that need =
processing
and upload them into this little report (provided  you also select the
correct options i.e. from status must be "waiting", to status must be
"ready") then all your problems should be quickly resolved. =
Alternatively
you can enhance the report to do that automatically.
 
Report YGLSPTWF021.
 
 
DATA: WI_STAT_itab like SWWWIHEAD-WI_STAT occurs 0 with header line.
 
tables : swwwihead.
 
data : id_value like swwwihead-wi_id.
 
********************************************************************
* Select-OPtion                                        *
********************************************************************
 
 
SELECTION-SCREEN BEGIN OF BLOCK 1 WITH FRAME TITLE text-t04.
SELECT-OPTIONS:
    id FOR swwwihead-wi_id.
 
parameters : To_Stat like SWWWIHEAD-WI_STAT,
             Fr_Stat like SWWWIHEAD-WI_STAT.
 
SELECTION-SCREEN END OF BLOCK 1.
 
 
 
loop at id.
 
clear id_value.
move id-low to id_value.
 
SELECT WI_STAT FROM SWWWIHEAD into WI_STAT_itab
       WHERE  WI_ID  =3D id_value.
ENDSELECT.
 
if WI_STAT_itab <> Fr_Stat.
continue.
endif.
 
 
CALL FUNCTION 'SWW_WI_STATUS_CHANGE_NEW'
  EXPORTING
    STATUS                            =3D To_Stat
    WI_ID                             =3D id_value
*   DO_COMMIT                         =3D 'X'
*   DEBUG_FLAG                        =3D ' '
*   CALLED_IN_BACKGROUND              =3D ' '
*   NO_CALLBACK_ON_COMPLETION         =3D ' '
*   WI_EXECUTION_TYPE                 =3D ' '
* IMPORTING
*   RETURN                            =3D
*   WI_RESULT                         =3D
* TABLES
*   WI_CONTAINER                      =3D
* EXCEPTIONS
*   INFEASIBLE_STATE_TRANSITION       =3D 1
*   NOTIFICATION_FAILED               =3D 2
*   STATUS_UNKNOWN                    =3D 3
*   UPDATE_FAILED                     =3D 4
*   OTHERS                            =3D 5
          .
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
 
 
endloop.
 
Kind Regards / Vriendelijke groeten ,
 
Thierry Logiest
SPOS Global Workflow Consultant
SAP Workflow/HR/ABAP Certified Senior Consultant
Shell Information Technology International B.V.
Postbus  162, 2501 CR Den Haag, Nederland
 
Tel 1 : +31 70 377 5484
Tel 2 : +31 70 303 4102
Email: thierry.logiest at shell.com
Internet: http://www.shell.com
 
-----Original Message-----
From: Rivera, Raul [mailto:Raul.Rivera at absu.accenture.com]
Sent: 14 June 2004 22:20
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Mass Job to Manually Complete Work Items
 
 
Hello everyone,
 
We recently had an issue with job SWWDHEX (deadline monitoring) that
resulted in background work items with monitored deadlines to 'hang' =
(i.e.
the work item is still in 'Waiting status even after the deadline was
reached).
 
The issue was resolved by applying an SAP note 736113 on our 4.6c =
system.
 
We now have to find an automated way to complete manually work items =
that
hanged prior to note application (there are thousands of them). Does =
anyone
know a way to mass complete these work items?
 
Thanks everyone,
 
Raul Rivera
raul.rivera at absu.accenture.com