Select to view content in your preferred language

Error

2081
0
03-22-2012 11:22 AM
ScottBlankenbeckler
Deactivated User
I am getting a new error when I try to load a table from SDE can anyone interpret

One or more layers failed to draw:

SATDEL_ADM.Routes20120315_SHP:  Underlying DBMS error [ORA-29902: error in executing ODCIIndexStart() routine
ORA-00933: SQL command not properly ended
ORA-06512: at "SYS.DBMS_SQL", line 1053
ORA-06512: at "SDE.SPX_UTIL", line 1428
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 139
::SELECT  1 SHAPE, ROUTES20120315_SHP.OBJECTID,  ROUTES20120315_SHP.SHAPE.points,ROUTES20120315_SHP.SHAPE.numpts,ROUTES20120315_SHP.SHAPE.entity,ROUTES20120315_SHP.SHAPE.minx,ROUTES20120315_SHP.SHAPE.miny,ROUTES20120315_SHP.SHAPE.maxx,ROUTES20120315_SHP.SHAPE.maxy,ROUTES20120315_SHP.rowid    FROM  SATDEL_ADM.ROUTES20120315_SHP ROUTES20120315_SHP WHERE SDE.ST_EnvIntersects(ROUTES20120315_SHP.SHAPE,:1,:2,:3,:4) = 1 ] [SATDEL_ADM.Routes20120315_SHP]


I am getting a similar error message when I try to delete from the same database. But I do not get this message from all themes in the database.

Client - ArcGIS 10.0 SP4
Database - Oracle 11g
SDE - 10.1

Layer(s) with problem created prior to applying SP4. Any layer created after applying SP4 does not generate this error (adding, accessing, or deleting).
0 Kudos
0 Replies