Skip to main content
Question

FME Server using SQLExecutor and PythonCaller

  • September 12, 2018
  • 3 replies
  • 61 views
francis_m
Contributor
Forum|alt.badge.img+7

Hi FME User!

I have a workbench that goes very well on desktop but not on server.

We are using FME 2017 (build 17722).

The workbench make a query on a SQL database to find some table name and type (it's SDE).

Then, I do another query on the same SQL database to check if there is any SDE Lock on the tables I got from the previous query.

If I find an SDE Lock, the script stop. If there is no SDE Lock, then I use PythonCaller to delete or truncate or rename those table. To do that I use arcpy (the table are SDE feature Classes).

As I said, on desktop, it's clean and perfect! But on server... no error message, just a FAILURE without explanation within the log file.

If I disable the SQL Executor, FME Server do the job as my desktop.

But as soon as I enable the SQL executor... it fails!

I know i can make all this in python... but it was working in FME Server 2014... but no more in FME Server 2017...

Any idea?

3 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • September 12, 2018

Have you uploaded (or created) the database connection on FME Server.

You can check this in the Connections menu.

If the database connection is not available the SQLExecutor can not connect to the database.

david_r
Celebrity
  • david_rCelebrity
  • September 12, 2018

Have you specified a custom Python interpreter on FME Desktop? If yes, have you done the same thing on FME Server? Do you have the same ArcGIS version on the desktop and the server?

francis_m
Contributor
Forum|alt.badge.img+7
  • francis_mContributor
  • Author
  • Contributor
  • September 12, 2018
david_r wrote:

Have you specified a custom Python interpreter on FME Desktop? If yes, have you done the same thing on FME Server? Do you have the same ArcGIS version on the desktop and the server?

On FME Server we have ArcGIS Server installed.

 

Yes I have created the connexion on FME Server.

 

Do you know how or where to change the python interpreter on SERVER?

 

But anyway... the python works without SQL executor...

 

Its the combination of SQLExecutor and PythonCaller that fail!

 

 

 

Reply


Helpful Members This Week

Community Stats

31,322
Posts
118,828
Replies
38,954
Members

Latest FME

Terms & ConditionsCookie settings

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
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.