AnsweredAssumed Answered

ArcGIS Server: Geodatabase error: Only one spatial column is supported in this operation

Question asked by faribaultGIS on Jan 11, 2017
Latest reply on May 10, 2017 by mdcharton

I have a layer, water_pipe. I am creating a feature layer in the arcgis javascript api, and when the feature layer loads, it give the error "cannot execute query" in the network logs.

 

The query string parameters look like this: 

  1. f:
    json
  2. returnGeometry:
    true
  3. spatialRel:
    esriSpatialRelIntersects
  4. maxAllowableOffset:
    1
  5. geometry:
    {"xmin":-10384451.501584552,"ymin":5510511.210446009,"xmax":-10383876.812244719,"ymax":5511085.899785845,"spatialReference":{"wkid":102100,"latestWkid":3857}}
  6. geometryType:
    esriGeometryEnvelope
  7. inSR:
    102100
  8. outFields:
    *
  9. outSR:
    102100
  10. token:
    <token>

 

On the server logs, the above error message is given. 

Geodatabase error: Only one spatial column is supported in this operation [gis.DBO.water_pipe][STATE_ID = 1447].

 

There is only one Shape column, here is a screenshot from the sql server manager:

Any suggestions on what I can do to fix this? 

Outcomes