Bug
Pop-ups in ArcGIS Online return "No information available" if the map service contains a joined SQL table to a feature layer.
| 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 |
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.
- Works with a join:
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
Bug ID: BUG-000090041
Software:
- ArcGIS for Server
Get help from ArcGIS experts
Download the Esri Support App
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback