GP Service Not Retrieving Appended Records

[FrankMelton]

I have GP Service that executes a select by attribute using a date range criteria. The feature class it references is appended with new records weekly. The GP services will not retrieve the appended records when it is executed. It does not return an error on execution it simply returns 0 records. It will still only retrieve records from the date ranges available when the table was initially populated.

The model  that was used to develop the GP Service will retrieve the records when run from ArcMap. The feature class displays all the records in ArcMap and select by attribute for the appended records will work. The records can also be queried fro SQL Server directly.

Any guidance or help on what may be causing this would be appreciated.

[TomSellsted · Accepted solution]

Frank,

I had a very similar problem.  This occurs when publishing the geoprocessing script.  In my case it was copying the data to the service directory instead of using the SQL Server connection set in the data store.  Check to see if the data is being copied into the service directory.

Regards,

Tom

[TomSellsted]

Frank,

Here is the geonet post that might help explain your problem:

Python geoprocessing script published as service doesn't use the Data Store

Regards,

Tom

[FrankMelton]

Absolutely right. Changed the connection type and re-published the service and everything worked correctly. Thanks for you help on this!

[TomSellsted]

Frank,

Excellent!  Glad that was the solution!

Regards,

Tom