I know that it is intended for the SQL Executor to wait for the SQL result before moving on in a workspace, but in the case where I want to send a statement to refresh materialised views or trigger a function in Postgres, I only require it to wait 20 seconds or so to ensure there is no immediate error (like any missing dependent objects). Being deployed on FME Server, I do not want the workspace using up an engine for 2 hours while the database does it's thing. So an "Advanced" section with a tick box to tell it not to wait for the result, and an integer value for seconds to wait before moving on if a result is not returned in that time.
Open
SQL Executor not waiting for result
- dave_seamless
- toby_c
- rylanatsafe
- TandraAtSafe
- mkludas
- dgrisbeck
- maddiel
- rlundstrum
- hollyatsafe
- andreaatsafe
- siennaatsafe
- LizAtSafe
- fmelizard
- david_r
- nielsgerrits
- hkingsbury
- danilo_fme
- dustin
- jdh
- erik_jan
- lifalin2016
- sigtill
- warrendev
- vxn43
- thijsknapen
- jkr_wrk
- j.botterill
- oscard
- tomf
- runneals
- connecter
- dbaldacchino1
- larue
- nic_ran
- jelle
- geosander
- kennyo
- philippeb
- jackyd
- antoine
- datablue
- srg
- olivier
- matthieuv
- thdrg
- revesz
- mpsims
- richsnyder0
- gerhard
- mwiltshire
- travis
- ssiegl
- pi_hellz
- kcoats
- gtong_monash
- peps
- toin
- muni-me
- jesidas
- princebilliam
- brooks
- maltaesousa
- sybold
- ststag
- mapnut
- ponceta
- jnotter
- r5
- erooen
- tintin20
- andrew_r
- travg
- geolassi
- jvbmov
- pvaziri
- mikev
- marcoroose
- robert_punt
- simonl
- chickey
- simon11
- andre.utilit
- lennartm
- alexbiz
- wizdatawizard
- hok.automation
- tiler
- scarrabee
- mikerob
- marcandre
- jobrien77
- conterra_chrisc
- paulbader
- lucky
- lencer
- mondeveloper
- c.arruti
- ecthelion
- ekkischeffler
- mmccart
- hermann
- salvaleonrp
- geogaard
- dmerrick
- felipeverdu
- paalpedersen
- dxirgu
- marnickcle
- daniel.m.getz
- bubblebeb
- mhab
- michaelbreen
- ngstoke
- jakethepainter
- jeroen
- adrian_farrell
- fdw
- anari
- gboquin
- verdoodtdries
- giosp
- hannahwh05
- tschoppenhof
- frro
- ediaze
- geoportalcartog
- geoal
- mb_fdfa
- wicki
- johnmarcdechaud
- kyle_r
- afavaccio
- tbarker1986
- jmiddel
- tim.albert.vaa
- _fabian_
- janrykr
- phoeffler
- johanw
- schoekek
- jsexton
- mirkoholzmeier
- brettjohnston
- jtcannon15
- poly_jan
- pelbe3
- jorjon7314
- conterraclara
- msims
- georgbrb
- kevinwyckoff
- cyclonekrohn
- ggggggiel
- markatsafe
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.