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!

[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?

[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!

[ThomasColson]

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

[Scott_Harris · Accepted solution]

check out the field length of some of the fields - 

I wonder if that's a clue?

[DanielSulak]

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!

[ThomasColson]

Is a field length of 10000000000 a documented limitation? 

[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.