Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    How to kill the Process Flow?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to kill the Process Flow?
 Login/Join
 
Member
posted
Hi All,

I developed a dataflow with Source, Target and corresponding tranformations. My Source table contains around 1 million records. The flow is valid and when I ran the Process flow, it started fetching the records and loading it into target. It took more than 4 hours and it is still not completed. So, I cancelled the process flow.

Later, I noticed the table got loaded with some amount of records. But, I increased the commit size greater than source record count.

My question is, will the process flow run in the background?. If so, where to go and stop it?.

Help me in knowing it.

Thank You.

WebFocus 8.0.0.3
 
Posts: 28 | Registered: December 28, 2011Report This Post
Member
posted Hide Post
A couple of things:
1) to cancel go to console, then workspace then data services; right click and select agents. You should see your request running. Right click on it and seletc "kill this agent"
2) I suspect the reason your job is taking so long is that you are using "keyed update". If possible avoid that and use "insert from memory"
 
Posts: 1 | Registered: November 24, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    How to kill the Process Flow?

Copyright © 1996-2020 Information Builders