Solved

FME Flow not able to Read the ESRI Enterprise Geodatabase

  • 19 March 2024
  • 2 replies
  • 83 views

Badge +6

Hi Community,

 

I am working on developing a workbench which is basically reading Data from ESRI Enterprise Database and Writing to another DB. I am using ArcGIS Pro Version 3, FME Desktop Version 2022 and FME Flow Version 2023. I am able to connect and read data using FME Desktop But the published workspace while reading the data it is showing error “

779 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb)
780 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE'
781 2024-3-19 11:07:16 | Performing query against GEODATABASE_SDE dataset `'
782 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb)
783 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE'
784 2024-3-19 11:07:16 | Opening the Esri Geodatabase reader
785 2024-3-19 11:07:16 | An ArcGIS license is already checked out. The product checked out is 'Advanced'
786 2024-3-19 11:07:16 | Installed ArcGIS version is '3.0'
787 2024-3-19 11:07:16 | Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220952'. The error message from ArcObjects is: {The Product License has not been initialized.}
788 2024-3-19 11:07:16 | Please ensure the connection parameters are correct (server=`sde', instance=`sde:oracle$sde:oracle11g:ODA_STG_UPDATES', user=`OLTP_SOI', password=`***', database=`', version=`SDE.DEFAULT')
789 2024-3-19 11:07:16 | An error has occurred. Check the logfile above for details

It is checking out the license but while reading it is saying could not open Enterprise Geodatabase. Is it a problem of version of FME Desktop and Flow?. All SDE files I had created using ArcGIS Desktop. Do I need to create it using Pro?. 

icon

Best answer by panda 19 March 2024, 17:24

View original

2 replies

Badge +13

I think there’s couple of things you will need to check.

  1. make sure that FME Flow machine does have ESRI enterprise installed on the same machine (FME will check out the enterprise license when the workspace ran). You do not need all the component of ESRI enterprise, just ArcServer installed is sufficient and it needs to be licensed.
  2. FME Form (dekstop) and FME Flow (Server) do need to be the same version. (2022 and 2023 FME version are quite a big upgrade, and it may not be fully compatible)

I believe it failed because of the #1. But please let me know if that wasn’t the case.

Badge +6

Thanks for the reply.

Reply