There is one workbench file that only has a SQLCreator within it that executes some update queries in the database tables for Oracle DB.
This workbench was previously scheduled to run from FME server but we recently migrated our FME environment from FME Server (on-prem) to FME Flow 2023 (azure environment). We are seeing issues when this process is run from FME Flow , the SQL queries defined to be executed within the SQLCreator are not getting executed. However, when run from FME Form (2023) it is working fine.
Can you please confirm if there is a known issue with SQLCreator from FME Flow.
We have observed that when SQLCreator is replaced with Creator+SQLExecutor , the process seems to be working fine from both FME Form and FME Flow.
Hence need confirmation to proceed with the change