When I create a query layer, the attribute table has 1004 records. When I attempt to export this data to a file geodatabase, it only has 523 records. I have tried exporting to a personal geodatabase, a shapefile, and also using Copy Features to export the data, each time only 523 records are exported.
What is going on?
When exporting to a geodatabase or using copy features tool, there is no error message. Only when I export to a shapefile, do I get three separate pop up windows:
- Error exporting data Error reading some rows from the source. These rows have not been converted.
- Warning: Some records may not have been exported correctly.
- There was an error exporting the layer.
I have managed to export many features successfully, but there appears to be a few tables that struggle with this.
I'm new to this type of work.
As a note, there are no joins or selections on the query layer when I attempt to perform the export. I am using ArcMap 10.4.1.5686, Advanced License.