topic Re: DBMS table not found (-37) - I tried to create a view in Data Management Questions

DBMS table not found (-37) - I tried to create a view

LaureanoRapoport — Wed, 29 Jan 2014 07:25:52 GMT

Hello,

I have a problem tried to create a view with ArcSDE.

I have a layer from an user on SDE instance, and a table from another instance, but i create a DBLINK to this instance and i create a SYNONIM.

When i do a sdetable -o describe from de table i see that from sde user, but when i tried to create the view:

sdetable -o create_view -T CVINCI -t INCIDENCIAS,GEVEXPED -c INCIDENCIAS.SHAPE,INCIDENCIAS.CODIGO,GEVEXPED.ESTADO -w "INCIDENCIAS.CODIGO=GEVEXPED.CODIGO" -s arcgis02 -u xxxxx -p xxxxxx

I recived the error:
DBMS table not found (-37)

I'm using ArcSDE 10.2, and a direct conection.

Any idea?

thanks.

Re: DBMS table not found (-37) - I tried to create a view

VinceAngelo — Wed, 29 Jan 2014 10:14:38 GMT

I seriously doubt that DDL in the form of a CREATE VIEW statement is going to honor synonyms. There's also a problem with using 'sdetable -o create_view' with anything other than SDEBINARY/SDELOB storage, which you probably shouldn't be using at 10.2. If the layer is using ST_GEOMETRY storage, the proper way to create a view is to use SQL to create the view, and the register the view with 'sdelayer -o register' (or use the ArcGIS equivalent). The command line tools will not be available post-10.2.x, so a new process will be necessary soon. - V