topic "Failed to load data" error when opening attribute table in ArcGIS Pro in ArcGIS Pro Questions

"Failed to load data" error when opening attribute table in ArcGIS Pro

CharlottePeters2 — Fri, 22 Nov 2019 00:10:46 GMT

Hi,

I've gotten the "Failed to load data. Error: Unexpected operation []" error several times when I try to open an attribute in ArcGIS Pro v. 2.4.2 on Windows 10. I haven't been able to figure out any pattern to what is causing the error. I was able to load the attribute table for a dataset one minute and then a few minutes later I get the error when opening the table. I can select the feature and see the attributes in the pop-up dialog and the edit attribute panel. I have no pending edits, no definition query, or any other constraints on the data. Closing and reopening the project does not help.

Any thoughts or suggestions?

Thanks, Charlotte

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

BenTurrell — Fri, 22 Nov 2019 00:41:56 GMT

Hey Charlotte,

I'm wondering if your machine is running out of RAM? Have you checked task manager to see if ArcGIS Pro is maxing anything out?

Thanks,

Ben

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

JayHodny — Thu, 19 Dec 2019 15:41:14 GMT

I have has a similar 'Failed to load data' error when trying to open attribute tables in Pro (version 2.4.2 and earlier). The error stated 'Failed to retrieve a page of rows.' I had task manager open while trying to open an att table again. The action consumed very little RAM or CPU time. I had ~49% RAM available during the execution. Opening and closing Pro had no effect. The attribute table is from a spatial view. Thanks!

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

JohnHu — Wed, 25 Mar 2020 16:14:50 GMT

Any update on this issue ? I have the same problem with ArcGIS Pro 2.4.3 and window 10. My table is from SQL Server spatial, I can add the table in Pro but get this error message when I try to open attribute table.

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

JustinJohnston — Fri, 24 Apr 2020 15:54:41 GMT

I am having the same issue. It happened when I deleted one row from the attribute table. It closed the table with that error. I was able to ctrl+z to undo the deletion, but I still needed that row gone. I tried to delete it from the Edit tab, but then when I saved and tried to open the attribute table, it still gives that error. Now I cannot ctrl+z it because I saved it. Anyone find a fix?

Cheers,

Justin

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

JustinJohnston — Tue, 28 Apr 2020 13:29:24 GMT

After having this issue, I was able to work around it by the following method:

1. In the contents pane, right click the feature class with the attribute table issue, go to selection, and choose "Select All".

2. With everything selected, right click the feature class again, go to selection, and choose Make Layer From Selected Features".

3. Use the Feature Class to Geodatabase tool to save the new layer to your geodatabase.

4. Open the attribute table in the new feature class.

The new feature class opened for me without the error and without the rows I didn't want. I deleted the old feature class from the GDB. If I again tried to delete another row from the new feature class, the error message returned for the new feature class as well. So I suggest that you first delete all of the records you don't want before using the workaround above to avoid having a bunch of the same features with different names in your GDB.

Cheers,

Justin

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

CharlottePeters2 — Fri, 12 Jun 2020 21:27:38 GMT

I've had the attribute table issue with 16gb and 32gb RAM machines and RAM wasn't maxing out. Updating to AGP 2.5.1, I'm still having issues getting some attribute tables to load even though the features still display on the map.

What worked for me so far is I created a new FGDB and exported the messed up FC to the new FGDB. I suspect that my issue has to do with the fact I was working with a FGDB that originated from ArcMap. In some instances, I had to use AGP's upgrade tool in order to edit ArcMap FGDB annotation or FCs in AGP. I don't remember if upgrading made a difference with the attribute table not opening though.

In the future, if I need to migrate an ArcMap project to AGP then I'm going to create a new FGDB with AGP and import all the FCs from the ArcMap FGDB to the new AGP FGDB.

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

MichaelVolz — Fri, 12 Jun 2020 21:34:22 GMT

I've found this solution to be very helpful when upgrading sofrware.

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

SusanSperbeck — Wed, 02 Dec 2020 20:11:16 GMT

I do not believe this has anything to do with RAM. I find that it comes from deleting a row (either from the original Attribute Table or from another layer that you created from the original). I very often make selections and then create a new layer from the selection, then I go about editing that one. One way you can get around this: from the original layer -- goto Data and Export Features to a new layer (the name cannot have spaces). You should then be able to open the attribute table of the new exported feature layer. Hope this helps!

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

SusanSperbeck — Wed, 02 Dec 2020 20:15:03 GMT

I figured this out as well. Just a note here to say that I have only seen this happen when deleting rows; nothing to do with RAM as far as I can tell. Great explanation.

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

LingrajPani1 — Fri, 09 Jul 2021 00:13:47 GMT

I had 2 feature classes one with object id / ESRI_OID and other without OID, and I noticed the feature classes without a unique ID always failed while loading the entire table. I suspect this error occurs if you don't have unique id for each rows.

You can view attribute of FC without unique ID , if you can zoom to few unique points and then Map-> Select Rectangle/ Polygon.

Regards,

Lingraj

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

WendyPan — Tue, 20 Jul 2021 22:20:31 GMT

I had a similar issue. The view I created from Oracle, and wanted to add into ArcGIS Pro. But there is no unique identifier in this view. It looks it can only upload part of data into ArcGIS pro. If I want to load all of data, the failed message popped up. But no issue in ArcMap 108. BTW, I am using ArcGIS Pro 2.7.

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

Matt-Goodman — Tue, 12 Oct 2021 15:52:55 GMT

I encountered this error trying to open the attribute table to an SDE feature class. I determined that the problem arose because I had applied a table join to the feature class, and the join table was contained within an file geodatabase with a numeric name (i.e. "49.gdb"). The attribute table for the feature class from the file geodatabase had opened just fine on its own, but after I had joined it to the SDE feature class, I could no longer open the SDE attribute table.

In order to resolve, I had to "remove all" joins and "remove all" relates to reset the fields.

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

Map2021 — Mon, 08 Aug 2022 20:18:16 GMT

That is a solution, but not a solution that works for Enterprise GDB and using dynamic data from a View table. Are there other options?

Re: "Failed to load data" error when opening attribute table in ArcGIS Pro

SpatialSam — Mon, 05 May 2025 14:01:56 GMT

I had an issue that said "A column was specified that does not exist" when I tried to open the attribute table. Turns out just exporting it to your GDB works!