Hello again.
I'm using several translations involving HTTPCallers and other transformers -- all of which work successfully with FeatureWriters saving to ESRI Geodatabase (File Geodb Open API) feature classes.
I'm running into a problem saving to ESRI Geodatabase (ArcSDE Geodb), however, where the translation never completes, and the log ends with the following:
Successfully imported schema
ImportError: No module named site
This seems to be Python-related from what I have found, even though I do not use the PythonCaller or anything Python-related in my workspace. I can't seem to find a similar problem to mine.
Yesterday I installed Python 3.6, which I assumed may be causing this. So I uninstalled it and made sure Python 2.7 was still present (it is). The Python interpreter preferences in FME still point to Python 2.7. I tried changing those to 3.6 to match the version I had previously installed, which did not help.
I had complete success with one translation, but all others have the same symptoms described above. Under Table Creation Parameters, I've specified the Feature Dataset I'd like this to write to, but that fails as well and a blank Feature Class is written within the SDE GDB instead. I'm also using an XML template in the writers, but I've already tested not using it and it does not help.
This happens with FeatureWriter and regular Writers. The General parameters are:
Feature Operation: Insert
Table Handling: Create If Needed
Not sure what's causing these inconsistent results.
Thanks.
FME 2018.0.1
Windows 2012 R2