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

[Stoicof, Dan]

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