How to restart lots of workflows in 'STARTED' status - PROBLEMSOLVED !
Ross.Cresdee@iag.com.au
Ross.Cresdee at iag.com.au
Sun Feb 6 18:03:08 EST 2005
**************************************************************************
Note: This e-mail is subject to the disclaimer contained at the bottom
of this message.
**************************************************************************
:
Hi Mike,
We were under the thumb to get this problem fixed before running a payroll
so resorted to SQL rather than writing code, but I take your point that
it's not recommended.
We tried SWPR but it would not pickup our workflows with errors in child
workflow steps - the main SWPR select statement has condition "wi_chckwi
= no_id" where no_id = '00000000', that is, it will only pickup highest
level workflows and not restart child workflows. We couldn't restart full
workflows as it would double up some actions that had been completed before
hanging. That's why we used the function directly.
Thanks for you interest.
Regards, Ross.
Michael Pokraka
<workflow at quirky. To: "SAP Workflow Users' Group" <sap-wug at mit.edu>
me.uk> cc:
Sent by: Subject: Re: How to restart lots of workflows in 'STARTED' status -
sap-wug-bounces at m PROBLEM SOLVED !
it.edu
04/02/2005 08:17
PM
Please respond to
"SAP Workflow
Users' Group"
Hi Ross,
Good to hear that you got your problem resolved, but expect a grilling from
Jocelyn about your use of SQL :-)
The 4.6 equivalent to SAP_WAPI_SET_ERROR is SWW_WI_STATUS_CHANGE_NEW. Not
for
us plebs to use either, but much preferred over SQL. Then for parts 2 and 3
(I'd forgotten about this one in my earlier reply), there's SWPR to do the
whole shebang in one go.
Cheers
Mike
--- Ross.Cresdee at iag.com.au wrote:
>
>
**************************************************************************
>
> Note: This e-mail is subject to the disclaimer contained at the bottom
> of this message.
>
>
**************************************************************************
> :
>
> Hi All,
>
> Thanks to all those who suggested remedies to our problem of hanging
> workflows in 'STARTED' status. I neglected to mention that we are
running
> SAP 46B which meant some of the newer workflow utilities weren't
available.
>
> We actually used a hybrid of the suggested solutions to resolve our
problem
> :
>
> 1. Using SQL we reset all the workflows' child task status in SWWWIHEAD
> created over a certain date range that were hanging in WAITING status to
> 'ERROR' status.
>
> 2. Selected all workflow id's (WI_ID) in ERROR for that day into an
> internal table
>
> 3. Looped through this table applying function SWW_WI_ADMIN_ERROR_RESTART
> to all the WI_ID.
>
> The result was very pleasing with over 1000 workflows restarted cleanly
and
> in quick time. It was all done in a bit of a rush so we're going to
review
> the suggestions again to ensure we're better prepared for next time (if
> ever) !
>
> Thanks again. Much appreciated.
>
> Ross.
>
>
>
>
>
> Ross
>
> Cresdee/NSW/NRMA@ To: sap-wug at mit.edu
>
> NRMA cc:
>
> Sent by: Subject: How to restart
lots
> of workflows in 'STARTED' status
> sap-wug-bounces at m
>
> it.edu
>
>
>
>
>
> 03/02/2005 05:03
>
> PM
>
> Please respond to
>
> "SAP Workflow
>
> Users' Group"
>
>
>
>
>
>
>
>
>
>
**************************************************************************
>
> Note: This e-mail is subject to the disclaimer contained at the bottom
> of this message.
>
>
**************************************************************************
> :
> Hi People,
>
> I hope you can give me a few clues. We've got a situation where hundreds
> of workflows have been in 'STARTED' status for over a week. The
workflows
> had reached a task that paused for 10 seconds and there they waited. Our
> deadline monitoring job was not running while these hanging workflows
> accumulated but the workflows did not take off once the job was
restarted.
> We've noted that we can force each workflow to manually complete but we
> don't want to have to do this for hundreds of workflows one at a time.
>
> Is there a way of restarting all these workflow that are in status
> 'STARTED' but are waiting for a time in the past ?
>
> Thanks for any assistance.
>
> Regards, Ross.
>
>
>
> :
>
********************************************************************************
>
> The information transmitted in this message and attachments (if any)
> is intended only for the person or entity to which it is addressed.
> The message may contain confidential and/or privileged material.
> Any review, retransmission, dissemination or other use of, or taking
> of any action in reliance upon this information, by persons or entities
> other than the intended recipient is prohibited.
>
> If you have received this in error, please contact the sender and delete
> this
> e-mail and associated material from any computer.
>
> The intended recipient of this e-mail may only use, reproduce, disclose
or
> distribute the information contained in this e-mail and any attached
files,
> with the permission of the sender.
>
> This message has been scanned for viruses and cleared by MailMarshal.
>
> ********************************************************************
> :
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
>
>
>
> :
>
********************************************************************************
>
> The information transmitted in this message and attachments (if any)
> is intended only for the person or entity to which it is addressed.
> The message may contain confidential and/or privileged material.
> Any review, retransmission, dissemination or other use of, or taking
> of any action in reliance upon this information, by persons or entities
> other than the intended recipient is prohibited.
>
> If you have received this in error, please contact the sender and delete
this
> e-mail and associated material from any computer.
>
> The intended recipient of this e-mail may only use, reproduce, disclose
or
> distribute the information contained in this e-mail and any attached
files,
> with the permission of the sender.
>
> This message has been scanned for viruses and cleared by MailMarshal.
>
> ********************************************************************
> :
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug
:
********************************************************************************
The information transmitted in this message and attachments (if any)
is intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon this information, by persons or entities
other than the intended recipient is prohibited.
If you have received this in error, please contact the sender and delete this
e-mail and associated material from any computer.
The intended recipient of this e-mail may only use, reproduce, disclose or
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.
This message has been scanned for viruses and cleared by MailMarshal.
********************************************************************
:
More information about the SAP-WUG
mailing list