Questions tagged [schema-locks]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
36 views

Negotiating ArcPy schema locks in script

How do I avoid the 000464 (Cannot get exclusive schema lock) error in this code caused by the last line? import arcpy import os geodatabase = 'C:/Data/testgdb.gdb' fc_name = 'test_feature_class' ...
1
vote
1answer
37 views

Test Schema Lock does not catch open feature class from within ArcGIS Pro

I am working on a script tool to be run in ArcGIS Pro (version 2.4.0 with Python 3.6.8) and wish to give the user a warning message and also time to close a feature class so as to avoid the script ...
2
votes
0answers
32 views

Issue with editing a feature class within ArcGIS

I have tried editing a feature class in an ArcGIS drawing which results to an error related to the specific geodatabase. The description in the error says "Check to see that you have the appropriate ...
0
votes
0answers
20 views

Error while trying topology validation

While creating new topologycannot create a topology in the selected feature dataset because the feature dataset is in use by another application/user. Cannot acquire a schema lock because of an ...
8
votes
1answer
97 views

Deleting old schema locks from ArcGIS Desktop

I am going through old data on our GIS System (hoping to improve our file storage), and discovered that we have multiple schema locks on files that date back to 2017, 2018, and 2019. A little bit of ...
1
vote
0answers
48 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
52 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
176 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
229 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
48 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
364 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
30 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
95 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
82 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
753 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
746 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
580 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
3k 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
6k 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 ...