topic Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise in Publishing and Managing Services Questions

Manage Spatial Indexes for Hosted Feature Layer on Enterprise

cle444 — Wed, 01 Dec 2021 10:47:05 GMT

Enterprise 10.9.0. Hosted feature layers with frequent data updates. Need to rebuild spatial indexes on a regular basis.

When using AGOL, there is an option in the portal item settings which rebuilds the spatial index to improve performance. The option is not available on Enterprise.

What are the common ways for rebuilding the spatial indexes for hosted feature layers on Enterprise?

Thanks in advance.

Hua

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

cle444 — Mon, 06 Dec 2021 21:38:00 GMT

Anyone who can comment on this question? Thanks

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

GarrettMelvin — Thu, 19 May 2022 13:49:01 GMT

We experienced performance issues with a frequently updated polygon hosted feature service, believed to be related to indexes needing to be rebuilt. A workaround that worked for us was to export the hosted feature service to a FDGB feature class, then through Pro use the Share>Web Layer>Overwrite Web Layer to replace the same HFS.

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

JoshuaPust — Thu, 19 May 2022 14:03:27 GMT

Same process, same issue, same workaround.

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

PaulNRWA — Fri, 25 Aug 2023 16:36:55 GMT

I'm resurrecting an old post. I'm encountering the same issue on our Enterprise 11.x install. I cannot figure out how to enable the rebuild indexes for managed layers. Any ideas?

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

GB_-_IanHogan__INFORM_ — Thu, 25 Apr 2024 15:47:35 GMT

Same issue, did you have any success? We have hosted feature layers in AGOL. The "Rebuild Spatial Index" option just hangs, and once it's hung, it is never available again. It will report a "Creating index: Indexes may take a moment depending upon the amount of data." message, one of which I've had now for a month.

Looking under the hood, the Feature Layer Definition JSON shows an "updateLayerDefinitionStatus" of "InProgress", but I've found nothing online for that parameter.

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

cle444 — Fri, 14 Jun 2024 10:12:36 GMT

As of today, June 14, 2024, 10.9.1 Enterprise, we are still pretty blind on how the hosted feature layer in the ArcGIS managed datastore works and what kind of best practices to maintain it, e.g. rebuilding indexes. There are growing concerns because we have had more mysterious data store crash incidents in the past year. We now use hosted feature services for short-term or smaller-scale projects and try using SDEs for long-term ongoing updates of required data. We liked the simplicity of the hosted feature service, but the concerns of maintenance, data backup, and stability really made it not the choice for enterprise data storage. We would love to hear if someone out there had some great success maintaining the managed data store!

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

Arnaud_Leidgens — Fri, 14 Jun 2024 11:35:33 GMT

We are very interested by this topic as well. The only workaround that we found is to save all hosted feature layers in a GDB every 5-6 months and overwrite the hosted ones (same answer from technical support). A regular back-up restoration of the datastore helped as well. I though that the "rebuild spatial indexes" feature would become available in the last Entreprise update, as it is for AGOL, but unfortunately that was not the case.

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

gisquestions1 — Wed, 25 Sep 2024 17:16:30 GMT

Has anyone found a solution to this?

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

AdamGaudet — Thu, 27 Mar 2025 12:06:20 GMT

Just catching this post and thread today (March 2025). I have suspicions we may run into these kinds of issues in the future so posting as a means to document our thinking into the matter. (Sorry, I have no insights or solutions for you.)

Re: Manage Spatial Indexes for Hosted Feature Layer on Enterprise

GarrettMelvin — Thu, 27 Mar 2025 12:18:03 GMT

We just updated our environment to 11.4 and the rebuild spatial indexes option is available on a HFS. We updated from 11.1 where the option was not present, I cannot speak to 11.2 or 11.3.