ArcSDE edits not showing up in ArcGIS Server Geodata Service?

Question

I've got an ArcGIS Server GeoData service against an SDE MSSql database. When changes are made to the source data, the edits don't appear to show up in the GeoData service.

If I restart the service, edits are available via the geodata service.

Is there something else I should be doing to allow edits to always be available?

---

Further investigation revealed that the service did reflect changes, though how long you have to wait is variable. Sometimes the delay is two minutes, sometimes 30 minutes.

At this stage, to force the GeoDataService not the cache any data, I've set the "Virtual Output Directory" of the service to be none. No caching, no problems. Though not ideal, as when no edits are happening, we don't get the performance improvements that caching offers.

Answer 1

The service was referencing a versioned Geodatabase. The key is that contrary to the documentation, when making a connection to a pooled service, you need to manually tell the connection to refresh the version.

Here's a code snippet of my updated connection method.

var som = this.Connection.ServerObjectManager;
this.Context = som.CreateServerContext(this.Service, "GeodataServer");

// get the workspace from the GeodataServer
this.DataServer = this.Context.ServerObject as IGeoDataServer;
this.DataServerObjects = this.DataServer as IGeoDataServerObjects;
this.Workspace = this.DataServerObjects.DefaultWorkingWorkspace;

//Refresh the data.
var version = this.Workspace as IVersion;
if (version != null)
{
    version.RefreshVersion();
}

Answer 2

One option I've discovered is to force the GeoDataService not to cache any data, I've set the "Virtual Output Directory" of the service to be none. No caching, no problems. Though not ideal, as when no edits are happening, we don't get the performance improvements that caching offers.

==Update==

Further testing suggests that there's still something holding onto data. So while this looked promising, it's still not the answer.