topic Re: Random Character Added to Field Name Upon Publish in ArcGIS Enterprise Questions

Random Character Added to Field Name Upon Publish

AspenN — Tue, 29 Mar 2022 17:02:42 GMT

Since upgrading to Enterprise 9.1, a weird thing has been occurring when publishing out map services with layers joined to a view table. Pictured below shows the field names for the joined fields. The first one shows the published layer that was joined prior to the upgrade. The second image shows the published layer's fields that were joined after the upgrade (has an extra % sign in the field name). Is there a reason that the % is being added to joined field names all of a sudden?

Re: Random Character Added to Field Name Upon Publish

AspenN — Tue, 29 Mar 2022 17:37:20 GMT

As another note, this only happens when publishing from ArcGIS Pro. The same process in ArcMap returns the usual field names without the % sign.

Re: Random Character Added to Field Name Upon Publish

TanuHoque — Tue, 29 Mar 2022 17:42:31 GMT

@AspenN
I assume in this case you are using a table that is not registered to your geodatabase. When you add a table (regardless whether that has geometry column or not) that is not registered to a geodatabase, it gets added as what we call 'query layer'.

In that process, we need to give it an internal name. In order to make that name unique (not conflict with any existing table name), we prefix the name with '%'.

When you join, all field names get fully qualified. Hence you are seeing '%' showing up in the field name.

Do you see any issues while working with this e.g. some functions not working due to this?