Ability to insert, update, delete feature layers based on database views

239
0
03-14-2012 03:50 PM
Status: Open
TimJONES4
New Contributor II
Currently in ArcMap 10.0 attempts to insert or delete features in layers based on a database view recieve the following:

Error Message:
Create: An unexpected failure occurred.
Not supported on a view [view_name]


However, edits (both geometry and attribute) are successful.
Also, inserts, updates and deletes are successful from layers based on the database table.

This issue occurs for feature layers based on simple views (views based on a single database table containing a single geometry type).

The requirement to insert, update and delete from all feature layers is essential for an enterprise GIS solution.

Steps to reproduce the issue (in Oracle):

*********Database**********

 - create table tjones.test_polygon (identifier number(38) not null, descr varchar2(100) null, geometry1 mdsys.sdo_geometry null);

 - create unique index tjones.test_polygon_i on tjones.test_polygon (identifier);

 - alter table tjones.test_polygon add constraint test_polygon_pk primary key (identifier);

 - insert into user_sdo_geom_metadata(table_name, column_name, diminfo, srid)
values ('TEST_POLYGON', 'GEOMETRY1', sdo_dim_array(sdo_dim_element('X', -180, 180, 0.005), sdo_dim_element('Y', -90, 90, 0.005)), 8311);

 - create index tjones.test_polygon_si on tjones.test_polygon (geometry1) indextype is mdsys.spatial_index;

 - create or replace view tjones.vw_test_polygon as
select identifier, descr, geometry1
from tjones.test_polygon;

 - insert into user_sdo_geom_metadata(table_name, column_name, diminfo, srid)
values ('VW_TEST_POLYGON', 'GEOMETRY1', sdo_dim_array(sdo_dim_element('X', -180, 180, 0.005), sdo_dim_element('Y', -90, 90, 0.005)), 8311);

 - grant select on tjones.test_polygon to sde;
 - grant select on tjones.vw_test_polygon to sde;

*********SDE**********

sdelayer -o register -l vw_test_polygon,geometry1  -e a -C IDENTIFIER,SDE -t SDO_GEOMETRY -i sde:oracle10g   -u tjones -p tjones@orodev02 -P HIGH -E 136,-31,156,-7

*********ArcMap**********

- create map document, add layer based on above view
- edit view data