Hi everyone,
I'm currently updating some FME Workspaces from Python 2.7 to Python 3.6.
The workspaces have a private parameter containing a python script which imports arcpy and reads data from a SDE DB. The first transformer is a feature reader which reads features from an arcGIS Server (10.7.1) in my organization.
The python script containd in the private parameter is executed successfully.
The workspace fails when executing the feature reader with following log :
Loaded Python module `arcgisonlinefeatures' from file `C:\Program Files\FME\python\python36\arcgisonlinefeatures\__init__.pyc'
Python Exception <ModuleNotFoundError>: No module named '_socket'
Could not create Python Reader `ARCGISFEATURES'
A fatal error has occurred. Check the logfile above for details
The python interpreter is set to use the dll installed with ArcGIS Pro : C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python36.dll. the python home in the fme options is left blank.
The python compatibility is set to "Python 3.6+"
All the transformers have been updated to the latest version available.
Does anyone have an idea what could be wrong with my setup?
My environment
- FME Workbench 2019.1 64 bits
- ArcGIS Pro 2.5
- PATH environment variable contains "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib" and "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages"
- PYTHONPATH environment variable contains "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib" and "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages"
- Currently no PYTHONHOME environment variable on my system. Setting values to PYTHONHOME didn't seem to have any impact on the behavior.
- When adding a python home in the fme options, "import arcpy" in the private parameter generates the error : no module named 'arcpy'