Skip to main content

 

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.


@j.botterill could it be that because of it is an asset package? https://solutions.arcgis.com/utilities/help/utility-network-automation/asset-package-reference/an-overview-of-the-asset-package.htm


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