I have a spreadsheet with 226 224 records. When I add the the spreadsheet to ArcGIS Pro and add XY, some of the records are no converted to points. I removed the records that were not converted to points and displayed and created a separate spreadsheet. The outstanding records were are displayed and I am able to create the shapefile. When I merge the 2 point shapefiles I get a 'General function failure' error message. If I merge the files in geodatabase the merge works but I get a "could not write value ' ' to output field Restricted" error message. I checked the attribute table and all seems fine.
Is my 'General function failure' error message when I merge outside the geodatabase due the large number of records? If yes how do I make the shapefile available outside the geodatabase.
sounds like there may be a blank in a numeric field (Restricted ?) in one of the files making the merge fail for that field. General function failure.
There are too many limitations with working with shapefiles.
pruning down the number of attributes you want to keep may reduce file size if that turns out to be the issue