AnsweredAssumed Answered

Check Geoprocessing Service SDE Connection Status

Question asked by sarahclark on Aug 13, 2015

In a nutshell: Is there a way to check if a geoprocessing service has been disconnected from an SDE, and then reconnect it if so?

 

I am trying to work around this bug: NIM072515 - 'Provide option to enable schema locking property for a geoprocessing service.'

 

I have a geoprocessing service published to the server (Data Extract) which puts a lock on the SDEs from which data is extracted (no option to disable schema locking like there is for a map service). This schema lock means that I cannot add/delete fields and change other 'schema' aspects of a feature without right-clicking the SDE in ArcCatalog --> Administration --> Administer Geodatabase and deleting the server connections causing the schema lock from the geoprocessing service.

 

However when I do that, the Data Extract task runs from the web map but returns empty, no data. I believe because it was disconnected from the SDE.

 

What I would like to do in my new data download script using arcpy is:

  1. Before download, check if the service has been disconnected from the SDE
  2. Reconnect to SDE when necessary

 

Thanks for any tips!

Outcomes