AW: How to restart lots of workflows in 'STARTED' status -PROBLEM SOLVED !
Ross.Cresdee@iag.com.au
Ross.Cresdee at iag.com.au
Sun Feb 6 20:42:59 EST 2005
**************************************************************************
Note: This e-mail is subject to the disclaimer contained at the bottom
of this message.
**************************************************************************
:
Hi Nathan,
We were under pressure to resolve this problem quickly as it was holding up
payroll so resorted to SQL at a database level rather than writing ABAP
code. We had our basis people open the system briefly while we made the
changes. This is a risky practice and one that I wouldn't recommend. It
was only performed because of the time critical nature of the problem - we
were conscious of the risks and worked quickly to ensure the system wasn't
kept open for long. With more time, we would have used the ABAP route.
Regards, Ross.
Workflow
<nathanfox at swissi To: "SAP Workflow Users' Group" <sap-wug at mit.edu>
nfo.org> cc:
Sent by: Subject: AW: How to restart lots of workflows in 'STARTED' status -
sap-wug-bounces at m PROBLEM SOLVED !
it.edu
04/02/2005 07:08
PM
Please respond to
"SAP Workflow
Users' Group"
Hi Ross
You said in point 1. "Using SQL we reset all the workflows' child task
status in SWWWIHEAD to ERROR'". Could you explain this approach "Using
SQL". Are you updating via ABAP Open SQL or using Native SQL directly on
the data base level.
thanks for the info
Nathan
-----Ursprungliche Nachricht-----
Von: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu]Im Auftrag
von Ross.Cresdee at iag.com.au
Gesendet: Freitag, 4. Februar 2005 06:57
An: SAP Workflow Users' Group
Betreff: Re: How to restart lots of workflows in 'STARTED' status -
PROBLEM SOLVED !
**************************************************************************
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