Repair geometry worked for me too!Thank you for the answer!
I'm having the same issue with the select by location tool, and repair geom didn't do the trick
-selected layer is a line feature layer from an oracle spatial table
-selecting layer is a query layer from oracle spatial point table, layer containing only 1 point resulting form query => saved to disk with the copy features tool
-relation is intersect, with a radius of 50m
ArcgGIS version is 10.1 fyi
No sde used
What am I missing here?? I first thought it was due to differences in the geometry fields, because I had the same error with a self-drawn point feature class.
Weird thing is that it DOES work with a previously exported point form the database, which has exactly the same schema as the one I'm querying now...
Should I try a different export tool to materialize the query layer?
Would love some help on this! 🙂
Thanks!