AnsweredAssumed Answered

Geoprocessing Service Stops Working

Question asked by crookcountygis on Dec 29, 2016
Latest reply on Oct 5, 2018 by jesgould

I have two geoprocessing services that are giving me fits. One of them is an extract data tool and one creates a csv. If I restart them they run solid for about a day, but after that I get a few different results. 

 

  • The extract data tool will look like it runs fine, but then when you open the newly downloaded features it's an empty feature class. 
  • The CSV creating service runs fine until the part where a query is introduced, it then says it's an invalid query.

 

If I go into my ArcGIS Server Manager and hit the "Save and Restart" button, they are recycled and run fine for another day.

 

I've played with the recycling settings in the processes tab but nothing seems to make a difference. I have a bunch of web and feature services that run just fine. It only seems to be the geoprocessing services.

 

Below are the errors that show for some test geoprocessing services that I have set up.

 

It seems like something is stopping the connection files on my ArcGIS Server from being able to hit my SDE data. I do have scripts that kill connections every night, but the connection files should still work once they've run, I would think at least.

 

Data Extraction Service

Submitted.
Executing...
ERROR 000732: Area of Interest: Dataset D:\arcgisserver\directories\arcgissystem\arcgisinput\Test\Extract_TEST.GPServer\extracted\v101\ADMIN.sde\CROOK.DBO.data_extent does not exist or is not supported The value does not exist. The value is empty. ERROR 000732: Area of Interest: Dataset D:\arcgisserver\directories\arcgissystem\arcgisinput\Test\Extract_TEST.GPServer\extracted\v101\ADMIN.sde\CROOK.DBO.data_extent does not exist or is not supported
Failed.

 

CSV Creating Service

Submitted.
Executing...
Executing (ParcelBufferSelection): Model2 "maptaxlot = '1522000000600'" "750 Feet" d:\arcgisserver\directories\arcgisjobs\test\mailinglabelstest_gpserver\j41d3fadfd33345ddbec3b9eb7089aa87\scratch\scratch.gdb\parcels_Select_NEW d:\arcgisserver\directories\arcgisjobs\test\mailinglabelstest_gpserver\j41d3fadfd33345ddbec3b9eb7089aa87\scratch\SELECT_NEW.xls
Start Time: Thu Dec 29 06:35:28 2016
Executing (Model2): Model2 "maptaxlot = '1522000000600'" "750 Feet" d:\arcgisserver\directories\arcgisjobs\test\mailinglabelstest_gpserver\j41d3fadfd33345ddbec3b9eb7089aa87\scratch\scratch.gdb\parcels_Select_NEW d:\arcgisserver\directories\arcgisjobs\test\mailinglabelstest_gpserver\j41d3fadfd33345ddbec3b9eb7089aa87\scratch\SELECT_NEW.xls
Start Time: Thu Dec 29 06:35:28 2016
Executing (Select Layer By Attribute): SelectLayerByAttribute MailingLabelsTEST\CROOK.DBO.parcels CLEAR_SELECTION #
Start Time: Thu Dec 29 06:35:28 2016
Succeeded at Thu Dec 29 06:35:28 2016 (Elapsed Time: 0.00 seconds)
Executing (Select): Select MailingLabelsTEST\CROOK.DBO.parcels d:\arcgisserver\directories\arcgisjobs\test\mailinglabelstest_gpserver\j41d3fadfd33345ddbec3b9eb7089aa87\scratch\scratch.gdb\parcels_Select_NEW "maptaxlot = '1522000000600'"
Start Time: Thu Dec 29 06:35:28 2016
ERROR 000358: Invalid expression maptaxlot = '1522000000600'
Failure to access the DBMS server
The item was not found.
Failure to access the DBMS server [[Microsoft][SQL Server Native Client 11.0]Communication link failure] [CROOK.sde.GDB_Items]
Failure to access the DBMS server [[Microsoft][SQL Server Native Client 11.0]Communication link failure] [CROOK.sde.GDB_Items]
The table was not found. [parcels_Select_NEW]
Failed to execute (Select).
Failed at Thu Dec 29 06:35:29 2016 (Elapsed Time: 1.08 seconds)
Failed to execute (Model2).
Failed at Thu Dec 29 06:35:29 2016 (Elapsed Time: 1.35 seconds)
Failed to execute (ParcelBufferSelection).
Failed at Thu Dec 29 06:35:29 2016 (Elapsed Time: 1.36 seconds)
Failed.

Outcomes