I have a dynamic map service that displays features from a file geodatabase in a client app. The location of the file geodatabase is registered with ArcGIS server so data is not copied to ArcGIS Server when the map service id published.
I also have a python script that runs every 2 minutes and updates an attribute field in the published feature class. The published fc has a definition query like [ColumnName] = 1. So the map should only display features whose value is 1.
The script updates the fc with 1 or 0 depending on whether the feature should be displayed or not. This was working before but for some reason the map service seems to be caching the state of this feature class at the time of publishing the map service.
Any changes that the script makes after publishing are not reflected in the map service. Any ideas on why this is happening?