Skip to main content
  • EN

I would assume (dangerous in this case), that a Terminator would halt processing completely.

I have a workspace, that imports from a WFS. It errs because the provider made a breaking change by removing a column in the read dataset. This issues a rejected feature, which triggers a Terminator.

But even then, the postprocess action of my SQL writer is triggered.

Why does this happen ?

If a terminator is called, it indicates that the workspace has failed. And then triggering postprocessing is a dangerous action, as this usually requires the writing to have been completed without errors.

Is this not a bug ?

Using FME 2022.2.6 on FME Server/Flow.

Cheers

I think this depends on how the transformers are connected? Is the SQL writer only connected with the readers output? Sorry if this sounds dumb but just double checking.

I think this depends on how the transformers are connected? Is the SQL writer only connected with the readers output? Sorry if this sounds dumb but just double checking.

Yea, you’d want to hold off running any post processing until you’re sure that all API calls have successfully run.

Something like the following would achieve that:
 

 

I think this depends on how the transformers are connected? Is the SQL writer only connected with the readers output? Sorry if this sounds dumb but just double checking.

 

It’s not a question of transformers and connections.

It’s the advanced setting “SQL To Run After Write” on the MSSQL_SPATIAL writer.

I have no control on when and if this piece of code is executed. Which is the reason for my question.

I recently introduced a Terminator transformer to force the workspace to fail, and was suprised to see, that the post-process code was executed regardless.

I think this depends on how the transformers are connected? Is the SQL writer only connected with the readers output? Sorry if this sounds dumb but just double checking.

 

It’s not a question of transformers and connections.

It’s the advanced setting “SQL To Run After Write” on the MSSQL_SPATIAL writer.

I have no control on when and if this piece of code is executed. Which is the reason for my question.

I recently introduced a Terminator transformer to force the workspace to fail, and was suprised to see, that the post-process code was executed regardless.

Clear. I’m not sure if this is expected behaviour but I would think not.

Reply


Community Stats

30,351
Posts
115,342
Replies
38,082
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.