topic Empty Geometry failed to execute &quot;SelectLayerByLocation&quot; in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/empty-geometry-failed-to-execute-quot/m-p/554712#M18336 <HTML><HEAD></HEAD><BODY><P>We have a script that extracts the data from sde to gdb (newly created upon script execution). It runs through each layer in the sde to create new layers in gdb and sometimes throws an error "ExecuteError: Error 999999: Error executing function. The operation was attempted on an empty geometry. Failed to execute (SelectLayerByLocation)". Is there a way to remove the empty features or repair geometry? SDE automatically does checks the geometry by default but I am still having the problems.</P></BODY></HTML> Wed, 27 May 2015 22:05:49 GMT sohailali 2015-05-27T22:05:49Z Empty Geometry failed to execute "SelectLayerByLocation" https://community.esri.com/t5/geoprocessing-questions/empty-geometry-failed-to-execute-quot/m-p/554712#M18336 <HTML><HEAD></HEAD><BODY><P>We have a script that extracts the data from sde to gdb (newly created upon script execution). It runs through each layer in the sde to create new layers in gdb and sometimes throws an error "ExecuteError: Error 999999: Error executing function. The operation was attempted on an empty geometry. Failed to execute (SelectLayerByLocation)". Is there a way to remove the empty features or repair geometry? SDE automatically does checks the geometry by default but I am still having the problems.</P></BODY></HTML> Wed, 27 May 2015 22:05:49 GMT https://community.esri.com/t5/geoprocessing-questions/empty-geometry-failed-to-execute-quot/m-p/554712#M18336 sohailali 2015-05-27T22:05:49Z Re: Empty Geometry failed to execute "SelectLayerByLocation" https://community.esri.com/t5/geoprocessing-questions/empty-geometry-failed-to-execute-quot/m-p/554713#M18337 <HTML><HEAD></HEAD><BODY><P>Yes, you could try inserting Repair Geometry in the script (<A href="http://resources.arcgis.com/en/help/main/10.1/index.html#/Repair_Geometry/00170000003v000000/" title="http://resources.arcgis.com/en/help/main/10.1/index.html#/Repair_Geometry/00170000003v000000/">ArcGIS Help 10.1</A>). This sometimes needs to be run a few times consecutively to fully repair the geometry.</P></BODY></HTML> Thu, 28 May 2015 00:58:06 GMT https://community.esri.com/t5/geoprocessing-questions/empty-geometry-failed-to-execute-quot/m-p/554713#M18337 SepheFox 2015-05-28T00:58:06Z