XY Table to Point ERROR - Failed to execute (GetCount)

DanielEms — Mon, 30 Mar 2026 19:48:03 GMT

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)

Re: XY Table to Point ERROR - Failed to execute (GetCount)

DanPatterson — Mon, 30 Mar 2026 20:31:21 GMT

Follow the instructions in the error

160077: An underlying database error occurred.—ArcGIS Pro | Documentation

and try saving to a different folder path since

f = "M:\xyzx\Market Planning.gdb\HospitalMaster"

throws a unicode path error because of the \x while

f = "M:\Axyzx\Market Planning.gdb\HospitalMaster"

doesn't

topic Re: XY Table to Point ERROR - Failed to execute (GetCount) in ArcGIS Pro Questions

XY Table to Point ERROR - Failed to execute (GetCount)

Re: XY Table to Point ERROR - Failed to execute (GetCount)