nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ORA-20085: Insert Spatial Reference SRID does not match

RobertMartin2

I am trying to compress a versioned Oracle-driven geodatabase. When I run the Compress Database command in ArcCatalog I get the error:

Failed to compress the database.
Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-20085: Insert Spatial Reference SRID 10 does not match WAT.WHYDRANT.SHAPE registered Spatial Reference SRID 8
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 1913
][SDE_WAT.DEFAULT]

After doing some research it seems like this is a spatial indexing problem, but I'm not sure exactly what. Can anyone help shed some light on this?

Thanks in advance,

Robert Martin

Find more posts tagged with

Accepted answers

All comments

NidhinKarthikeyan

NIM099594. Fixed in 10.3.

AnjithaSenarath

Does this help:

http://support.esri.com/es/knowledgebase/techarticles/detail/42335

This happen due to indexes. When we try to insert or update a feature from different projection Oracle return error

anilkumar

I exec'd this command 'UPDATE xxxxfetureclassXX SET shape = sde.st_transform(shape,5);

Result:

Error starting at line 1 in command:
UPDATE xxxxfetureclassXX SET shape = sde.st_transform(shape,5)
Error report:
SQL Error: ORA-28595: Extproc agent : Invalid DLL Path
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 788
ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2577
28595. 00000 - "Extproc agent : Invalid DLL Path"
*Cause:    The path of DLL supplied for the extproc execution is invalid.
*Action:   Check if the DLL path is set properly using the EXTPROC_DLLS
           environment variable.

anilkumar

I am having the same problem. I am replacing the featureclasses for time being. Please help me if anybody know the solution.

Leandro-Zamudio

I have the same problem when i try to compress my geodatabase SDE.

Anyone has te same problem or a solution.

Greetings

AlisonGaiser

Robert,

Did you manage to fix this issue? I have run into it a couple of times now. The way I fixed it the first time was by deleting the feature class and recreating it. Now that it has happened a second time, I would prefer to find a solution.

Any suggestions are appreciated.

Thanks,
Alison

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.