topic Error in Data Management Questions https://community.esri.com/t5/data-management-questions/error/m-p/232567#M13226 <HTML><HEAD></HEAD><BODY><SPAN>I am getting a new error when I try to load a table from SDE can anyone interpret</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">One or more layers failed to draw:<BR /><BR />SATDEL_ADM.Routes20120315_SHP:&nbsp; Underlying DBMS error [ORA-29902: error in executing ODCIIndexStart() routine<BR />ORA-00933: SQL command not properly ended<BR />ORA-06512: at "SYS.DBMS_SQL", line 1053<BR />ORA-06512: at "SDE.SPX_UTIL", line 1428<BR />ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 139<BR />::SELECT&nbsp; 1 SHAPE, ROUTES20120315_SHP.OBJECTID,&nbsp; 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&nbsp;&nbsp;&nbsp; FROM&nbsp; SATDEL_ADM.ROUTES20120315_SHP ROUTES20120315_SHP WHERE SDE.ST_EnvIntersects(ROUTES20120315_SHP.SHAPE,:1,:2,:3,:4) = 1 ] [SATDEL_ADM.Routes20120315_SHP]</BLOCKQUOTE><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Client - ArcGIS 10.0 SP4</SPAN><BR /><SPAN>Database - Oracle 11g</SPAN><BR /><SPAN>SDE - 10.1</SPAN><BR /><BR /><SPAN>Layer(s) with problem created prior to applying SP4. Any layer created after applying SP4 does not generate this error (adding, accessing, or deleting).</SPAN></BODY></HTML> Thu, 22 Mar 2012 18:22:09 GMT ScottBlankenbeckler 2012-03-22T18:22:09Z Error https://community.esri.com/t5/data-management-questions/error/m-p/232567#M13226 <HTML><HEAD></HEAD><BODY><SPAN>I am getting a new error when I try to load a table from SDE can anyone interpret</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">One or more layers failed to draw:<BR /><BR />SATDEL_ADM.Routes20120315_SHP:&nbsp; Underlying DBMS error [ORA-29902: error in executing ODCIIndexStart() routine<BR />ORA-00933: SQL command not properly ended<BR />ORA-06512: at "SYS.DBMS_SQL", line 1053<BR />ORA-06512: at "SDE.SPX_UTIL", line 1428<BR />ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 139<BR />::SELECT&nbsp; 1 SHAPE, ROUTES20120315_SHP.OBJECTID,&nbsp; 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&nbsp;&nbsp;&nbsp; FROM&nbsp; SATDEL_ADM.ROUTES20120315_SHP ROUTES20120315_SHP WHERE SDE.ST_EnvIntersects(ROUTES20120315_SHP.SHAPE,:1,:2,:3,:4) = 1 ] [SATDEL_ADM.Routes20120315_SHP]</BLOCKQUOTE><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Client - ArcGIS 10.0 SP4</SPAN><BR /><SPAN>Database - Oracle 11g</SPAN><BR /><SPAN>SDE - 10.1</SPAN><BR /><BR /><SPAN>Layer(s) with problem created prior to applying SP4. Any layer created after applying SP4 does not generate this error (adding, accessing, or deleting).</SPAN></BODY></HTML> Thu, 22 Mar 2012 18:22:09 GMT https://community.esri.com/t5/data-management-questions/error/m-p/232567#M13226 ScottBlankenbeckler 2012-03-22T18:22:09Z