Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [schema-locks]

The tag has no usage guidance.

1
vote
1answer
31 views

UpdateCursor can't acquire lock, but can acquire lock in TestSchemaLock

import arcpy import os.path arcpy.env.workspace = "C:/Users/melis/Documents/HenryWork.gdb" arcpy.env.overwriteOutput = True buffer = "LS_buffer" landcov = "ForestLC_clip" #create search cursor to ...
1
vote
1answer
27 views

Schema Locks Starting As Soon As User is Disconnected

I am having continual issues with scheme locks on our ArcSDE database, as soon as users are disconnected schema locks start appearing. We have 20 or so feature classes and it will show anywhere from ...
4
votes
1answer
104 views

Weird schema lock issue

I wrote a Python script that produces several output features layers in separate .gdb's. As I am testing and modifying my code, I generally go into arcCatalog, find the .gdb under which the feature ...
0
votes
1answer
23 views

Releasing user-schema locks when updating user-schema

Putting together a scripted event where we update user-schema (prod) in one sde instance from a dev user-schema instance. Both sdes are Oracle 12c. Replication is not used and the destination ...
0
votes
0answers
42 views

Remove Schema Lock after removing layer from TOC using python

I have a python addin tool that looks for layers in the TOC using ArcMap. I need to be able to replace these layers with new layers of the same name in the same workspace. I'm working with shapefiles. ...
0
votes
0answers
120 views

Schema lock issue adding and calculating fields

I am new to Python and trying to write a script that creates a modified DEM and uses that DEM and an input point shapefile to conduct a viewshed. I have successfully created a new DEM and am working ...
1
vote
4answers
67 views

Insert cursor only copies 80% of data due to lock?

I have two tables: 1) feature class (i.e. table in code) = sites under "SiteID" and mean july data under "JulyMean". The sites have duplicates, therefore there are several groups of same sites. There ...
1
vote
0answers
31 views

Changing Schema on Line Work

I'm working on an engineering project in which the customer wants a CAD and GIS deliverable. The customer sent detailed examples of the schema for all line, point and polygon files delivered in their ...
1
vote
1answer
464 views

Add Field giving ERROR 000464: Cannot get exclusive schema lock?

I'm doing an interface using ArcGIS and Python scripts that run at Python window. For each time that my sript run, I need to update information, so I think that I need to delete originals tables and ...
1
vote
1answer
407 views

Schema Locks Grayed Out

Schema locks are not showing up in the Oracle Instance when viewed using ArcCatalog. Data is being using in different applications but for some reason I'm not able to view the locks as the data owner/...
3
votes
1answer
4k views

Avoiding schema lock cannot be acquired because of existing lock on File Geodatabase?

I am having a problem with a Schema Lock in ArcMap for Desktop Advanced 10.2. The license that I have is Concurrent use for two computers. On Computer 1, I created an MXD Map File and a File ...
1
vote
1answer
507 views

Validating topology using python script when ArcMap is open?

I am testing on validating topology using python.The situation is when I run the script when arcmap is open, an error occurs which indicates the topology has already been opened (FDO error: -...
2
votes
3answers
2k views

How to acquire schema lock is one already exists?

I'm trying to delete a feature class from a feature dataset or to add a field to it, but I keep getting an error message (pics attached below). I have imported a geometric network I've created from ...
5
votes
1answer
4k views

Debugging ERROR 000464: Cannot get exclusive schema lock?

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. ...
10
votes
4answers
6k views

Avoiding exclusive schema lock error with ArcPy?

I have a script for updating some features on my database every night (just for copying and replacing some features). This features are "read-only". My problem is that I can't avoid that these ...