topic Re: attribute table not showing in arcgis pro 2.5 in ArcGIS Pro Questions

attribute table not showing in arcgis pro 2.5

Gisbert61 — Wed, 04 Mar 2020 09:59:27 GMT

I loaded a point feature layer with 178 records in arcgis pro 2.5. Everything is showing in the map as expected. But my attribute table is not showing:

the switch button switches the selected rows but shows nothing. The Fields View button results in

Other layers in the map are showing their attribute tables ok.

the layer shows up OK in arcmap 10.6 and the attribute table is visible also in 10.6.

I downloaded the layer as gdb from agol. I have done this before and had no problems earlier.

thanks for your time,

Bert

Re: attribute table not showing in arcgis pro 2.5

George_Thompson — Wed, 04 Mar 2020 13:11:38 GMT

Where is the data housed for the layer, i.e. file geodatabase, shp file, Enterprise Geodatabase?

Re: attribute table not showing in arcgis pro 2.5

RobertBorchert — Wed, 04 Mar 2020 13:13:49 GMT

Must be some corruption in the file itself. Though it is strange the table appears in ArcMap and not Pro

Try moving the feature from ArcMap to a .gdb and view it in Catalog to make sure it is visible there.

Re: attribute table not showing in arcgis pro 2.5

Anonymous User — Wed, 04 Mar 2020 19:14:45 GMT

Same issue here. The data is there, as pop-ups will work, but I can't do anything with the attribute table itself.

Re: attribute table not showing in arcgis pro 2.5

Gisbert61 — Thu, 05 Mar 2020 07:25:52 GMT

I've downloaded the feature layer as a .gdb from our own arcgis online, so it arrived as a zipfile with the gdb named something like 0f4a0f952f304cd39bf3594141fad64c.gdb

Re: attribute table not showing in arcgis pro 2.5

Gisbert61 — Thu, 05 Mar 2020 07:45:12 GMT

I do this every day to visualise progress of a project, until a few days ago everything was as expected including the attribute table. I would be able to PM you the file should you want.

Re: attribute table not showing in arcgis pro 2.5

Gisbert61 — Thu, 05 Mar 2020 07:49:36 GMT

The catalog window in arcmap 10.6 shows up normally:

Re: attribute table not showing in arcgis pro 2.5

George_Thompson — Thu, 05 Mar 2020 13:32:54 GMT

Ok, so the data is being hosted in ArcGIS Online and the table is not showing?

I would reach out to tech support on this.

Re: attribute table not showing in arcgis pro 2.5

Anonymous User — Thu, 05 Mar 2020 16:46:29 GMT

For me, the attribute table doesn't show for the data being pulled from ArcGIS Online OR when I download it as a FGDB and bring it into Pro.

Re: attribute table not showing in arcgis pro 2.5

Gisbert61 — Mon, 09 Mar 2020 08:17:38 GMT

No, not hosted on agol, as I wrote before: "I've downloaded the feature layer as a .gdb from our own arcgis online, so it arrived as a zipfile with the gdb named something like 0f4a0f952f304cd39bf3594141fad64c.gdb"

Re: attribute table not showing in arcgis pro 2.5

George_Thompson — Mon, 09 Mar 2020 12:52:31 GMT

That is weird behavior. I would recommend working with technical support on this.

Re: attribute table not showing in arcgis pro 2.5

AndrewThompson2 — Tue, 24 Mar 2020 18:06:49 GMT

Hi,

I also have a HFL that is not showing attribute tables for 2 layers in ArcPro 2.5 but fine in arcmap and arcgis online. The other 7 layers in the HFL show the attribute table fine in ArcPro and elsewhere as well.

Has anyone been able to resolve this issue yet with ESRI technical support?

Andrew

Re: attribute table not showing in arcgis pro 2.5

AndrewThompson2 — Tue, 24 Mar 2020 18:09:55 GMT

Same behavior for me as well. I was able to use Xtools to view the attribute table in Excel too.

Re: attribute table not showing in arcgis pro 2.5

JohnBeers — Sat, 25 Apr 2020 20:15:25 GMT

I also have had the attribute table not display in ArcPro from a downloaded file geodatabase of a feature service hosted online. Check the editor tracking date fields in the Arc Catalog field property window. I had a default date of 12-31-1899. Removed the default value and I can now see the attribute table in ArcPRO. Republished the service with overwrite web service and things seem to back on track. I do not know how I accomplished getting the default values set in the tracking fields. But I am glad to see the attribute table is back. I hope this helps you.

John.

Re: attribute table not showing in arcgis pro 2.5

Anonymous User — Tue, 05 May 2020 17:36:02 GMT

Glad you got it working, but this was not the solution for me. Still grasping at straws.

Re: attribute table not showing in arcgis pro 2.5

JimmyKnowles — Thu, 18 Jun 2020 17:43:11 GMT

I'm having the same issue. Here are the steps that I take to recreate the issue and what I've done to try and troubleshoot it...

Create replica in fgdb format via the REST API (createReplica) of a hosted feature service
- I also exported to fgdb from the Item Details page in AGOL from web browser and got same results
Download zipped fgdb and unzip
Try to view attribute table in ArcGIS Pro Catalog View in the preview
- can see how many features there are, but can't see field names or field values
Add feature class to a map, can view features in the map
Can't view features in attribute table
Get an error when trying to access Design->Fields for feature class
Export fgdb using the ExportXMLWorkspaceDocument GP tool
- this completes successfully with any parameters I give it
- I validate the XML with several validators and it checks out
- I also did a cursory inspection of the XML and didn't see anything odd
If I try to use ImportXMLWorkspaceDocument, I get an 'Invalid XML file' error
using python I can do the following
- read the feature class into a spatially enabled data frame
- create a list of feature classes using ListFeatureClasses
- create a list of fields in a feature class using ListFields
- view all Field properties like name, aliasName, defaultValue, etc.
everything looks normal after inspecting the above

My only workaround at this point to be able to access this data in a 'working' fgdb in ArcGIS Pro is to use a third party tool (Enterprise Architect) to rebuild the fgdb for me. The steps I take to do this are:

Use ExportXMLWorkspaceDocument to export my fgdb to xml
Use Enterprise Architect
- import from XML to create a Enterprise Architect project
- export from Enterprise Architect project to xml
Use ImportXMLWorkspaceDocument to import from the xml from Enterprise Architect to create a new fgdb with same schema as the original one
Use Append GP tool to append all features from the original 'bad' fgdb to my recreated 'working' fgdb
- this works, but it recreates the GlobalIDs for all features when I do the Append
- this is an issue because there are some relationships that depend on the GlobalID for PK/FK relationships
- and the preserveGlobalIds environment setting only works for enterprise geodatabases

So, it looks like I'm going to submit a support ticket with Esri to see if they can figure out why certain fgdb's experience this behavior. Based on the above, the only odd thing in my feature service are some weird default values (-2209161600000 Update - this shouldn't really be an issue since this is really just 12/30/1899) for date fields that I'm not sure how they got there. These aren't default values for the Editor Tracking date fields, but for other date fields. When I inspect fields via python or ArcCatalog, I don't see these default values. They also don't show up in the XML as default values, it only shows up in the GDB_ServiceItems table in the xs:string for each Record in the fgdb.

UPDATE 6/22/2020: Thanks to Bert Kraan, I pinpointed my issue to the default values for those date fields. For some reason these default values cause issues in ArcGIS Pro and it hasn't been addressed yet in 2.5.0 or 2.5.1. If this happens to someone else, I've got two workarounds.

Use ArcCatalog to reset the default values. This is quirky. I had to go to the layer properties->Fields, type NULL into the default value box, hit Apply, go back to the same field and delete the '-2209161600000' that shows up in that box after hitting Apply, then hit Apply again. This needed to be repeated one by one for each date field that had that default value.
Use python to iterate through the feature classes in my fgdb, then iterate through fields. If the field had that default value, I used AssignDefaultToField to clear the default and set it to Null.

Once I did either of the workarounds, I was able to view the attribute tables in ArcGIS Pro.

UPDATE 6/23/2020: Esri support has confirmed for me the existence of BUG-000126591 - "Unable to view the attribute table after exporting the hosted feature service as a file geodatabase consisting of a date field." The bug is currently in the product plan and seems to effect ArcGIS Pro versions 2.4.2 to 2.5.1. Another workaround that support mentioned was exporting to shapefile, but that doesn't work for me due to relationships and long field names.

Re: attribute table not showing in arcgis pro 2.5

Gisbert61 — Mon, 22 Jun 2020 05:50:20 GMT

Support told me the default value for the datefield (12/30/1899) is exactly what triggers the bug (their words). It should be fixed by now, in the end I worked around by using arcmap 10.6 which works fine with my dataset.

Re: attribute table not showing in arcgis pro 2.5

JimmyKnowles — Mon, 22 Jun 2020 16:33:36 GMT

Thanks Bert. You're right. I did some additional testing and this appears to be the culprit, but it is not fixed in 2.5.1. I'll see what Esri support says.

Re: attribute table not showing in arcgis pro 2.5

ElizabethZizzamia1 — Tue, 27 Oct 2020 19:57:52 GMT

I was so happy to find this question since I've been struggling with the same bug. I cleaned my date values and even deleted the old creator date fields and only left one date field that doesn't have any null values. And it still won't show up in Pro 2.5.2! is there any news on this lately?