Skip to main content

Hello,

 

I am trying to connect to our Enterprise Geodatabase. This used to work for quite a long time using FME 32 bit (several older FME versions). Using FME 64 bit (on the same machine) produced an error like this:

Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {Keine No SDEHOME-Umgebungsvariable festgelegt}

Please ensure the connection parameters are correct (server=`sde', instance=`....', user=`....', password=`***', database=`', version=`SDE.DEFAULT')

 

Now we have FME 2020.2 64 bit and I don't have the 32 bit version anymore.

I created a database connection file (*.sde) using ArcCatalog on my machine. There, I can see the database and connect to it. I can also open the connection in ArcCatalog directly using my sde file. But I can't use the same connection file to connect a reader (Format: Esri Geodatabase (ArcSDE Geodb Raster Dataset)) in FME. Three colleagues did this (same network, same database, same software, same connection file) and it worked for them.

 

Since it claims it wants a SDEHOME environment variable (that's what the german part of the above message says), and even though my colleagues do not have this environment variable, I created one and pointed it to C:\\Program Files (x86)\\ArcGIS\\Desktop10.6\\bin (I also tried the path without the bin part). Didn't work, but new error message:

Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Zur Datenbank kann nicht verbunden werden, da das Laden der Datenbank-Clientsoftware fehlgeschlagen ist. Stellen Sie sicher, dass die Datenbank-Clientsoftware richtig installiert und konfiguriert ist.}Please ensure the connection parameters are correct (server=`sde', instance=`...', user=`...', password=`***', database=`', version=`SDE.DEFAULT')

(My translation: Can not connect to database, because loading the database client software failed. Make sure you installed and configured the database client software.)

 

I do not think that this is a bug, since it works for my colleagues, but I ran out of ideas where to look for differences in our setup. So any help will be greatly appreciated.

 

Kind regards

Norbert

If I'm correct, using FME Desktop, you need to have ArcMap/ArcGIS Desktop or ArcGIS Pro installed and licensed to make it work.

 

If you have ArcMap/ArcGIS Desktop installed, you also need to install Background Geoprocessing to bridge the 32-bit (arcmap) vs 64-bit (fme) difference. You can download this from https://my.esri.com. You need to reinstall this every time you change the installation of ArcMap/ArcGIS Desktop

 

If you have ArcGIS Pro installed, you also need to be logged in to ensure you have a license.


Hi,

 

thank you for your quick reply. According to our IT guys, the background geoprocessing tool is being automatically installed. I did not find a way to verify this. However, we found that the Oracle Client 64bit was for some reason not (properly) installed on my machine. So ArcCatalog, being 32bit, was able to connect but FME wasn't.

 

After installing this Oracle Client, I can now connect to the database using the ArcSDE GeoDB Raster Dataset reader.

 

Thanks again

Norbert


(Feels strange to select one's own answer as "best", but in fact this solved the problem.)


Reply