topic Re: Spatial Indexing Issue in Geodatabase Questions

Spatial Indexing Issue

AdnanYounas2 — Sun, 09 Aug 2020 07:52:52 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

Asrujit_SenGupta — Sun, 09 Aug 2020 09:46:48 GMT

I am assuming that your geodatabase is upgraded to 10.6.1.

Also you should have this patch installed: ArcGIS (Desktop, Engine, Server) Support for Oracle 19c Patch
Is the issue with only 1 geodatabase? Have you tried on a different geodatabase?
Also maybe try with ArcGIS Desktop on a different server.

Re: Spatial Indexing Issue

DavidPike — Sun, 09 Aug 2020 20:40:05 GMT

is it registered with the gdb?

Re: Spatial Indexing Issue

George_Thompson — Mon, 10 Aug 2020 11:20:52 GMT

Here is the other thread with the same question: Spatial Indexing Issue

Adnan Younas‌ - in the other thread you mentioned running the Create Spatial Type (Data Management)—ArcMap | Documentation tool.

Is this the only tool that you ran on the Oracle DB?

If so, this does not create an Enterprise Geodatabase and may be part of the behavior.

Re: Spatial Indexing Issue

AdnanYounas2 — Mon, 10 Aug 2020 13:24:37 GMT

Hi,

Thanks for your response.

The Client and Server both are on 10.6.1.

We are facing the ST_Geometry related issue on this Database with almost all the schemas I have checked so far.

We have another environment but different version and working fine with same data.

Any clue?

Thanks,

Re: Spatial Indexing Issue

AdnanYounas2 — Mon, 10 Aug 2020 13:25:09 GMT

Yes, I verified it and it is registered in all the SDE referenced tables.

Re: Spatial Indexing Issue

AdnanYounas2 — Mon, 10 Aug 2020 13:27:46 GMT

No, what I was trying to suggest what if I re-ran this tool Create Spatial Type (Data Management)—ArcMap | Documentatiagain to fix any anomalies left behind?

As I have checked almost everything I could think of and database got all the references of spatial index but with the spatial index we cannot insert data and if I remove it all works except I cannot recreate spatial index using ArcCatalog etc.

Re: Spatial Indexing Issue

George_Thompson — Mon, 10 Aug 2020 14:11:01 GMT

Ok, did you run the Create or Enable Enterprise Geodatabase tool also?

If so, before or after you ran the Create Spatial Type GP tool?

If you ran both, I am wondering if there is an issue behind the scenes.

Re: Spatial Indexing Issue

AdnanYounas2 — Tue, 11 Aug 2020 19:46:21 GMT

It was upgraded from 10.2.2 to 10.6.1.

I am not sure about when it was ran but I guess we didnt run after the upgrade.

Also an interesting fact with more experiments on the schema:

User --> Schema owner: I inserted data into the table with spatial index enabled --> worked fine without an issue and row inserted.

Application User: Same Insert statement ran with spatial index and got the following error with the spatial index but data was inserted when I removed the spatial index. Checked the permissions though and looks fine.

ERROR at line 1:
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-00942: table or view does not exist
ORA-06512: at "SDE.SPX_UTIL", line 1147
ORA-06512: at "SDE.SPX_UTIL", line 1204
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2023

After interesting the data now I cannot create the spatial index same problem I mentioned earlier.

I hope I manage to explain it well. Please suggest.

Thanks.

Re: Spatial Indexing Issue

George_Thompson — Tue, 11 Aug 2020 19:59:53 GMT

Honestly at this point, I would work with technical support on this issue. They may be able to help narrow down the issue based on the workflow.

If you upgraded from 10.2.x --> 10.6.x, then you would NOT need to run the Create Spatial type or Enterprise GDB tools after the upgrade.

Re: Spatial Indexing Issue

Arne_Gelfert — Tue, 11 Aug 2020 20:15:28 GMT

Did you see this?

Error: DBMS table not found [ORA- 00942 : table or view does not exist]

Re: Spatial Indexing Issue

AdnanYounas2 — Wed, 12 Aug 2020 05:40:41 GMT

Thanks for asking.

I can create the layer without any error and issue, even I can see insert data using the schema owner. Issue is with the application/other user. I am getting an error if I have a spatial index enabled. Details can be seen in the above thread.

Re: Spatial Indexing Issue

ElliottPete — Thu, 01 Jul 2021 23:35:16 GMT

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.

I know this is an old thread, but I had this exact issue with a file geodatabase in 10.6.1. It does not seem like your issue was ever resolved, so here's what worked for me:

1. In ArcCatalog, delete the spatial index using the "Delete" button in the feature class's Properties window under the Indexes tab

2. Run "Remove Spatial Index" geoprocess / tool

3. Run "Add Spatial Index" geoprocess / tool

It might be helpful to close and re-open ArcCatalog between every step to make sure everything is fresh (kind of like rebooting your computer). After that, I successfully had a spatial index in my feature class.

You could also try the "Rebuild Indexes" geoprocess / tool. I know you are not using a file geodatabase, but maybe this will work!