POST
|
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.
... View more
08-11-2020
10:40 PM
|
0
|
0
|
607
|
POST
|
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.
... View more
08-11-2020
12:46 PM
|
0
|
3
|
2423
|
POST
|
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.
... View more
08-10-2020
06:27 AM
|
0
|
5
|
2423
|
POST
|
Yes, I verified it and it is registered in all the SDE referenced tables.
... View more
08-10-2020
06:25 AM
|
0
|
0
|
2423
|
POST
|
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
... View more
08-10-2020
06:24 AM
|
0
|
0
|
2423
|
POST
|
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.
... View more
08-09-2020
01:00 AM
|
0
|
0
|
702
|
POST
|
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
... View more
08-09-2020
12:52 AM
|
1
|
12
|
3136
|
POST
|
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
... View more
08-07-2020
03:27 AM
|
0
|
1
|
682
|
POST
|
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
... View more
08-07-2020
03:18 AM
|
0
|
2
|
800
|
POST
|
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
... View more
08-05-2020
11:06 AM
|
0
|
0
|
551
|
Title | Kudos | Posted |
---|---|---|
1 | 08-09-2020 12:52 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|