Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 4 down vote favorite

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:

  • Have an edit session open.
  • Have another application open.

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

UPDATE: Still-Not working

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.

UPDATE 2: Still-Not working

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...

share|improve this question
Is your 'Near' operation the first geoprocessing call you're making on the layers? Is it possible that they have already been opened/loaded in Arc? – Radar Nov 14 '12 at 17:41
Yes I 'Near' is the first geoprocessing call on these layers. I have the layers 'Open' as in they show up in the table of contents of ArcMap. – TForward Nov 14 '12 at 17:46
What happens if you close ArcMap and run the tool from ArcCatalog? – L_Holcombe Nov 14 '12 at 18:44
From ArcCatalog Same Error.. – TForward Nov 14 '12 at 18:49
Do you have administrator rights on your 'pathTofolder?' Do you have the rights to even create schema locks on ArcSDE? – Mintx Nov 14 '12 at 19:10
show 6 more comments

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.