Geographic Information Systems Asked by Tristan Forward on March 12, 2021
I am trying to run the “Near” tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error…
ERROR 000464: Cannot get exclusive schema lock. Either being edited or in use by another application.
I do not:
I saw this Link but I do not have ArcSDE installed locally so cannot execute “sdemon -o kill” to locally kill all connections…
How can I get an exclusive schema lock and/or bypass this error?
Windows 7, ArcGIS 10, Versioned SDE GeoDatabase
After reading this:
“In the Windows File Explorer, I looked at the properties of the folder where my script was putting its data. I saw that the folder was set to READ ONLY.” Source
I trying running the cmd command to set turn off read-only still no luck.
attrib -r pathTofolder
After further reading found that the read-only attribute in windows 7 is normal, and has more to do with windows system files then ability to write to the file folder.
Today after reconciling, thinking that all locks on the database world have been removed from the previous day. Tried running the “Near” tool again, but still no luck still gives the schema lock error…
Try exporting the data to a local location (I personally use C:Data), and attempt to run the tool on a local version of the data. If this works, you can load the data back into SDE. I've had too many problems with schema locks on SDE in both v9 and v10, and there are many ways to attempt to remove the locks. The problem would really come to a head if you can successfully run the tool on a local version and then NOT load the data back into SDE, which would indicate a deeper problem.
Answered by Whitish Mink on March 12, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP