topic Re: Error : An unexpected error occured in the Select by location command in Data Management Questions https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11113#M584 <HTML><HEAD></HEAD><BODY><SPAN>I think that this was occurring (in my case) because the GDB was in the Program Files folder and was "read only". The selections worked when I created a copy of the GDB into a different location. Maybe that tidbit will help someone ?!!?</SPAN></BODY></HTML> Mon, 29 Aug 2011 18:39:39 GMT JohnChurchill 2011-08-29T18:39:39Z Error : An unexpected error occured in the Select by location command https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11110#M581 <HTML><HEAD></HEAD><BODY><SPAN>My data is in personal geodatabase. I created a join between a layer (WellsLocation) and a other table (WellsSelect) in my geodatabase. I made a basic Definition Query in the layer WellsLocation properties. This query keep only record has value "1" in a field of WellsSelect table. So, when I want to select record in WellsLocation who are interserct a city (cityPolygon) with Select by location I get this error "An unexpected error occured in the Select by location command. General function failure (WellsLocation) Trop peu de parmètres. 1 attendu". My windows is in french that probably why the second part is in french. But, when I removed de SQL statement in Definition Query the selecton by location works well. Anyone knows why I can't use Select by location tool on un layer with a Definition Query ???</SPAN></BODY></HTML> Thu, 24 Jun 2010 18:15:02 GMT https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11110#M581 MélanieLambert 2010-06-24T18:15:02Z Re: Error : An unexpected error occured in the Select by location command https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11111#M582 <HTML><HEAD></HEAD><BODY><SPAN>Hi!</SPAN><BR /><SPAN>I ve the same problem. Did you ever manage to solve this issue?</SPAN><BR /><BR /><SPAN>Best regards</SPAN></BODY></HTML> Mon, 06 Jun 2011 09:50:46 GMT https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11111#M582 chriss_ 2011-06-06T09:50:46Z Re: Error : An unexpected error occured in the Select by location command https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11112#M583 <HTML><HEAD></HEAD><BODY><SPAN>I have this problem but I have no definition query, I am not in an edit session. I have a line layer in a GDB that has 100 out of 17449 records selected. I am attempting to use the selected records from that line layer to select features in a polygon layer that are within a distance of 3000 m from the selected features in the line layer (polygon layer has 1549 records/features). </SPAN><BR /><BR /><SPAN>I tried running repair geometry and check geometry (no problems identified). I still get the error message "An unexpected error occurred in the Select By Location command". Very frustrating.</SPAN><BR /><BR /><SPAN>BTW the selection works if I export both layers out of my GDB to shapefiles !!!</SPAN></BODY></HTML> Mon, 29 Aug 2011 16:18:27 GMT https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11112#M583 JohnChurchill 2011-08-29T16:18:27Z Re: Error : An unexpected error occured in the Select by location command https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11113#M584 <HTML><HEAD></HEAD><BODY><SPAN>I think that this was occurring (in my case) because the GDB was in the Program Files folder and was "read only". The selections worked when I created a copy of the GDB into a different location. Maybe that tidbit will help someone ?!!?</SPAN></BODY></HTML> Mon, 29 Aug 2011 18:39:39 GMT https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11113#M584 JohnChurchill 2011-08-29T18:39:39Z Re: Error : An unexpected error occured in the Select by location command https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11114#M585 <HTML><HEAD></HEAD><BODY><SPAN>From the description it sounds like you may be encountering a known issue when using the 'Select By Location' tool on a join with a definition query, NIM057356.</SPAN><BR /><BR /><A href="http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDU3MzU2">http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDU3MzU2</A><BR /><BR /><SPAN>I would recommend contacting technical support for further information and to confirm if the alternate solutions do not resolve the issue.</SPAN></BODY></HTML> Fri, 09 Sep 2011 16:28:27 GMT https://community.esri.com/t5/data-management-questions/error-an-unexpected-error-occured-in-the-select-by/m-p/11114#M585 JonDeRose 2011-09-09T16:28:27Z