laptop and a wrench

Bug

ArcGIS for Server 10.3 and 10.3.1 service REST query fails to apply the Output Spatial Reference parameter if also querying by ObjectIDs rather than WHERE clause when the source data for the service is a query layer on a table from SQL Server 2008/2012 database (non-geodatabase) building from STPointFromText or STGeomFromText SQL Method.

Last Published: February 24, 2022 ArcGIS for Server
Bug ID Number BUG-000090873
SubmittedSeptember 21, 2015
Last ModifiedMay 31, 2023
Applies toArcGIS for Server
Version found10.3
Operating SystemWindows OS
Operating System Version10.0
StatusWill Not Be Addressed

Additional Information

This issue was logged against a version of the software which is no longer supported, and has not had activity in some time. We apologize that we were unable to address this issue within the current product life cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

Workaround

  1. Export data from the query layer to shapefile or feature class. This however drops the dynamic nature of the service to update with the source table.
  2. Use Query Layers on tables that are present in a geodatabase. This issue is only reproducible when the database does not have Esri geodatabase components./enable geodatabase components.
  3. have a geometry field in table and some kind of event to populated the geometry field as new records get added or existing ones get updated. And in the SQL (that defines the query layer), drop the part that dynamically generates points from x, y fields.

Steps to Reproduce

Bug ID: BUG-000090873

Software:

  • ArcGIS for Server

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic