Focal Point
[CLOSED] executing a part of process flow

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/2917042766

February 11, 2014, 03:39 PM
satish chennupati
[CLOSED] executing a part of process flow
Hi,

i have a process flow which contains multiple data flows. now assume i want to kick off the execution from the third data flow and dont want to execute the first two...

how can i do that ?

This message has been edited. Last edited by: <Kathryn Henning>,


Data Migrator 7.7
service manager 6.0, 6.1, 6.5 and 8
February 12, 2014, 02:22 AM
Dave
Satish,

I don't know exactly what you mean, but I think this is it.

-PROMPT &CHOOSE.Choose 1 2 or 3.;

-GOTO LABEL_&CHOOSE

-LABEL_1
TABLE FILE CAR
	SUM	SALES
	BY	COUNTRY
END
-GOTO LABEL_RTM


-LABEL_2
TABLE FILE CAR
	SUM	SALES
	BY	CAR
END
-GOTO LABEL_RTM


-LABEL_3
TABLE FILE CAR
	SUM	SALES
	BY	SEATS
END
-GOTO LABEL_RTM



-LABEL_RTM



_____________________
WF: 8.0.0.9 > going 8.2.0.5
February 12, 2014, 11:05 AM
Clif
From use of the term "Data Flow" we can tell that Satish is using DataMigrator. And mostly likely "Process Flow" too (and not the SM version).

It depends a bit on what you mean by "Kick off" as we distinguish between "Run" to initiate a flow in the same agent as the Data Management Console and "Submit" to submit it to the scheduler for subsequent execution. Also whether this is something you want to once or often.

To run the PF just once starting with the third data flow, delete the arrows from Start to the first to the second to the third. Drag a new arrow from Start to the third. And Run.

If you want to submit (or schedule) the flow you'll need to save it so probably want to do so with a new name. Indeed if you want to run the PF again that's the best option.

It would require a new feature request to able to simply do this from the DMC with context menu on the PF objects.


N/A
February 13, 2014, 06:59 AM
vengat Maran@Aspire Systems
If you want to remove execution of first two flows permanently then you can deactivate or remove it from the process flow.
or
you can decide the sub flows based on the flow document using control objects.


iWay Service Manager,
Windows.
February 25, 2014, 12:28 AM
satish chennupati
thank you guys for the replies...

@Clif
yes i am using DataMigrator.

i know these options but to be precise i might rephrase my question a bit...

for eg: i have a Process Flow, it has 5 data flows in it and i ran it, say the first two data flows are executed fine and the third data flow fails because of some 'xyz' issues now i dont want to run the first two data flows but my execution should starts from third data flow but for this i dont want to delete the connectors or the arrows. i want to know is there a way to bypass the execution of the first two data flows using custom condition in the connector/arrow.

i hope my question make sense


Data Migrator 7.7
service manager 6.0, 6.1, 6.5 and 8
February 25, 2014, 05:52 AM
Martin vK
You can add a (new) procedure to your process flow which contains the logic to determine which data flow to start with. This procedure can set an amper variable which you can use in a custom condition in your connector to decide which will be the data to execute next.

E.g. if you set in this procedure the variable &START_WITH_FLOW
Then in the process flow from this procedure there will be 5 outgoing connectors, each having a custom condition &START_WITH_FLOW EQ #

hope this works for you,
Martin.


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
February 25, 2014, 11:05 AM
Clif
I was about to reply and see that Martin proposed the same solution. My stored procedure contains the line
-DEFAULT &START_WITH_FLOW EQ=1
so that when you submit the flow you are prompted for a value.

I had aleady created such a flow so I'll just add the image:



N/A