I have an enterprise database residing in a SQL Server installation that I am accessing through ArcGIS Server 10.1 and ArcGIS Desktop (Advanced) 10.1.
I would need to update a dataset that is in use by a service in the server installation. I can see, using queries to the tables in the SQL Server installation and using the lock manager, that the data is locked, and I can't change anything. If I shut down the Server service on the server machine, or stop the services, then the data is not locked.
In ArcGIS Server 10.0 I just edited service files, and the data was no longer locked. Now I try the method introduced in ArcGIS Server 10.1 - using ArcCatalog, and updating the advanced parameters - setting the schemaLockingEnabled status to false.
But nothing happens - data still locked!
Tried restarting the individual services + the server process - but no luck... !
Hugo, Our apology for the inconvenience caused by this bug which makes a mapserice work the opposite way for schema-locking. We are working on fixing this.
Please change the value of schemaLockingEnabled to True - this should do it.
Hugo, Our apology for the inconvenience caused by this bug which makes a mapserice work the opposite way for schema-locking. We are working on fixing this.
Please change the value of schemaLockingEnabled to True - this should do it.
