topic Re: ORA-20085: Insert Spatial Reference SRID does not match in Data Management Questions

ORA-20085: Insert Spatial Reference SRID does not match

RobertMartin2 — Tue, 08 May 2012 22:41:15 GMT

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

Re: ORA-20085: Insert Spatial Reference SRID does not match

AlisonGaiser — Wed, 18 Jul 2012 15:05:08 GMT

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

Re: ORA-20085: Insert Spatial Reference SRID does not match

Leandro-Zamudio — Thu, 30 Aug 2012 02:35:48 GMT

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

Anyone has te same problem or a solution.

Greetings

Re: ORA-20085: Insert Spatial Reference SRID does not match

anilkumar — Sun, 18 Nov 2012 05:31:55 GMT

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

Re: ORA-20085: Insert Spatial Reference SRID does not match

anilkumar — Sun, 18 Nov 2012 05:36:08 GMT

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.

Re: ORA-20085: Insert Spatial Reference SRID does not match

AnjithaSenarath — Mon, 19 May 2014 09:01:13 GMT

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

Re: ORA-20085: Insert Spatial Reference SRID does not match

NidhinKarthikeyan — Mon, 19 May 2014 10:56:42 GMT

NIM099594. Fixed in 10.3.