topic Re: Spatial Indexing Issue in My Esri Questions

Spatial Indexing Issue

AdnanYounas2 — Fri, 07 Aug 2020 10:18:32 GMT

Whenever I create a new feature class with ST_Geometry column, It's created without any issue but I cannot insert data into it until unless I remove the spatial index from it.

I have tried the following things:

1- Also when I delete the Spatial Index I can enter the data and all works fine but

2- Later if I want to create a spatial Index on the same layer, it doesn't work. I can click on the "create" button but no spatial index name appears or

3- If I do it through the tool it says "Succeeded" about the spatial index creation but cannot see the index.

4- Rebuild Index button is disabled.

Any suggestion, why is this behavior and how to fix it?

ArcGIS Desktop 10.6.1, ArcSDE 10.6, Oracle 19c.

Thanks

Younus

Re: Spatial Indexing Issue

George_Thompson — Fri, 07 Aug 2020 16:26:41 GMT

I would first recommend applying this patch to your ArcGIS 10.6.1 desktop; ArcGIS (Desktop, Engine, Server) Support for Oracle 19c Patch . Then I would update the geodatabase to the the same level as Desktop, then re-test the work flow. Oracle database requirements for ArcGIS 10.6.x ArcGIS Pro 2.1 and 2.2—System Requirements | Documentation

That issue does sound slightly weird.

Re: Spatial Indexing Issue

AdnanYounas2 — Sun, 09 Aug 2020 08:00:12 GMT

Hi Thompson,

Thanks for your response. The mentioned patch has already been applied. Also in ArcSDE version tables shows the below information:

10.6.1 Geodatabase.

Would it help to rerun the upgrade again? OR run the create spatial type again (ST_GEOMETRY) again? Or any other thought would be appreciated.

Thanks.