Bug ID Number |
BUG-000090041 |
Submitted | August 18, 2015 |
Last Modified | July 28, 2020 |
Severity | Medium |
Applies to | ArcGIS for Server |
Version found | 10.3.1 |
Status | Duplicate
The issue is a duplicate of an existing issue. See the issue's Additional Information section for details. Customers associated with the duplicate issue are automatically attached to the open issue.
|
Description
If feature layers of a dynamic map service hosted on an ArcGIS for Server site contain joined SQL tables, pop-ups on the web map display a "No information available" message in ArcGIS Online.
Note:
The bug ID logged for this issue is NIM097308.
Cause
When map service layers are joined to a table from a non-enterprise geodatabase, the fully qualified field name for the right table may contain the percent character (%). Pop-up requests in the ArcGIS Online map viewer include the fully qualified field names in query requests for the map service, and the "No information available" message displays because map services consider the percent character invalid.
Workaround
Use one of the following workarounds listed below to resolve the issue.
- Add the feature layer URL to the web map, as shown in the example below.
http://servername.domainname.com/arcgis/rest/services/sampleservice/MapServer/0
- Does not work with a join:
http://servername.domainname.com/arcgis/rest/services/sampleservice/MapServer
- Before performing the join in ArcMap, add the data using the Add Data button instead of dragging and dropping from the Catalog window to prevent the percent character from being added to the table, and publish as a map service.
- Store the database table in the same geodatabase as the feature class before joining and publishing to ensure the percent character is not added to the table. The table may be created using SQL, and does not have to be registered with the geodatabase if the goal is to use a non-enterprise geodatabase table.
Steps to Reproduce