topic Re: ArcGIS Server: Geodatabase error: Only one spatial column is supported in this operation in ArcGIS Enterprise Questions

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

GreggRoemhildt1 — Wed, 11 Jan 2017 14:18:21 GMT

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:

f:
json
returnGeometry:
true
spatialRel:
esriSpatialRelIntersects
maxAllowableOffset:
1
geometry:
{"xmin":-10384451.501584552,"ymin":5510511.210446009,"xmax":-10383876.812244719,"ymax":5511085.899785845,"spatialReference":{"wkid":102100,"latestWkid":3857}}
geometryType:
esriGeometryEnvelope
inSR:
102100
outFields:
*
outSR:
102100
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?

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

George_Thompson — Wed, 11 Jan 2017 14:58:16 GMT

Do you have multiple shape types in that column? For example records 1 - 10 are points and 20-15 are polygons?

Do any records in the table have an empty shape?

https://community.esri.com/groups/geodatabase?sr=search&searchId=45a6bb71-8b8d-4f83-8c00-78a28fe1e7ae&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=aeb971e4-0302-4116-9468-63e82375be9f&searchIndex=1‌

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

GreggRoemhildt1 — Wed, 11 Jan 2017 15:19:35 GMT

I'm not sure, that is a good question. I'm fairly certain they are all polylines, but is there a simple way to check for this and for empty shapes? It looks like the check/repair geometry tools only work on file geodatabases.

EDIT: All of the features appear to have a valid Shape.STLength() value (there are no nulls when I sorted the column).

EDIT2:

It looks like the issue is fairly obvious actually the rest page has two Shape fields..but how did the second one get there? The sql table has only one, and the arcmap document used to publish has only one. Perhaps the issue is with Shape.STLength(). It looks like ArcGIS Server is interpreting that field as "Shape"?

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

George_Thompson — Wed, 11 Jan 2017 15:27:01 GMT

Try this: STGeometryType (geometry Data Type)

ArcGIS can only read/display one spatial type in the table. You may need refine the query to only include one spatial type, i.e. Point Database data and ArcGIS—Help | ArcGIS Desktop

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

GreggRoemhildt1 — Wed, 11 Jan 2017 15:29:55 GMT

George Thompson‌ it looks like the issue is with the Shape.STLength() field (see my edit above).

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

George_Thompson — Wed, 11 Jan 2017 15:31:47 GMT

Not sure on why that happened. Is the SQL Server database registered with Server? If not, it will copy over the data to the server machine.

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

GreggRoemhildt1 — Wed, 11 Jan 2017 15:36:37 GMT

Yes, the data is registered with the server. But it is showing it under the "replaced" tab.

Here's a screenshot of the service workspace on the server.

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

GreggRoemhildt1 — Wed, 11 Jan 2017 15:41:54 GMT

The weird thing is I have another layer storm_pipe that is working correctly in the same service. That one has the same field Shape.STLength() in arcmap, but it does not display on the Rest services page. It just shows one Shape field.

I also have another layer, san_pipe that is having the same issue as the water_pipe (two Shape fields appearing).

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

George_Thompson — Wed, 11 Jan 2017 15:47:35 GMT

I will be honest, the server side is not something that I am super familiar or strong with. My background is in the enterprise geodatabase/database realm. Hopefully someone else would chime in with some ideas.

If you need more immediate assistance, I would recommend calling into Technical Support and talking to a Server analyst.

https://community.esri.com/groups/technical-support?sr=search&searchId=f41a4b36-3e8c-4f17-aad4-07614c9d80a9&searchIndex=1‌

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

GreggRoemhildt1 — Wed, 11 Jan 2017 16:44:33 GMT

After talking to support, we found out there's a bug BUG-000099970 that causes this to happen. It is based on the arrangement of fields in the ArcMap Document.

The synopsis is, if you rearrange fields or add new ones, make sure the SHAPE field comes AFTER the new fields, as a safe measure, move the Shape field to the very last one.

This happens on server version 10.4.1 as far as I know.

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

MichaelVolz — Wed, 11 Jan 2017 16:55:12 GMT

So Gregg your water_pipe and san_pipe layer both had the Shape field before the newly added field when they were not working, unlike the storm_pipe layer that had the Shape field last so it always worked properly. Once you moved the Shape field to the last field in both the water_pipe and san_pipe layers, the problem was resolved in AGS 10.4.1. Would you say that is the correct summary of this problem?

Would you know if this same problem is occurring in AGS v10.5 that has now been released?

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

GreggRoemhildt1 — Tue, 17 Jan 2017 14:50:33 GMT

Yes, that is exactly what was the issue. I haven't been able to test this on version 10.5 yet though.

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

MattCharton — Wed, 10 May 2017 13:31:58 GMT

I can confirm that this occurs in 10.5 though not dependably. I had two MapService layers that were doing this. For one, I was able to just move the Shape field to the end of the field list in the MXD and republish and it worked. For the second, this was not enough. I noticed that the only significant difference between the layer that was working correctly after the fix and the one that was not was that I had an alias on the OBJECTID field as ESRI ID. When I removed the alias and republished, it worked.

I also had another MapService layer that was not showing any of the fields after the Shape field (but was at least only showing the Shape field once). Once I moved the Shape field to the end of the field list in the MXD, all the fields showed up in the REST endpoint.

I have been a bit frustrated with the number of silly bugs like this in 10.5.