nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to remove schemalock in arcgis pro

EaswarA

I have tried to convert tabletotable in arcpy, while in the process the conversion got failed/interrupted. When I run the command again, it says cannot create csv file. When I checked the schema file got locked.

arcpy.TestSchemaLock.

How to release schemalock/database lock in arcgis pro.

Not able to do Lock view in arcgis pro.

Thank you

Easwar

Find more posts tagged with

Accepted answers

All comments

EaswarA

Hi @ChrisUnderwood

Thanks for sharing the screenshot. Tried to run the compact , but It doesn't help in removing lock.

It runs only compact process.

Let me clarify you with more details.

I am completely newbie to arcgis pro tool, in my project we are creating file geodatabase with new tool and we want to compare all the featureclass table data with the legacy file.

So here I am converting the featureclass to csv file using arcpy.conversion.TableToTable(featurefile, outputfile.csv)

The same command was working before, during my last run it got failed due to same filename and I have changed the filename and try to again and it started throwing the below error.

arcgisscripting.ExecuteError: Error 000210 cannot create output \users\output.csv.

Tried changing the output location too, but still showing same error.

Then checked the featureclass is there any schemalocl.

Ran below python command to check the schemalock

arcpy.Testschemalocl(featureclass)

it returns True

Hope this gives complete issue on my problem I am facing.

Thanks again,

Easwar

Chris Underwood

Hello @EaswarA The Compact tool is in the ArcGIS Pro Toolbox, you can just search for it.

If that does not help, please provide some details about what you are doing, and what you are seeing, to lead you to believe you are seeing some Locking problems.

EaswarA

Adding to the above point, I don't see any lock file in arcgis pro folder location or in my file geodatabase folder location.

EaswarA

Thanks Chris,

I don't have Compact installed/approved software to use. Can you please guide me how to delete it from windows location.

Thank you

Easwar

Chris Underwood

Hello @EaswarA

If your data is in a File Geodatabase, you can try releasing a Lock using by Compact or by using Windows Explorer, like this :

https://support.esri.com/en-us/knowledge-base/faq-why-do-file-geodatabase-lock-files-remain-after-a-p-000009399

If your data is in an Enterprise Geodatabase, you can try releasing the Lock using the Geodatabase Administration, Locks table. Note, you will need to connect as the Geodatabase Administrator in order to do this.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/manage-geodatabase-locks.htm#ESRI_SECTION1_4771E57CA5184AB3B296F03C8BB132AC

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.