ArcGIS Pro 3.6.2 on Windows 10 Pro for Workstations.
I have used MapInfo Pro for many years but I'm new to ArcGIS, so I may be approaching this wrong...
HospitalMaster is a non-spatial table in MS SQL Server with XY coordinates in the Latitude and Longitude fields.
I want to add/import/convert this SQL table to a Point Feature Class in a File Geodatabase, but I get this error when I run the "XY Table to Point" tool:
XY Table To Point
=====================
Tool Path
Input Table C:\Users\xyzx\AppData\Roaming\Esri\ArcGISPro\Favorites\MarketData.sde\dbo.HospitalMaster
Output Feature Class M:\xyzx\Market Planning.gdb\HospitalMaster
X Field Longitude
Y Field Latitude
Z Field
Coordinate System GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision
=====================
Messages
Start Time: Monday, March 30, 2026 3:22:14 PM
Traceback (most recent call last):
File "c:\program files\arcgis\pro\Resources\ArcToolbox\scripts\XYTableToPoint.py", line 298, in <module>
File "c:\program files\arcgis\pro\Resources\ArcToolbox\scripts\XYTableToPoint.py", line 111, in xy_table_to_points
count = 0
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 32552, in GetCount
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 32549, in GetCount
retval = convertArcObjectToPythonObject(gp.GetCount_management(*gp_fixargs((in_rows,), True)))
~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 533, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
~~~^^^^^^^^^^^^^^^^^^^^^^^^^
arcgisscripting.ExecuteError: ERROR 160077: An underlying database error occurred.
Failed to execute (GetCount).
Failed script XY Table To Point...
Failed to execute (XYTableToPoint).
Failed at Monday, March 30, 2026 3:22:18 PM (Elapsed Time: 3.92 seconds)
