topic Error encountered when attempting to create spatial view in Data Management Questions

Error encountered when attempting to create spatial view

CraigPatterson — Fri, 04 May 2012 18:08:31 GMT

Hi,

I'm trying to create a simple spatial view using the following command:

sdetable -o create_view -t source_fc -T destination_view -c "*" -i sde:sqlserver:server\instance -D database -u username -p xxxxxxx

I'm recieving the following error:
Error: Invalid entity type(-29)
Error: Unable to create view destination_view

I've searched through the forums and the internet, but nearly all references to -29 deal with registering tables, which I don't need to do since the source is already a Feature Class.

Does anyone have any ideas?

Thanks,

Craig

Re: Error encountered when attempting to create spatial view

VinceAngelo — Fri, 04 May 2012 18:27:37 GMT

'sdetable -o create_view' should only be used when the geometry is a SDEBINARY or
SDELOB storage layer. Views on native geometry or ST_GEOMETRY tables should be
constructed in SQL, then registered with 'sdelayer -o register'.

I strongly advise against using "-c '*'" -- it is best practice to always explicity list
your columns.

An entity type error indicates that your geometry actually contains entities not
supported by your layer. Native geometries may only contain one topology class
(point *or* line *or* polygon), and should be defined to allow nil geometries --
"np", "nsl+", "na+", respectively).

- V