topic Re: Arcpy script runs on server but not as a geoprocessing service in Python Questions

Arcpy script runs on server but not as a geoprocessing service

Strahanjen — Tue, 23 Feb 2021 16:39:15 GMT

We have an insert script that runs fine on our server. When we publish it as a geoprocessing service, we get this error:

RuntimeError: cannot open '..\..\..\..\..\maptool\tools\spatialdb_spatialtest.sde\spatialtest.name.name_si' Failed to execute

In the script, the connection looks like this:

fc = r"C:\apps\maptool\tools\spatialdb_spatialtest.sde\spatialtest.name.name_si"
cursor = arcpy.da.InsertCursor(fc, ("subject_item_id", "address1", "address2", "city_name", "state_code", "zip_code"))

Any suggestions on how to troubleshoot and solve would much appreciated. I suspect the issue may be with the path? I'm not sure why all of the ..\..\ are showing up in the error message.

Re: Arcpy script runs on server but not as a geoprocessing service

BlakeTerhune — Wed, 24 Feb 2021 14:14:38 GMT

Is that database connection registered with the Data Store on Server?

Re: Arcpy script runs on server but not as a geoprocessing service

Strahanjen — Tue, 23 Feb 2021 17:53:31 GMT

Thanks for the tip. The database connection was not registered with the Data Stores on the Server. We registered the connection, republished the service and are still getting an error. We also made sure that the server user has permissions on the folder. I looked at the file that was created when we published the tool and found this:

# Esri start of added variables
g_ESRI_variable_1 = u'..\\..\\..\\..\\..\\maptool\\tools\\spatialdb_spatialtest.sde\\spatialtest.name.name_si'
# Esri end of added variables

Any suggestions of what to try next?