topic ArcGIS 10.6.1 Issues working with a SQL database view: unable to export data or create XY event layer in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/arcgis-10-6-1-issues-working-with-a-sql-database/m-p/91078#M3106 <HTML><HEAD></HEAD><BODY><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;">I am working to locate a number of records(approximately 40,000) from a SQL database view of some data(items used in construction). I am doing this by performing an attribute join based on a key number with one of our feature classes(construction projects) which has lat long information(in decimal degrees) .</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;">This join performs successfully but when I try to make an XY Event layer this tool runs indefinitely. When I tried to export the data from the view to a separate geodatabase it seemingly runs to completion and then also keeps running indefinitely(see screenshot). I am able to manually select a subset of records and export those, but selecting all records or trying to do a select by attributes does not work.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;">I have run the aforementioned process in both Pro 2.4 and ArcMap 10.6 and tried running it in Model Builder as well as the GP tool by itself.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;"><A href="https://i.stack.imgur.com/HdeaD.png" style="color: #1d4d5c; border: 0px; font-weight: inherit; text-decoration: underline; padding: 0px;"><IMG alt="enter image description here" src="https://i.stack.imgur.com/HdeaD.png" style="border: 0px; font-weight: inherit; padding: 0px;" title="" /></A></P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;">This is a large number of records, but not unreasonable so I wonder what could be causing this issue. There are issues of data quality within the data but I cleaned the Lat and Long fields and the attribute join between the feature class and the sql view works.There are also multiple points stacked on top of each other( multiple items per construction project)</P></BODY></HTML> Tue, 23 Jul 2019 22:35:43 GMT ITDGIS 2019-07-23T22:35:43Z ArcGIS 10.6.1 Issues working with a SQL database view: unable to export data or create XY event layer https://community.esri.com/t5/geoprocessing-questions/arcgis-10-6-1-issues-working-with-a-sql-database/m-p/91078#M3106 <HTML><HEAD></HEAD><BODY><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;">I am working to locate a number of records(approximately 40,000) from a SQL database view of some data(items used in construction). I am doing this by performing an attribute join based on a key number with one of our feature classes(construction projects) which has lat long information(in decimal degrees) .</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;">This join performs successfully but when I try to make an XY Event layer this tool runs indefinitely. When I tried to export the data from the view to a separate geodatabase it seemingly runs to completion and then also keeps running indefinitely(see screenshot). I am able to manually select a subset of records and export those, but selecting all records or trying to do a select by attributes does not work.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;">I have run the aforementioned process in both Pro 2.4 and ArcMap 10.6 and tried running it in Model Builder as well as the GP tool by itself.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;"><A href="https://i.stack.imgur.com/HdeaD.png" style="color: #1d4d5c; border: 0px; font-weight: inherit; text-decoration: underline; padding: 0px;"><IMG alt="enter image description here" src="https://i.stack.imgur.com/HdeaD.png" style="border: 0px; font-weight: inherit; padding: 0px;" title="" /></A></P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em; padding: 0px;">This is a large number of records, but not unreasonable so I wonder what could be causing this issue. There are issues of data quality within the data but I cleaned the Lat and Long fields and the attribute join between the feature class and the sql view works.There are also multiple points stacked on top of each other( multiple items per construction project)</P></BODY></HTML> Tue, 23 Jul 2019 22:35:43 GMT https://community.esri.com/t5/geoprocessing-questions/arcgis-10-6-1-issues-working-with-a-sql-database/m-p/91078#M3106 ITDGIS 2019-07-23T22:35:43Z