My ArcGIS Server services are locking tables in SDE. This is a problem if I need to edit or overwrite them. Unfortunately the locks don't go away upon stopping the services. The only solution I have found is to restart the Linux arcsde service, which has many implications. Is there a better way to lose these phantom locks?
-
Are spatially-enabled views an option? They've worked well for me in cases where I can't have a table locked.– Roger D.Commented Jul 31, 2010 at 16:15
Add a comment
|
2 Answers
Tell ArcGIS Server not to make those locks.
In your service cfg files, add this:
<ServerObjectConfiguration>
...
<Properties>
...
<SchemaLockingEnabled>false</SchemaLockingEnabled>
</Properties>
</ServerObjectConfiguration>
ESRI does not recommend this practice, but it should work for you. I did this for a bunch of really big services that required a massive (thousands of layers) data update while still running.
For more info, refer to the ESRI docs.
-
It worked! Restarting map services + SDE was not enough for the changes to take effect. I also had to restart AGS + IIS. (Not sure whether AGS or IIS was the problem, but I figure either one could be caching the XML content.)– nw1Commented Jul 30, 2010 at 14:56
At the UC ESRI was in fact recommending the use of the <SchemaLockingEnabled> tag, so long as you carefully consider the "Use caution..." paragraph in the documentation.
