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:
- Before download, check if the service has been disconnected from the SDE
- Reconnect to SDE when necessary
Thanks for any tips!