Recalculate Spatial Index Button Disabled

[JamesS1]

When attempting to recalculate spatial indexes within properties for a feature class in Pro, all of the buttons (recalculate, create, validate) are disabled.  There is no indication as to why they are not available. The user is an administrator. The feature layers are included in a feature service, but the buttons are disabled even when the service is stopped.

The Rebuild Indexes tool fails as well with the non-helpful message 'Function had no effect'.

ArcGIS Pro 3.5.3 and ArcGIS Enterprise 11.x

[JamesS1]

It appears, this being an enterprise geodatabase, that sysadmin privilege is required to calculate spatial indexes. I've inquired with Esri as to whether a lesser database privilege (like db owner) will allow the tool to run, but no response.

[Robert_LeClair]

@JamesS1 - in my experience teaching the enterprise geodatabase classes for Esri Training Services, the data owner can create, recalculate, or delete spatial indexes from standalone feature class properties dialog box. 

But you did mention a feature service so maybe that's the issue?  This Esri Community thread discusses rebuilding them in the ArcGIS Online or ArcGIS Enterprise portal via the portal item setttings - Manage Spatial Indexes for Hosted Feature Layer on... - Esri Community

[ChrisUnderwood]

Hello @JamesS1 , as described above you need to connect as the data owner itself to calculate spatial indexes. If that doesn't help, you could double-check your data owner has the correct database privileges. And you can check for Locks from the Administration > Locks menu.

Privileges for geodatabases in SQL Server—ArcGIS Pro | Documentation

Manage geodatabase locks—ArcGIS Pro | Documentation

[RhettZufelt]

no experience with enterprise 11.x, but earlier version are a little quirky with locks on services.

Often, stopping the service is not enough to release the locks.  Sometimes, seems more often than not, you need to stop the service, then restart the AGS service (or wait for several hours).

Not sure if this applies in your situation, but pretty easy to test.

R_