Bug
Creating a dynamic layer fails when the SQL statement selects a shape column
| Bug ID Number | BUG-000167768 |
|---|---|
| Submitted | May 23, 2024 |
| Last Modified | February 13, 2026 |
| Applies to | Portal for ArcGIS |
| Version found | 10.9.1 |
| Operating System | Windows Server |
| Operating System Version | N/A |
| Status | As Designed |
Additional Information
Provide dataSource.spatialReference when a field list is included in the SELECT statement.Workaround
1. Add the spatialReference property to the dynamic layer definition if the shape field is explicitly mentioned in the SQL query in this link: https://localhost.esri.com/arcgis/help/en/rest/services-reference/enterprise/data-source-object/#query-table-data-source.
2. Create a database view containing only the necessary columns, then select all columns from that view using the following SQL statement: SELECT * FROM VIEW_NAME
Steps to Reproduce
Bug ID: BUG-000167768
Software:
- Portal for ArcGIS
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