OTN Discussion Forums : How do I resume a failed process flow? ...

Reply to this Thread

Search Forum

Back to Thread List

Replies: 7 - Pages: 1 - Last Post: Jan 8, 2008 8:52 AM Last Post By: Oleg2

neescudero

Posts: 4
Registered: 03/07/01

How do I resume a failed process flow?
Posted: Mar 29, 2004 3:14 PM

How do I re-start a process flow at the point where it fails?

I have a Process flow consisting of several mappings and executed a certain order. If let say my third mapping fails, how do I resume the process flow starting on the third mapping, skipping the first and second mappings since they they been successfully completed?

igor.machin@ora...

Posts: 1,136
Registered: 01/10/01

Re: How do I resume a failed process flow?
Posted: Mar 30, 2004 11:29 AM

in response to: neescudero

Norman,

At the moment there is no feature in the OWB process flow that will let you automatically restart the flow from where it was interrupted, because there is no state-machine incorporated in it (i.e. it does not register the various states the process flow is in during execution). The user would have to implement this separately by creating (for example) a state table and checking the status in the table before executing a mapping. I understand that this might not be very simple in some cases, but at the moment it is the only way.

Regards:
Igor

ajaykaushal@yah...

Posts: 3
Registered: 04/04/03

Re: How do I resume a failed process flow?
Posted: Apr 2, 2004 8:34 AM

in response to: igor.machin@ora...

Is this issue addressed in OWB Patch 9.2.0.4

I read README file for the patch and it mentions fixes and one of them is : "2969208 EDW_OWB9I: PLEASE RE-DESIGN PUBLIC_UTILS.SQL SCRIPT TO MAKE IT RE-RUNNABLE"

Does this mean the failed process flow can be restarted from the point of failure onwards?

TIA, Ajay

markrittman

Posts: 246
Registered: 10/12/00

Re: How do I resume a failed process flow?
Posted: Aug 25, 2004 1:06 PM

in response to: ajaykaushal@yah...

Hi, looking through metalink, I came across the following

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=187735.1

"Can a workflow process be restarted from the point of failure? "

Yes, Wf_Engine.HandleError is designed for this.
When the cause of the error has been corrected, the HandleError
procedure can be called with the 'RETRY' option which will attempt
to re-execute the specified activity.

Comments, anyone? Anyone have any idea how to use the Wf_Engine.HandleError procedure??

Mark

kensei

Posts: 33
Registered: 11/21/07

Re: How do I resume a failed process flow?
Posted: Jan 4, 2008 2:11 AM

in response to: markrittman

Mark, is there a function/procedure within owb(version 10.2) which I can call to acheive this?

Oleg2

Posts: 854
Registered: 07/02/98

Re: How do I resume a failed process flow?
Posted: Jan 8, 2008 1:27 AM

in response to: kensei

Hi kensei,

I use a special design of my processflows for recovering of failed process - execution of processflow suspended when error occurs in mappings/procedures. In this case I restart failed step from Workflow monitor (after fixing problem - modifying mapping/correcting data etc.).

For more details look this threads

http://forums.oracle.com/forums/thread.jspa?messageID=1738549&#1738549

http://forums.oracle.com/forums/message.jspa?messageID=2071250#2071250

Regards,
Oleg

kensei

Posts: 33
Registered: 11/21/07

Re: How do I resume a failed process flow?
Posted: Jan 8, 2008 8:23 AM

in response to: Oleg2

Hi Oleg

Thanks for your reply.

The process outlined in your other posts work fine, however, I would like to implement the WF_ENGINE.handleerror 'solution' as this is exactly what it is supposed to do...unfortunately, everytime I run this procedure I get the following error:

ORA-20019: The specified context attribute is invalid
ORA-06512: at "FDM_UAT19RR.WB_RTI_EXCEPTIONS", line 107
ORA-06512: at "FDM_UAT19RR.WB_RT_CONTEXT_ATTR", line 184
ORA-01403: no data found
ORA-06512: at "FDM_UAT19RR.WB_RTI_WORKFLOW_UTIL", line 285

Any ideas?

Regards

Oleg2

Posts: 854
Registered: 07/02/98

Re: How do I resume a failed process flow?
Posted: Jan 8, 2008 8:52 AM

in response to: kensei

kensei,
WF_ENGINE.handleerror works only for activity in active processes/subprocesses.
Expedite operation in Workflow monitor is implemented with HandleError, so this procedure is no more then another variant for restarting failed activity in processes (designed according my approach).
Interesting reading:
http://forums.oracle.com/forums/message.jspa?messageID=1861750#1861750
and
http://thoughts.workflowfaq.com/index.php?query=Jumping&amount=0&blogid=1

Regards,
Oleg

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)