Skip to main content
  • EN
I’m using a workbench runner to write data into an oracle table, after the workbench runner I have a FeatureHolder so that in theory the subsequent part of the workbench is not run until the oracle table is populated with all results.

 

 

 

The second part of the workbench uses an sqlexecutor to query this table, however what is happening is that this query takes place before all features have been written into the Oracle table. I currently have put a decelerator in to wait 5 minutes which corrects the problem but probably makes the workbench about 5 times as long as it needs to be. Is there any way of testing whether records are not still being written to the oracle table?

 

 
that's a longstanding problem..lot's of posts on this issue.

 

 

Maybe yu can use tcl TWAPI 4.0.61 to check processes? using a tclcaller as a "waiter"?

 

Waiter is a cusotm transformer in wich u set a loop to only stop when a condition is met. (like the one used for waitong for variablesetter, see earlier post )
http://twapi.magicsplat.com/process.html
Hi, have you set the "Wait for Job to Complete" parameter of the WorkspaceRunner to "Yes"?

 

Takashi
Wait will not help Takashi, the proces might be done, but the actual writing not.

 

It is a WKI (Well Known Issue 😉 )
Really? I've never encountered such a situation concerning the WorkspaceRunner use.
I have had some where the workspaceprocessing is finished and for instance the Excellwriter is still busy writing.

 

Some writers are faster, i admit..maybe it's
hard to believe, but may be true since you say so...
believe is for the insecure..

Don't you love it when you search for an answer to a problem and find the exact same question you posted a year ago! :-)

Reply


Community Stats

30,110
Posts
114,302
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.