AnsweredAssumed Answered

Enable Feature Access in Query Layer SDO_Geometry

Question asked by amena on Aug 21, 2015
Latest reply on Sep 15, 2015 by amena

Hello,

 

I have a query layer that I need publish as a feature service with capabilities (Feature Access, create, update delete) on ArcGIS for Server.

When I publish the services only with capabilities of Mapping, the service work fine. When I activate capabilities of Feature Access I get a error 00134

on the service editor (Analyse).

 

I followed the recommendation's blog "http://blogs.esri.com/esri/supportcenter/2014/04/08/the-evolution-of-query-layers/"

 

This is a example of my SQL Query Layer.

 

select IDE_EVENTO, IDE_ELEMENTO, NOM_GENERACION, NOM_AREA, NUM_CLIENTES_ESPECIALES, NUM_OTROS_CLIENTES, NUM_KVA_NOSUMINISTRADOS,

VLR_COSTOENERGIANOSUMINISTRADA, GEO_COORDENADA, IDE_ESTADO_TRAFOS, CLASSID, REVISIONNUMBER

from DMSEPM.DMST_GIS_EVENTO

--Only one table

--No clause Where

;

 

Note: I added a column auto increment ObjectID without result.

 

Environment:

ArcGIS for Desktop 10.3.1,  ArcGIS for Server 10.3, Data Base is Oracle 11g with SDO_Geometry.

 

  What I need for publish the Query Layer as a feature service for Edit Rest API.

 

Thank you for your Help

Outcomes