Random Character Added to Field Name Upon Publish

500
2
Jump to solution
03-29-2022 10:02 AM
AspenN
by
Occasional Contributor

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? Previous Joined.jpgRecent Join.jpg

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
TanuHoque
Esri Regular Contributor

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

View solution in original post

0 Kudos
2 Replies
AspenN
by
Occasional Contributor

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

0 Kudos
TanuHoque
Esri Regular Contributor

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

0 Kudos