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

[Rick Sample]

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