Questions tagged [schema-locks]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
12 views

How to disable schema locking on all services on ArcGIS Server?

I have a situation in which all services published to an ArcGIS Server (10.6.1) were published with schema locking enabled. I would like a way to disable schema locking on all services without having ...
0
votes
0answers
34 views

Release SDE locks from arcpy.da.Editor in same process

Is it possible to use arcpy.da.Editor and have it release its SDE locks in the same process? I am using arcpy and trying to perform edit operations on an SDE version, then reconcile/post/delete the ...
0
votes
1answer
96 views

Removing layers and schema locks with ArcPy?

I am creating a code that adds fields to a large set of shapefiles. I want to be able to open these shapefiles and edit the fields and then have them removed from the map document. I would like this ...
1
vote
1answer
123 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
33 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
241 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
25 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
77 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. ...
1
vote
4answers
71 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
33 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
597 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
599 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
5k 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
549 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
5k 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. ...
11
votes
4answers
7k 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 ...