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!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fields and data not showing in standalone table on ArcGIS Pro

DanielSulak

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!

Encuentra más publicaciones etiquetadas con

Accepted answers

Scott_Harris

check out the field length of some of the fields -

I wonder if that's a clue?

All comments

ThomasColson

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?

DanielSulak

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.

ThomasColson

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

MinionesZwei.jfif

DanielSulak

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!

JoeBorgione

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.

DanielSulak

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.

JoshuaBixby

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.

RandyKreuziger1

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.

MichaelSavarese

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

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.