topic Re: ArcSDE View not working in ArcGIS Enterprise Questions

ArcSDE View not working

MicheleDe_Santis — Wed, 01 Apr 2015 09:19:36 GMT

Hi to all,

I created a ArcSDE 9.3 View with the command line "sdetable –o create_view ...." some month ago. In ArcCatalog I can see the table preview, but not the geography preview. This view is published in a ArcGIS Server 10.1 service, so the polygons are not visible in my web application. When I created, this view works fine. What can i do to see the polygons in the view?.I would greatly appreciate any feedback you could give me.

Hi michele

Re: ArcSDE View not working

JakeSkinner — Wed, 01 Apr 2015 11:40:38 GMT

Hi Michele,

Did you include the 'SHAPE' field when you created the view?

Re: ArcSDE View not working

MicheleDe_Santis — Wed, 01 Apr 2015 12:01:11 GMT

Thank you Jake,

yes, this is the command that i used:

sdetable -o create_view -T INFO_VAS_PIANI_COM_CATASTO -t XXXX.SIT_VAS01G_PIANI_COM_CATASTO,XXXX.TNO_CODICEUNICO_VAS -c "XXXX.SIT_VAS01G_PIANI_COM_CATASTO.OBJECTID,XXXX.SIT_VAS01G_PIANI_COM_CATASTO.CODICE_PRATICA,XXXX.SIT_VAS01G_PIANI_COM_CATASTO.ORIGINE,XXXX.SIT_VAS01G_PIANI_COM_CATASTO.COMUNE,XXXX.SIT_VAS01G_PIANI_COM_CATASTO.SHAPE,XXXX.TNO_CODICEUNICO_VAS.OGGETTO,XXXX.TNO_CODICEUNICO_VAS.AREA_CODICE,XXXX.TNO_CODICEUNICO_VAS.ENTE_CODICE,XXXX.TNO_CODICEUNICO_VAS.CODICE_UNIVOCO_VAS" -a "OBJECTID,CODICE_PRATICA,ORIGINE,COMUNE,SHAPE,OGGETTO,AREA_CODICE,ENTE_CODICE,CODICE_UNIVOCO_VAS" -w "XXXX.SIT_VAS01G_PIANI_COM_CATASTO.CODICE_PRATICA=XXXX.TNO_CODICEUNICO_VAS.CODICE_CIVILIA" -i sde:oracle10g:/:XXXX -u XXXX -p XXXX@dbistance

Re: ArcSDE View not working

VinceAngelo — Wed, 01 Apr 2015 13:49:13 GMT

Even back at 9.3 (which is now retired), the best way to create views was to use SQL to generate the view itself, then use 'sdelayer -o register' to register the view. This allows for various validation checks, including a SQL query on the registered rowid column (e.g., OBJECTID), to make sure that it contains unique values, and an 'sdetable -o describe' to verify that the rowid column type is mapping to the SE_INT32 datatype.

The only justification for using 'sdetable -o create_view' is the use of SDEBINARY storage (which was deprecated by Oracle's deprecation of LONG RAW) or SDELOB, neither of which was as flexible as SDE.ST_GEOMETRY.

Given the existance of a 10.1 AGS service, I would strongly urge you to move your geodatabase to a supported install (and make sure that SP1 and the follow-on patches have been applied).

- V