Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    How to kill the Process Flow?
Go
New
Search
Notify
Tools
Reply
  
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, 2011Reply With QuoteReport 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, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.