Hi all,
I'm working on a workflow using FME where I want to use the SQLExecutor transformer to query data from a File Geodatabase I've set the input to point directly to the FGDB file, and tried several SQL queries — even very simple ones like:

Hi all,
I'm working on a workflow using FME where I want to use the SQLExecutor transformer to query data from a File Geodatabase I've set the input to point directly to the FGDB file, and tried several SQL queries — even very simple ones like:
Hi jugoslavia, I assume the machine running FME Form currently has an ESRI license active? To use the File Geodb format you need an esri license.
Make sure the version of FME Form and your arcgis software align as per https://support.safe.com/hc/en-us/articles/25407724093837-Notes-on-FME-and-Esri-Versions-and-Compatibility
Error code -214767259 may be related to incorrect ODBC setup, permission issues, or unsupported data types. It can also arise from whitespace issues in file paths or data, or when a tool attempts to write to a read-only locatio
Hi jugoslavia, I assume the machine running FME Form currently has an ESRI license active? To use the File Geodb format you need an esri license.
Make sure the version of FME Form and your arcgis software align as per https://support.safe.com/hc/en-us/articles/25407724093837-Notes-on-FME-and-Esri-Versions-and-Compatibility
Error code -214767259 may be related to incorrect ODBC setup, permission issues, or unsupported data types. It can also arise from whitespace issues in file paths or data, or when a tool attempts to write to a read-only locatio
Hey, thank you very much for your answer.
I'm using ArcGIS Pro 3.3.5 and FME 2024.0, so according to the link you sent, it seems to be compatible.
I'm trying to query a table with or without geometry, but nothing is being returned. I'm using an SDE connection, and it does work otherwise.
Not sure, can you include your transaction log.
Search the change log https://fme.safe.com/changelog/?_change_log_product=FMEFORM&_change_log_version=2022000002%2C2025010000&_search=SDE
Consider using “FILE GEODATABASE Open API” format and test SQLexecutor
Otherwise escalate this and reach our to safe support https://support.safe.com/hc/en-us/p/Support
Here is the log
Creating reader for format: Esri Geodatabase (File Geodb)
Trying to find a DYNAMIC plugin for reader named `GEODATABASE_FILE'
Error executing SQL: ''. The error number from ArcObjects is: '-2147467259'
An error has occurred. Check the logfile above for details
Failed to read features from dataset 'D:\ProGIS_2_UN\03_Daten_pruefen\Project\NC_TEST\Output\Output_GAS_S5.gdb' using the 'GEODATABASE_FILE' reader
I do not have the FILE GEODATABASE Open API option in teh SQL Creator or only for Reader and Writer