Bug
ArcMap does not honor a query layer coming from a feature class that is imported to PostgreSQL via PostGIS after it is published as a feature service.
| Bug ID Number | BUG-000122859 |
|---|---|
| Submitted | June 5, 2019 |
| Last Modified | June 5, 2024 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.6.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support. Note that ArcGIS 10.8.2 is the current release of ArcGIS Desktop and will enter Mature Support in March 2024 https://support.esri.com/en-us/products/arcmap/life-cycle. There are no plans to release an ArcGIS Desktop 10.9, and we recommend that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate for more information.Workaround
1. Delete 10 rows from the Postgresql non-geodatabase.
2. Select New Query Layer by gid.
3. Publish to ArcGIS for Server as a feature service.
4. Add the feature service to ArcMap as a user connection.
5. Select any feature successfully.
or
1. Delete 10 rows from the Postgresql non-geodatabase.
2. Use the Incrementing ID Field tool in ArcMap.
3. Select New Query Layer by gid.
4. Publish to ArcGIS for Server as Feature Service.
5. Add the feature service to ArcMap as user connection.
6. Select any feature successfully.
or
1. Delete 10 rows from the Postgresql non-geodatabase.
2. Export this data back into its database, with a new name, via ArcCatalog. (This resets the gid's).
3. Select New Query Layer by gid.
4. Publish to ArcGIS for Server as Feature Service.
5. Add the feature service to ArcMap as user connection.
6. Select any feature successfully.
Steps to Reproduce
Bug ID: BUG-000122859
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App