Questions tagged [schema-locks]
a service preventing modifications to the source dataset schemas.
27
questions
1
vote
0
answers
107
views
Listing Schema Locks on SDE from arcpy
In ArcGIS Pro, if you right-click on a .sde file > Administration > Locks, you see a list of feature classes that currently have an active lock.
Is it possible to get this list via Python, such ...
- 43
0
votes
0
answers
29
views
Cannot use Near() due to schema lock
I have recently been able to add 2 layers to the Table of Contents is ArcGIS Pro using ArcPy. It uses code like this:
ResultPath1 = r"*DirectFilePath*.gdb\GeocodedDonationLocations"
# ...
1
vote
0
answers
171
views
ArcMap 10.8 won't close properly
Using Windows 10 Pro, ArcGIS Desktop 10.8.
I have been having a really, really bad time with ArcMap not shutting down properly. It wasn't always this way, but for the last year or so I've had to ...
- 65
0
votes
1
answer
277
views
ERROR 000464 when trying to update domains
I have a python script which runs nightly to update a few domains in an Enterprise Geodatabase (Oracle). I'm using the arcpy.TableToDomain_management tool. The script works fine unless there are ...
- 21.8k
2
votes
0
answers
265
views
Disconnect users who are creating locks on specific feature classes
I have a nightly Python script which updates some domains in a geodatabase. The domain owner is "AMIS". In addition to the AMIS schema in the geodatabase, there are other schemas. In order ...
- 21.8k
1
vote
1
answer
510
views
Schema Lock ERROR 000464 when ArcMap is open
I am having an issue with schema locks while working on feature classes within a file geodatabase in ArcMap. There have been similar posts to mine (Avoiding exclusive schema lock error with ArcPy?). ...
0
votes
0
answers
468
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,455
1
vote
1
answer
502
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 ...
- 790
3
votes
0
answers
216
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 ...
- 39
8
votes
1
answer
673
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 ...
- 91
1
vote
0
answers
428
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 ...
- 21.8k
0
votes
0
answers
245
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 ...
- 41
0
votes
1
answer
789
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 ...
- 75
1
vote
1
answer
863
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 ...
- 165
1
vote
1
answer
157
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 ...
- 622
4
votes
1
answer
786
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 ...
- 1,883
0
votes
1
answer
51
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
0
answers
184
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. ...
- 51
1
vote
4
answers
122
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 ...
- 11
1
vote
0
answers
37
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 ...
- 389
1
vote
1
answer
1k
views
Add Field giving ERROR 000464: Cannot get exclusive schema lock
I'm doing an interface using ArcMap 10.2 and Python scripts that run at Python window.
For each time that my script run, I need to update information, so I think that I need to delete originals tables ...
- 309
2
votes
1
answer
1k
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
1
answer
6k
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 ...
- 61
1
vote
1
answer
703
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: -...
- 155
2
votes
3
answers
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 ...
- 3,146
6
votes
1
answer
11k
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. ...
- 2,199
11
votes
4
answers
9k
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 ...
- 165