I have a query layer in both ArcMap 10.5.1 and 10.7.1 that I am trying to publish to ArcGIS Server in both environments that has feature access with only Query capabilities. I get High error messages that need to be resolved for publishing to work that say "Query layer has virtual column 'SHAPE" and so on for the other columns in the query layer feature class.
Has anyone seen this error before (It's new to me)? If so, can you share what you did to correct this High error?
It sounds like you are encountering error 00223. With this in mind, does your query contain any virtual columns? If so, is there any difference when you change the query so that no virtual columns are present?
The Query Layer originates from an Oracle database that is spatially enabled with ESRI libraries but is not in an SDE database. The Query Layer uses a logical view which I think is composed of all derived values so AGS considers all the columns to be virtual columns. As such does this mean that a logical view can never have feature access enabled as AGS will always recognize the columns as virtual columns which are not allowed?