topic Re: Cannot Select or Identify an SDEVIEW in ArcMap in Data Management Questions

Cannot Select or Identify an SDEVIEW in ArcMap

Faustina_FosuaAnkomah — Tue, 19 Jul 2011 19:28:08 GMT

I created an SDEVIEW using sdetable -o create_view command. The source feature class has ST_Geometry as the config keyword and I able to identify and select the feature class in ArcMap. The sdeview displays, zoom in/out but I am not able to select or identify the sdeview in ArcMap. I did check the object grants and privileges for ST_Geometry and they are all in place.

Re: Cannot Select or Identify an SDEVIEW in ArcMap

VinceAngelo — Tue, 19 Jul 2011 20:36:51 GMT

The best way to create a view which includes an ST_GEOMETRY column is to use SQL to
define the view, making sure that it returns a NOT NULL integer (SE_INT32_TYPE) column,
then to use 'sdelayer -o register' on the view, with the INT32 as a USER-set registered rowid
column.

- V

Re: Cannot Select or Identify an SDEVIEW in ArcMap

Faustina_FosuaAnkomah — Thu, 21 Jul 2011 18:01:30 GMT

Vince,

I applied ArcSDE 9.3.1 SP2 and it did resolve the issue. I am able to create the view with sdetable -o create view, select and identify the spatial view feature created on the map.

Thank you.