Skip to main content
Solved

FME Flow not able to Read the ESRI Enterprise Geodatabase


harish
Contributor
Forum|alt.badge.img+10

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?. 

Best answer by panda

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.

View original
Did this help you find an answer to your question?

2 replies

panda
Enthusiast
Forum|alt.badge.img+17
  • Enthusiast
  • Best Answer
  • March 19, 2024

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.


harish
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • March 19, 2024

Thanks for the reply.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings