Skip to main content
Solved

Sql Executor and Workspace runner

  • May 25, 2013
  • 1 reply
  • 6 views
R
Hi,

 

I got a translation going on with few sql executors and a workspacerunner .A sql executor is placed after Workspace runner as well.Now a strange thing is observed when I set the "wait for job to complete" as yes the oracle procedures are called from executors and are reflected in the table.

 

But when set to no ,none of the procedures seem to work though the log shows them being called .

 

Is this a bug ?

Best answer by takashi

Hi Roy,

 

 

When setting 'No' to the parameter, the SQL sentence(s) of the following SQLExecutor could be executed before comleting job of the workspace called by the WorkspaceRunner. So, if the table is the target which should be created or updated in the called worksapce, the SQLExcecutor will fail or generate unpreferable result. I guess this is such a situation.

 

Takashi
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • May 26, 2013
Hi Roy,

 

 

When setting 'No' to the parameter, the SQL sentence(s) of the following SQLExecutor could be executed before comleting job of the workspace called by the WorkspaceRunner. So, if the table is the target which should be created or updated in the called worksapce, the SQLExcecutor will fail or generate unpreferable result. I guess this is such a situation.

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.