<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.69">
<TITLE>Re: Race to the Finish Line</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText82813 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have found some peculiar behaviour
in transaction SWPC and wanted to share it with the group to see if anyone else
had experienced this. <?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We had a system crash in Production
last week which had caused many workflows to ‘hang’. We have been using
transaction SWPC (Restart Workflow after system crash) to restart the ‘hung’
Workflows but SWPC has almost crashed our system again! <o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Our workflows are mostly hung up on
a wait step (which is a background step). Using transaction SWPC I noticed that
the workflow is restarted under the User ID of the user running SWPC. This is
fair enough as it maintains the audit trial in the WF log as to who restarted
the workflow. <o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">But here is the unfortunate part.
<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">If I have a 10 step workflow all of
which are background. The SWPC transaction will execute all of them under my
user ID and enqueue every work item. The result is for every workflow I restart
I get 10 entries in the enqueue table. <SPAN
style="mso-spacerun: yes"> </SPAN>If I have a few hundred workflows to
restart, I very quickly fill up the NQ table and an overflow occurs. Not good.
The only time the enqueue locks are released is if I back out of the
transaction. IMHO, this should be changed so that the NQ locks are released once
the workflow has restarted.</SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">This brings me to the next
point:<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am sure this problem is happening
because the <I style="mso-bidi-font-style: normal">advance with dialog</I> flag
is still set on each step and therefore all 10 steps are being executed
synchronously. I am curious to hear what you guys do? Do you uncheck the <I
style="mso-bidi-font-style: normal">advance with dialog </I>flag at the Workflow
level (even for background workflows) or are most people like me (lazy) and tend
to forget to switch it off?</SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN> </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">BTW, I logged this with
OSS.</SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Alon<o:p></o:p></SPAN></P></FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV></DIV>
</BODY>
</HTML>