I have a workspace that is reading a table via the MS SQL JDBC reader and writing the output to an Esri File Geodatabase feature class. It works in FME Form. However, In FME Flow, it fails after the following message (not a warning or error) and shows 0 warnings/errors in the log:
Writer `GEODATABASE_FILE_1' of type `GEODATABASE_FILE' using group definition keyword `GEODATABASE_FILE_1_DEF
If I read the same exact data in from a CSV file and write to the Esri File Geodatabase, it works in FME Flow. If I read from the MS SQL database and write to an Open API File Geodatabase, it also works. However, I need to use the Esri writer in production for updates due to some Esri-specific functionality. It seems that there is some sort of odd bug specifically when using the MS SQL JDBC reader and Esri File Geodatabase writer in FME Flow. Has anyone else run into this or have any suggestions?
Notes: I’ve tried with the SQLCreator, SQLExecutor, and a reader. It still worked in Form but not Flow. We have to use the JDBC reader due to advanced connection parameters (security). We are running FME Form/Flow 2025.1.1.