Task status "Completed" but WF stuck due to Oracle issues.

[Mike Pokraka]

Hi Rick,
Have you checked the system log SM21? Might give you some clues, though 
it sounds pretty obvious what the likely problem was - it ran out of 
space (tablespace, extents, disk space...). If Basis umm and ahhh and 
try to avoid giving you an explanation then I guess you know whose fault 
it was...

I've had to recreate workflows once or twice: Cancel the flow and start 
from scratch: SWUE, then fiddle the containers as you go along to redo 
what's been happening. Or talk nicely to affected users and ask them to 
repeat the last step.

Sorry I can't be of more help,
Cheers
Mike

Rick Sample wrote:
> Dan and all others who responded,
> 
> - This all happened in a small window of about 10 minutes. 
> - Can't restart anyone of the stuck WFs via any normal Admin tool.
> SWPC, SWID, etc.
> - I don't' think it is just an Oracle thing, just something happened
> where it could not write to tables. 
> - No logs in ST22. (Could not write to table.) 
> 
> We got a list of WFs in that time window that are stuck. 
> Found a FM called SWP_WORKITEM_CALLBACK_REPEAT. Works on some, but not
> all. 
> Anyone have a pointer as to what to look for to explain why?
> 
> Rick
> 
> 
> 
> 
> 
> 
>>>>dan.stoicof at gwl.com 9/12/2005 16:43 >>>
> 
> No, you can place them in error.  I found that "simple" workflows
> (without subworkflows) can be restarted after error and they continue
> just fine.  Just workflows with subworkflows cannot be restarted (there
> are some notes out there but they did not work for me so OSS is looking
> into this right now).
> 
> Dan Stoicof
> SAP Workflow/ABAP Team
> GREAT-WEST LIFE and ANNUITY
> 8515 E. Orchard Rd
> Greenwood Village, CO. 80111
> dan.stoicof at gwl.com 
> (303)737-2242
> 
> 
> -----Original Message-----
> From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu]On
> Behalf
> Of Rick Sample
> Sent: Monday, September 12, 2005 3:36 PM
> To: sap-wug at mit.edu 
> Subject: RE: Task status "Completed" but WF stuck due to Oracle
> issues.
> 
> 
> Yep. Can do anything with them but logically delete. Can't force to
> error, change agent, ...
> 
> When you get the OSS resolved I would appreciate a *ping*!
> 
> Thanks
> Rick
> 
> 4.6c
> 
> 
>>>>dan.stoicof at gwl.com 9/12/2005 16:26 >>>
> 
> I have exactly the same situation right now.  We just upgraded to 4.7
> and for the first week I got about 3 dozen suspended workflows.  All I
> know is that you can find them all using SWPC, but they won't restart
> with that transaction.  I was able to restart some of them after
> placing
> the workflow in error and restarting with SWPR, but some workflows
> then
> could just not restart!  There is an issue OSS acknowledged (I'm
> working
> with them right now) when restarting workflows that use subworkflows .
> .
> . 
> Just my $0.02 . . . 
> 
> Dan Stoicof
> SAP Workflow/ABAP Team
> GREAT-WEST LIFE and ANNUITY
> 8515 E. Orchard Rd
> Greenwood Village, CO. 80111
> dan.stoicof at gwl.com 
> (303)737-2242
> 
> 
> 
> -----Original Message-----
> From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu]On 
> Behalf
> Of Rick Sample
> Sent: Monday, September 12, 2005 3:14 PM
> To: sap-wug at mit.edu 
> Subject: Re: Task status "Completed" but WF stuck due to Oracle
> issues.
> 
> 
> Yes. Everything "looks" normal. 
> Task shows completed but WF is stuck inprocess with no other tasks to
> be performed. i.e. 
> Tasks 1 completed, should have gone to Task 2. Just got stuck trying
> to
> complete Task 1. 
> These WFs are dead in the water. No task to execute and no way to
> restart. (Not by any tools I know of anyway)
> 
> In SWWIHEAD, I found that WI_STAT = 'COMPLETED' and CB_DONE is not
> 'X'.
> 
> After looking at WFs that were not effected it does not appear that
> this should be 
> the status of this flag when completed.
> 
> It would be a good thing to be able to recover from this Call Back not
> completing. 
> Still looking at SAP FMs...
> 
> Thanks!
> 
> 
> 
>>>>wug.replies at workflowconnections.com 9/12/2005 15:43:29 >>>
> 
> Hi Rick,
> Que? I read your post a few times: Users completed some tasks and now 
> the tasks show as completed and have no errors and you cannot restart 
> them..?!??
> 
> At the risk of stating the obvious, this sounds perfectly normal.
> 
> Cheers
> Mike
> 
> Rick Sample wrote:
> 
>>We had Oracle issues this morning that apparently cause WF some
> 
> issues.
> 
>>
>>I have some tasks that were Completed by users. Shows completed in
> 
> WF
> 
>>log and 
>>no errors. But no agent and apparently nothing I can do to re-start.
>>Since no errors 
>>am I basically dead in the water or is there something I can do to
> 
> kick
> 
>>start them again?
>>
>>Rick
>>
>>_______________________________________________
>>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 
> 
> 
> _______________________________________________
> 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 
> 
> 
> _______________________________________________
> 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 
> 
> 
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug