topic Re: arcpy.TestSchemaLock misbehaving at 10.5.1? in Python Questions

arcpy.TestSchemaLock misbehaving at 10.5.1?

CarlBeyerhelm1 — Mon, 11 Dec 2017 22:58:19 GMT

In the past, I've successfully used arcpy.TestSchemaLock prior to undertaking schema modifications within script tools. I've recently upgraded to 10.5.1 and discovered that arcpy.TestSchemaLock is now returning False when it should return True.

The example snippet below returns False in the Python window, but I can immediately add a field to the tested feature class, which indicates that it is not locked and should have returned True.

Did something get broken in 10.5.1 that worked in 10.4.1?

Thank you.

>>> fc = r'C:\Workspace\2017_Hyde\incident_data\2017_Hyde_AzCof331_Events.gdb\EventLine

>>> canGetLock = arcpy.TestSchemaLock(fc)
>>> canGetLock
False

Re: arcpy.TestSchemaLock misbehaving at 10.5.1?

DanPatterson_Retired — Mon, 11 Dec 2017 23:02:53 GMT

bug http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDEwNDI4NQ==

version fixed 10.6

Re: arcpy.TestSchemaLock misbehaving at 10.5.1?

CarlBeyerhelm1 — Tue, 12 Dec 2017 00:25:01 GMT

Thanks. Could you re-try posting your link, please? I'm getting a "This bug does not exist" page.

Re: arcpy.TestSchemaLock misbehaving at 10.5.1?

DanPatterson_Retired — Tue, 12 Dec 2017 00:38:46 GMT

http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDEwNDI4NQ== strange Jive seems to want to drop the ==

so just in case

Re: arcpy.TestSchemaLock misbehaving at 10.5.1?

CarlBeyerhelm1 — Tue, 12 Dec 2017 13:13:40 GMT

OK, thanks.

I guess the workaround is to bracket schema lock-prone code with try: and except:

Re: arcpy.TestSchemaLock misbehaving at 10.5.1?

CarlBeyerhelm1 — Mon, 30 Apr 2018 17:58:46 GMT

For info...

I'm in Windows 10 now (was in Win7 previously), and arcpy.TestSchemaLock() now seems to be working in 10.5.1.

Re: arcpy.TestSchemaLock misbehaving at 10.5.1?

MemoryBlue — Sun, 12 Dec 2021 02:37:13 GMT

I have the same problem in 10.5.0

Thinking which function would be used without modified the dataset. Currently I get AlterField_management.

import arcpy
def isLocked(dataset):
    # if arcpy.TestSchemaLock(dataset):
    #     return False 
    # else:
    #     return True
    try:
        arcpy.AlterField_management(dataset, "OBJECTID")
        return False
    except Exception as ex:
        return True‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: arcpy.TestSchemaLock misbehaving at 10.5.1?

WayneBoras — Mon, 10 Jun 2019 22:40:51 GMT

This is a perfect workaround. Thank you!