Latest Contributions by AdnanYounas2

‎08-11-2020

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.

‎08-11-2020

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.

‎08-10-2020

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.

‎08-10-2020

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

‎08-10-2020

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, A

‎08-09-2020

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.

‎08-09-2020

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

‎08-07-2020

Hi, 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

‎08-07-2020

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

‎08-05-2020

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

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by AdnanYounas2

Re: Spatial Indexing Issue

Re: Spatial Indexing Issue

Re: Spatial Indexing Issue

Re: Spatial Indexing Issue

Re: Spatial Indexing Issue

Re: Spatial Indexing Issue

Spatial Indexing Issue

Spatial Indexing Issue

Spatial Indexing Issue

FeatureClass Rebuild Spatial Index button Greyed out

Spatial Indexing Issue