Hi,
I created an FME workbench which contains python script at FME shutdown. This python script uses Arcpy library to make database connection. The workbench execute successfully and insert the data in database when executed manually. However, the script fails when we publish the FME workbench in FME server. It shows transaction is successful with message as 'FAILURE'. The FME job fails to insert data in database. Please advice.
What kind of ArcGIS product is licensed on the FME Server, and how is the workspace Python interpreter configured?
Hi @mehrotrarishi24 as @david_r mentioned to run workspaces with arcpy embedded, you will need to set the PythonCompatability to Esri Python 2.7 or 3.6 based on whether you have ArcGIS Desktop or ArcGIS Pro installed.
If you are running the workspace on FME Server, I would recommend going through this article Using ArcGIS Pro with FME Server
You will need to ensure that the account running FMEEngine can access ArcGIS Pro (and ArcGIS Pro is licensed for that user), along with workspace PythonCompatability set to Esri ArcGIS Desktop 3.6+