topic Rebuild Indexes Error - Object has no schema locks in Data Management Questions

Rebuild Indexes Error - Object has no schema locks

LauraSilsbee1 — Fri, 05 Apr 2013 14:04:01 GMT

I received the following error when trying to rebuild indexes on an 10.1 enterprise geodatabase:

Could not rebuild indexes for dataset egis93.SDEDATA.WTR_INVENTORY/egis93.SDEDATA.WR_WaterBodies.[Object has no schema locks.]
Failed to execute (RebuildIndexes)

Not sure where to look to correct this - suggestions welcome.

Re: Rebuild Indexes Error - Object has no schema locks

MichaelDesroches — Wed, 05 Jun 2013 11:16:25 GMT

I just ran into this... and am wondering if it's because the dataset is actually empty. Did you ever figure this out?

Re: Rebuild Indexes Error - Object has no schema locks

ChelseaRozek — Wed, 17 Feb 2021 22:33:42 GMT

I don't think this will help you in your situation, but in case anyone else is getting this error, here's what helped me. I was trying to run a spatial join on a hosted feature layer in ArcGIS Online with a local feature class in Pro. Got this error: ERROR 160244: Object has no schema locks.

I reprojected the local feature class into web mercator like the hosted feature layer and then it worked fine for me.