<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2658.24">
<TITLE>RE: Task status "Completed" but WF stuck due to Oracle issues.</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>At the risk of being obvious, here it goes: </FONT>
</P>
<P><FONT SIZE=2>Also check SM58 for failed RFC calls.</FONT>
</P>
<P><FONT SIZE=2>Cheers...</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: sap-wug-bounces@mit.edu [<A HREF="mailto:sap-wug-bounces@mit.edu">mailto:sap-wug-bounces@mit.edu</A>] On Behalf Of Paul.Bakker@osr.treasury.qld.gov.au</FONT>
<BR><FONT SIZE=2>Sent: Monday, September 12, 2005 2:52 PM</FONT>
<BR><FONT SIZE=2>To: SAP Workflow Users' Group</FONT>
<BR><FONT SIZE=2>Subject: RE: Task status "Completed" but WF stuck due to Oracle issues.</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi Rick,</FONT>
</P>
<P><FONT SIZE=2> Did you check ST22 for any shortdumps? These usually explain why a</FONT>
<BR><FONT SIZE=2>workflow stops dead without any obvious error.</FONT>
</P>
<P><FONT SIZE=2>cheers</FONT>
<BR><FONT SIZE=2>Paul</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2> </FONT></P>
<P><FONT SIZE=2> "Rick Sample" </FONT></P>
<P><FONT SIZE=2> <Rick.Sample@gbe. To: sap-wug@mit.edu </FONT></P>
<P><FONT SIZE=2> com> cc: </FONT></P>
<P><FONT SIZE=2> Sent by: Subject: RE: Task status "Completed" but WF stuck due to Oracle issues. </FONT></P>
<P><FONT SIZE=2> sap-wug-bounces@m </FONT></P>
<P><FONT SIZE=2> it.edu </FONT></P>
<P><FONT SIZE=2> </FONT></P>
<P><FONT SIZE=2> </FONT></P>
<P><FONT SIZE=2> 13/09/2005 07:36 </FONT></P>
<P><FONT SIZE=2> Please respond to </FONT></P>
<P><FONT SIZE=2> "SAP Workflow </FONT></P>
<P><FONT SIZE=2> Users' Group" </FONT></P>
<P><FONT SIZE=2> </FONT></P>
<P><FONT SIZE=2> </FONT></P>
<BR>
<BR>
<BR>
<P><FONT SIZE=2>Yep. Can do anything with them but logically delete. Can't force to</FONT>
<BR><FONT SIZE=2>error, change agent, ...</FONT>
</P>
<P><FONT SIZE=2>When you get the OSS resolved I would appreciate a *ping*!</FONT>
</P>
<P><FONT SIZE=2>Thanks</FONT>
<BR><FONT SIZE=2>Rick</FONT>
</P>
<P><FONT SIZE=2>4.6c</FONT>
</P>
<P><FONT SIZE=2>>>> dan.stoicof@gwl.com 9/12/2005 16:26 >>></FONT>
<BR><FONT SIZE=2>I have exactly the same situation right now. We just upgraded to 4.7</FONT>
<BR><FONT SIZE=2>and for the first week I got about 3 dozen suspended workflows. All I</FONT>
<BR><FONT SIZE=2>know is that you can find them all using SWPC, but they won't restart</FONT>
<BR><FONT SIZE=2>with that transaction. I was able to restart some of them after placing</FONT>
<BR><FONT SIZE=2>the workflow in error and restarting with SWPR, but some workflows then</FONT>
<BR><FONT SIZE=2>could just not restart! There is an issue OSS acknowledged (I'm working</FONT>
<BR><FONT SIZE=2>with them right now) when restarting workflows that use subworkflows . .</FONT>
<BR><FONT SIZE=2>.</FONT>
<BR><FONT SIZE=2>Just my $0.02 . . .</FONT>
</P>
<P><FONT SIZE=2>Dan Stoicof</FONT>
<BR><FONT SIZE=2>SAP Workflow/ABAP Team</FONT>
<BR><FONT SIZE=2>GREAT-WEST LIFE and ANNUITY</FONT>
<BR><FONT SIZE=2>8515 E. Orchard Rd</FONT>
<BR><FONT SIZE=2>Greenwood Village, CO. 80111</FONT>
<BR><FONT SIZE=2>dan.stoicof@gwl.com</FONT>
<BR><FONT SIZE=2>(303)737-2242</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: sap-wug-bounces@mit.edu [<A HREF="mailto:sap-wug-bounces@mit.edu">mailto:sap-wug-bounces@mit.edu</A>]On</FONT>
<BR><FONT SIZE=2>Behalf</FONT>
<BR><FONT SIZE=2>Of Rick Sample</FONT>
<BR><FONT SIZE=2>Sent: Monday, September 12, 2005 3:14 PM</FONT>
<BR><FONT SIZE=2>To: sap-wug@mit.edu</FONT>
<BR><FONT SIZE=2>Subject: Re: Task status "Completed" but WF stuck due to Oracle</FONT>
<BR><FONT SIZE=2>issues.</FONT>
</P>
<BR>
<P><FONT SIZE=2>Yes. Everything "looks" normal.</FONT>
<BR><FONT SIZE=2>Task shows completed but WF is stuck inprocess with no other tasks to</FONT>
<BR><FONT SIZE=2>be performed. i.e.</FONT>
<BR><FONT SIZE=2>Tasks 1 completed, should have gone to Task 2. Just got stuck trying</FONT>
<BR><FONT SIZE=2>to</FONT>
<BR><FONT SIZE=2>complete Task 1.</FONT>
<BR><FONT SIZE=2>These WFs are dead in the water. No task to execute and no way to</FONT>
<BR><FONT SIZE=2>restart. (Not by any tools I know of anyway)</FONT>
</P>
<P><FONT SIZE=2>In SWWIHEAD, I found that WI_STAT = 'COMPLETED' and CB_DONE is not</FONT>
<BR><FONT SIZE=2>'X'.</FONT>
</P>
<P><FONT SIZE=2>After looking at WFs that were not effected it does not appear that</FONT>
<BR><FONT SIZE=2>this should be</FONT>
<BR><FONT SIZE=2>the status of this flag when completed.</FONT>
</P>
<P><FONT SIZE=2>It would be a good thing to be able to recover from this Call Back not</FONT>
<BR><FONT SIZE=2>completing.</FONT>
<BR><FONT SIZE=2>Still looking at SAP FMs...</FONT>
</P>
<P><FONT SIZE=2>Thanks!</FONT>
</P>
<BR>
<P><FONT SIZE=2>>>> wug.replies@workflowconnections.com 9/12/2005 15:43:29 >>></FONT>
<BR><FONT SIZE=2>Hi Rick,</FONT>
<BR><FONT SIZE=2>Que? I read your post a few times: Users completed some tasks and now</FONT>
<BR><FONT SIZE=2>the tasks show as completed and have no errors and you cannot restart</FONT>
<BR><FONT SIZE=2>them..?!??</FONT>
</P>
<P><FONT SIZE=2>At the risk of stating the obvious, this sounds perfectly normal.</FONT>
</P>
<P><FONT SIZE=2>Cheers</FONT>
<BR><FONT SIZE=2>Mike</FONT>
</P>
<P><FONT SIZE=2>Rick Sample wrote:</FONT>
<BR><FONT SIZE=2>> We had Oracle issues this morning that apparently cause WF some</FONT>
<BR><FONT SIZE=2>issues.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> I have some tasks that were Completed by users. Shows completed in</FONT>
<BR><FONT SIZE=2>WF</FONT>
<BR><FONT SIZE=2>> log and</FONT>
<BR><FONT SIZE=2>> no errors. But no agent and apparently nothing I can do to re-start.</FONT>
<BR><FONT SIZE=2>> Since no errors</FONT>
<BR><FONT SIZE=2>> am I basically dead in the water or is there something I can do to</FONT>
<BR><FONT SIZE=2>kick</FONT>
<BR><FONT SIZE=2>> start them again?</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> Rick</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> SAP-WUG mailing list</FONT>
<BR><FONT SIZE=2>> SAP-WUG@mit.edu</FONT>
<BR><FONT SIZE=2>> <A HREF="http://mailman.mit.edu/mailman/listinfo/sap-wug" TARGET="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</A></FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>SAP-WUG mailing list</FONT>
<BR><FONT SIZE=2>SAP-WUG@mit.edu</FONT>
<BR><FONT SIZE=2><A HREF="http://mailman.mit.edu/mailman/listinfo/sap-wug" TARGET="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>SAP-WUG mailing list</FONT>
<BR><FONT SIZE=2>SAP-WUG@mit.edu</FONT>
<BR><FONT SIZE=2><A HREF="http://mailman.mit.edu/mailman/listinfo/sap-wug" TARGET="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</A></FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>SAP-WUG mailing list</FONT>
<BR><FONT SIZE=2>SAP-WUG@mit.edu</FONT>
<BR><FONT SIZE=2><A HREF="http://mailman.mit.edu/mailman/listinfo/sap-wug" TARGET="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>SAP-WUG mailing list</FONT>
<BR><FONT SIZE=2>SAP-WUG@mit.edu</FONT>
<BR><FONT SIZE=2><A HREF="http://mailman.mit.edu/mailman/listinfo/sap-wug" TARGET="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</A></FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>SAP-WUG mailing list</FONT>
<BR><FONT SIZE=2>SAP-WUG@mit.edu</FONT>
<BR><FONT SIZE=2><A HREF="http://mailman.mit.edu/mailman/listinfo/sap-wug" TARGET="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</A></FONT>
</P>
</BODY>
</HTML>