topic Re: ERROR 160244: Object has no schema locks. Select by location in ArcGIS Pro Questions

ERROR 160244: Object has no schema locks. Select by location

Anonymous User — Mon, 03 May 2021 12:22:30 GMT

ERROR 160244: Object has no schema locks.
Failed to execute (SelectLayerByLocation).

I noticed it's giving me the error on a multipart polygon. I exploded and it worked. Can I not use multipart polygons?

Re: ERROR 160244: Object has no schema locks. Select by location

DavidPike — Mon, 03 May 2021 12:31:30 GMT

It should work. Potentially bad geometry - run the repair geometry tool , or a bad spatial index.

Re: ERROR 160244: Object has no schema locks. Select by location

Anonymous User — Mon, 03 May 2021 12:57:42 GMT

I ran the repair geometry and that didn't fix the issue. This error has no solutions.

160244: Object has no schema locks.—ArcGIS Pro | Documentation

Re: ERROR 160244: Object has no schema locks. Select by location

DavidPike — Mon, 03 May 2021 13:31:18 GMT

possibly https://pro.arcgis.com/en/pro-app/2.7/help/data/geodatabases/overview/modifying-a-spatial-index.htm#GUID-F9859FEE-F5BD-461E-9179-EFBFE9585C79

Re: ERROR 160244: Object has no schema locks. Select by location

JayantaPoddar — Mon, 03 May 2021 14:56:58 GMT

Could you provide details about the input and select features (Geometry Type, Spatial Reference, which one is multipart feature)?

Where are the features stored (File GDB, Shapefiles, Ent. GDB)

Also provide the defined tool parameters?

Does rebooting the machine work (It has worked mysteriously for many problems. So I don't want to miss this point.)?

Re: ERROR 160244: Object has no schema locks. Select by location

Anonymous User — Mon, 03 May 2021 15:22:39 GMT

My input feature is a Parcel poly feature class. Selecting feature is a 4 multipart feature class. They are both using the same spatial reference.

Relationship is "Have their center in"

Reboot does nothing. I even tried copying the feature to a different layer.

Re: ERROR 160244: Object has no schema locks. Select by location

ZacharyHart — Wed, 19 May 2021 18:21:28 GMT

I've got the same thing going on now with a script that was running perfectly fine a few months ago...all I can think of is I've upgraded Pro several times since then. Exact same tool: arcpy.management.SelectLayerByLocation

@Anonymous User Did you ever find a solution for this?

Re: ERROR 160244: Object has no schema locks. Select by location

ZacharyHart — Wed, 19 May 2021 18:20:54 GMT

This behavior is occurring in fGDBs, not eGDBs.

Re: ERROR 160244: Object has no schema locks. Select by location

JayantaPoddar — Wed, 19 May 2021 20:15:54 GMT

Not sure how I missed replying to this post.

In case you still have the issue, could you share a sample parcel data along with the multipart feature class?

Re: ERROR 160244: Object has no schema locks. Select by location

JayantaPoddar — Wed, 19 May 2021 20:16:49 GMT

Could you share sample data that you could use to reproduce the issue?

Re: ERROR 160244: Object has no schema locks. Select by location

Anonymous User — Wed, 19 May 2021 20:35:51 GMT

I never found a solution. I ended up exploding the multipart feature so now I use 4 polygons instead of 1. It's definitely broken because I have tried it with different multi-part features and none of them work.

Re: ERROR 160244: Object has no schema locks. Select by location

ZacharyHart — Thu, 20 May 2021 12:32:20 GMT

As I feared. For my particular workflow i need to retain the multipart polygon and even then I'm not sure there is a way to explode via arcpy.

Out of curiosity, what version of Pro are you using?

Pro 2.7.3 and Python 3.7.9 here...

EDIT:

I just tried the same process in ArcMap 10.7.1 (in Python window) with the same exact data and the tool runs without error.

Re: ERROR 160244: Object has no schema locks. Select by location

Anonymous User — Thu, 20 May 2021 12:36:24 GMT

I was using 2.7 I think but I have 2.8 now. I haven't tried it yet with the new version.

Re: ERROR 160244: Object has no schema locks. Select by location

ZacharyHart — Thu, 20 May 2021 12:55:41 GMT

I've not upgraded because I just fixed my dev environment upgrading to 2.7.3...so I've not quite worked up the appetite to jump to 2.8 yet!

These are the times I wish Esri actually watched these threads.

No fix for the last 3 versions?

🙄

Re: ERROR 160244: Object has no schema locks. Select by location

GISAdminGKB — Thu, 24 Jun 2021 09:17:52 GMT

We had the same problem since last week. But we could solve it by setting the coordinate system in the environments tab of the tool.

However we never had to do this before.

Re: ERROR 160244: Object has no schema locks. Select by location

ZacharyHart — Thu, 24 Jun 2021 13:39:53 GMT

@GISAdminGKB That's a rather astute observation!

Re: ERROR 160244: Object has no schema locks. Select by location

Anonymous User — Fri, 02 Jul 2021 18:34:22 GMT

Well I just tried it and it seems to be working like it should. I think there was a 2.8.1 update a few days ago so maybe that fixed it.