topic Failed to Load Data in Attribute Table After Join in ArcGIS Pro Questions

Failed to Load Data in Attribute Table After Join

McKenzieBredemeyer — Mon, 16 Dec 2024 21:03:34 GMT

I have a shapefile that I have joined to an Excel spreadsheet and the join was successful, but when I open the attribute table and try to sort a field, an error message pops up the first time saying, "Failed to load data." with "An invalid SQL statement was used." in the More Info section. All the subsequent times I try to sort the table, the main error message changes to "Failed to create the sorted table cursor." but it has the same statement in the More Info section. I am able to sort the attribute table for the shapefile without the join just fine. I am using ArcGIS Pro 3.3, and both my shapefile and Excel sheet is on a SharePoint drive. I have never run into this error before, whether doing joins or not.

Re: Failed to Load Data in Attribute Table After Join

Robert_LeClair — Mon, 30 Dec 2024 20:22:12 GMT

So what I'm seeing in the internals is the issue is with the shapefile (for some reason) and is resolved when you export the shapefile to a file geodatabase feature class. Once this is done, build the join on the fGDB feature class and the Excel file. Sorting should work as expected.

Re: Failed to Load Data in Attribute Table After Join

McKenzieBredemeyer — Fri, 03 Jan 2025 19:57:44 GMT

Thank you! Doing the join in the file geodatabase worked.

Re: Failed to Load Data in Attribute Table After Join

SOONGKITWONG — Fri, 29 Aug 2025 21:27:23 GMT

I did something along this line and it sort of worked but now for some reason that layer is suuuper slow and laggy.

Re: Failed to Load Data in Attribute Table After Join

Robert_LeClair — Tue, 02 Sep 2025 14:32:35 GMT

@SOONGKITWONG - is the geodatabase local, on a shared network drive, or on OneDrive?

Re: Failed to Load Data in Attribute Table After Join

KeithAddison1 — Thu, 05 Mar 2026 18:52:25 GMT

This happens to me sometimes, thankfully I don't have to sort on any join fields so I just remove the join to make it go away. Source data is in SDE not .shp