topic Re: ArcGIS Pro 3.4.2 After Joining A Table - Failed to Open Table in ArcGIS Pro Questions

ArcGIS Pro 3.4.2 After Joining A Table - Failed to Open Table

KatyMooreFreeman — Thu, 13 Feb 2025 17:27:43 GMT

Updated to latest version and now I cannot open attribute table for a shapefile after joining a Zonal Statistic as Table output. I get the "Failed to open table. An invalid SQL statement was used" error. I can use the same shapefile and table in an older version and it works fine. Table and shapefile are stored locally.

Re: ArcGIS Pro 3.4.2 After Joining A Table - Failed to Open Table

DanPatterson — Thu, 13 Feb 2025 17:42:02 GMT

Use Copy Features to make a copy of the shapefile into a locally stored geodatabase featureclass. Try the join then. If it works it may be a recent bug

Re: ArcGIS Pro 3.4.2 After Joining A Table - Failed to Open Table

Robert_LeClair — Thu, 13 Feb 2025 23:10:31 GMT

Another thing to examine is see if any of the field names have a space in them. This will throw this type of error too.

Re: ArcGIS Pro 3.4.2 After Joining A Table - Failed to Open Table

HaileySmith — Mon, 28 Jul 2025 18:11:21 GMT

I had this same error and figured out that it was because my shapefiles had names that started with numbers. I renamed them (e.g. from 5kmPoly to Poly5km) and it worked.