topic Re: Creating Database View Using ArcMap 10.1 GP Tool in Data Management Questions

Creating Database View Using ArcMap 10.1 GP Tool

IanEvans3 — Thu, 26 Feb 2015 16:14:20 GMT

Hi all,

Just wondering if someone can confirm behaviour with using the GP Tool within ArcMap 10.1 for creating a database view.

After running the GP tool, and it sucessfully running, I can now see the view within the SDE database connection. I can drag this into ArcMap, and see the data both spatially and the attribute table. However, if I try and interact with it spatially, such clicking on it with the identify tool then the identify tool does not return a result.

My questions are:

- Is this the expected behaviour?

- And if so, how do I fix this?

I have read other posts regarding regsitering it with SDE etc, but just want to check I am getting the right end of the stick before I ask our DBA to do anything for us.

Thanks in advance for any help!

Re: Creating Database View Using ArcMap 10.1 GP Tool

TinaMorgan1 — Thu, 26 Feb 2015 21:24:12 GMT

This is known issue. The work around to create views is to use the SDE Command line tools.

Re: Creating Database View Using ArcMap 10.1 GP Tool

AsrujitSengupta — Thu, 26 Feb 2015 21:30:14 GMT

Which database are you using (Oracle, SQL Server, ....)?

Also as Tina suggested, try creating the View using SDE Commandline tool (sdetable -o create_view) and then check the behaviour.

Re: Creating Database View Using ArcMap 10.1 GP Tool

VinceAngelo — Fri, 27 Feb 2015 01:58:48 GMT

Due to the extreme limitations of the interface (eliminating all JOIN clauses), 'sdetable -o create_view' should only be used when the geometry storage is SDEBINARY/SDELOB.

Best practice it to create the view elsewhere (as in the GP tool, or via SQL), then use 'sdelayer -o register' to make the view accessible as a simple feature class.

Note that registration will fail if the view does not have a unique, non-zero, positive 32-bit integer column on which to base a USER-set registered rowid column, or if more than one topology class is present (e.g., point and poly).

- V

Re: Creating Database View Using ArcMap 10.1 GP Tool

IanEvans3 — Fri, 27 Feb 2015 09:59:49 GMT

Great, thanks for the support.

I think the idea of us creating the view using the GP Tool and then registering it sounds like a sensible approach for us.

Thanks again everyone!