Skip to main content
Question

Successful output after workbench runner prior to workbench completing writing into Oracle table

  • December 10, 2014
  • 9 replies
  • 6 views

ebygomm
Influencer
Forum|alt.badge.img+31
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?

 

 

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • December 10, 2014
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 )

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • December 10, 2014
http://twapi.magicsplat.com/process.html

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • December 10, 2014
Hi, have you set the "Wait for Job to Complete" parameter of the WorkspaceRunner to "Yes"?

 

Takashi

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • December 11, 2014
Wait will not help Takashi, the proces might be done, but the actual writing not.

 

It is a WKI (Well Known Issue ;) )

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • December 11, 2014
Really? I've never encountered such a situation concerning the WorkspaceRunner use.

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • December 12, 2014
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

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • December 12, 2014
hard to believe, but may be true since you say so...

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • December 16, 2014
believe is for the insecure..

ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • January 19, 2016

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings