topic Re: Fields and data not showing in standalone table on ArcGIS Pro in ArcGIS Pro Questions

Fields and data not showing in standalone table on ArcGIS Pro

DanielSulak — Fri, 21 Feb 2020 21:27:46 GMT

I have a Standalone Table that has a relationship class to a feature layer. None of the data or fields are showing when I try to view the table. The total number of records is still shown in the lower left, and I can select records by using "Select Layer By Attibute", for example, but I cannot see the selected records. The table view is below. Many options are greyed out, but notice I do have some records selected and the selection tools are available.

If I try to look at the Fields View I get "An error was encountered loading fields."
This layer is stored online and is used heavily with collector. All seems to be normal both in AGOL and Collector.
I believe this is the first time I'm trying to look at this on ArcPro since updating to 2.5.
I have tried removing and re-adding the feature layer with the related table. I also tried loading the layer into a new blank project and had the same behavior.

Thanks to anyone who may have some insight!

Re: Fields and data not showing in standalone table on ArcGIS Pro

ThomasColson — Mon, 24 Feb 2020 18:23:38 GMT

10$ says you got a special character or text string in there that's causing this. Can you post the data to this thread as a spreadsheet?

Re: Fields and data not showing in standalone table on ArcGIS Pro

DanielSulak — Mon, 24 Feb 2020 23:57:15 GMT

I don't see any way to post a spreadsheet on the thread. The data are about 6,000 records with 15 fields, so I cannot easily post a screen shot or anything like that. You're saying a special character or string somewhere in that table could cause all the data to not display? This is a new problem, so I may be able to check all the recently created records.

Re: Fields and data not showing in standalone table on ArcGIS Pro

ThomasColson — Tue, 25 Feb 2020 12:28:27 GMT

Are you able to make a copy of your feature service and make it pubic?

Re: Fields and data not showing in standalone table on ArcGIS Pro

DanielSulak — Fri, 13 Mar 2020 22:39:01 GMT

Hello Thomas. Apologies for not responding, I have been out on field work and away from the computer. If you are still able/interested in helping with this issue I would appreciate it!
I have made a public copy of the layer here:

https://services3.arcgis.com/ikVUj9YUYY9keza1/arcgis/rest/services/Map/FeatureServer

I still cannot display any data in the attribute table of the feature layer or the table view of the related table in Arc Pro. I can click on an individual location and see the fields and their entries in a pop-up, and I can look at the tables in ArcGIS Online without issue.
Thanks again for any insights!

Re: Fields and data not showing in standalone table on ArcGIS Pro

JoeBorgione — Sat, 14 Mar 2020 15:17:39 GMT

The field aliases in your table indicate what Thomas Colson‌ is talking about; there are spaces and at least one special character ( & ). In Pro, are you attempting the relate to the original spreadsheet or have you used the excel to table tool, converting the spreadsheet into a fdgb table? If the latter, the tool typically strips the spaces and or special characters out of the field names.

Re: Fields and data not showing in standalone table on ArcGIS Pro

DanielSulak — Mon, 16 Mar 2020 15:43:07 GMT

The original data and feature class were created before I came to this position and started managing the data, so I'm not sure how they were originally created.

The problem seems to lie in the feature (location) table, and not the related tables. I am getting the same behavior if I load or copy only the feature class without the related tables.

In general, our work flow is that new features are created in the field using Collector. At the beginning of each quarter I work with the data in Pro and export all of the data created during the previous quarter for reporting and archive purposes. I first noticed the data not displaying during reporting in January, so it is possible that someone created a new feature in the previous quarter that has special characters causing the problem. I will dive into the new features and see what I can find.

Thank you for responding.

Re: Fields and data not showing in standalone table on ArcGIS Pro

ThomasColson — Mon, 16 Mar 2020 16:14:45 GMT

I get the same error you do, and cannot get the original data. Suggest tech support on this one.

Re: Fields and data not showing in standalone table on ArcGIS Pro

Scott_Harris — Mon, 16 Mar 2020 18:24:26 GMT

check out the field length of some of the fields -

I wonder if that's a clue?

Re: Fields and data not showing in standalone table on ArcGIS Pro

DanielSulak — Mon, 16 Mar 2020 20:55:15 GMT

Good catch there. I'm not sure how those came to be given those lengths, but I phoned tech support and they also identified these lengths as a potential issue. I was still able to use the layer as normal in ArcMap, and from there I rebuilt the feature service with shorter length limits and it now works in Pro. Thanks!

Re: Fields and data not showing in standalone table on ArcGIS Pro

ThomasColson — Tue, 17 Mar 2020 16:37:01 GMT

Is a field length of 10000000000 a documented limitation?

Re: Fields and data not showing in standalone table on ArcGIS Pro

JoshuaBixby — Tue, 17 Mar 2020 17:17:10 GMT

The mobile or runtime geodatabase format, i.e., *.geodatabase format, that ArcGIS mobile apps utilize is based on SQLite. It isn't coincidence you are seeing TEXT fields of 1-billion length because that is a default SQLite value: Implementation Limits For SQLite .

Maximum length of a string or BLOB
The maximum number of bytes in a string or BLOB in SQLite is defined by the preprocessor macro SQLITE_MAX_LENGTH. The default value of this macro is 1 billion (1 thousand million or 1,000,000,000).

I am guessing field length isn't being specified when the fields are created and hence the default is being used.

Re: Fields and data not showing in standalone table on ArcGIS Pro

RandyKreuziger1 — Fri, 11 Jun 2021 00:04:01 GMT

We are getting this error in Pro 2.8.0 on every feature class we have tried so far. It happens on both file and SQL geodatabases but only on our new VDI instances under Microsoft Windows 10 Enterprise.

We have Pro 2.8.0 running on a plain VM and it works perfectly fine on the same feature classes under Microsoft Windows Server 2016 Standard.

Re: Fields and data not showing in standalone table on ArcGIS Pro

MichaelSavarese — Thu, 08 Jul 2021 13:33:16 GMT

hey Randy was there a resolution to this. We are noticing the same issue in Pro 2.8 in VDI.