topic Can't Identify on a spatial view in Geodatabase Questions

Can't Identify on a spatial view

MichaelGinzburg — Mon, 08 Jul 2019 14:57:09 GMT

Hello,

I created a spatial view by joining a layer and a view.

For some reason I cannot Identify features and select them on the map.

However:

I can see the features on the map (e.g. geometry is joined)

I can open attribute table and see the whole data (e.g. it's business data is joined)

I can correctly zoom to a feature from the attribute table (e.g. geometry is correctly connected to the business data)

I even can get the Identify tool from the attribute table.

But I cannot get it from the map.

What is the problem?

ArcGIS 9.3 SDE on Oracle.

ArcGIS 9.3 Desktop

I know, that there tools are history, but some of my clients insist on continuing to use them....

Thanks in advance!

Re: Can't Identify on a spatial view

Anonymous User — Mon, 08 Jul 2019 17:04:12 GMT

Make sure you added an OBJECTID field yo the view definition.

Jesús de Diego

Re: Can't Identify on a spatial view

Asrujit_SenGupta — Tue, 09 Jul 2019 04:23:10 GMT

Identify Fails w/ Oracle Database Views

is Extproc configured for that Oracle geodatabase?

Configure the Oracle extproc to access the geodatabase with SQL—Help | ArcGIS Desktop (10.3 link)

Re: Can't Identify on a spatial view

MichaelGinzburg — Wed, 10 Jul 2019 15:47:38 GMT

Hello, I have an update. I put my attention that part of spatial views are OK and part not.

Then I discovered that working views are without spatial index.

So I removed spatial index from the layer and got back Identify and Select on the spatial view.

I don't know what is the source of this behaviour. If I recreate the spatial index, the failure returns...

Re: Can't Identify on a spatial view

George_Thompson — Thu, 11 Jul 2019 16:52:49 GMT

Is your Extproc configured correctly?

If you run the following SQL in the Oracle DB as the SDE user, what are the results?

select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;

Re: Can't Identify on a spatial view

MichaelGinzburg — Sun, 19 Jan 2020 15:03:58 GMT

Hello,

Indeed, there was a problem with EXTPROC, but now it's fixed. The check of select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual is OK.

However, I still can't identify a spatially indexed view...

Thanks!

Re: Can't Identify on a spatial view

George_Thompson — Tue, 21 Jan 2020 16:25:46 GMT

Is the view fairly complex or go across 2 databases?

What is the spatial information on the view?

What is you create a simple view "select * from ......" does that work for the identify?

Re: Can't Identify on a spatial view

MichaelGinzburg — Wed, 22 Jan 2020 08:40:08 GMT

Hello George,

Regarding fixing EXTRPOC: after I fixed the EXTRPOC, the SOE which updates the layers stopped work.

Disabling EXTPROC in tnsnames/listenet/extproc of Oracle has brought SOE functionality back.

To my knowledge of the product, it should be totally opposite: the SOE should not work until the EXTRPOC is fixed...

Thanks!

Re: Can't Identify on a spatial view

George_Thompson — Wed, 22 Jan 2020 12:33:10 GMT

I am not sure, I did notice in the original post that you are using a very old version of the Enterprise Geodatabase and Desktop (9.3). I would say to contact technical support and work with them, but that version has not been supported for many years.

If you can upgrade the desktop and enterprise geodatabase to a supported version, you should be able to reach out to support.

I would also agree that the EXTPROC should not have any impact on the SOE, but I am not 100% on that.

Re: Can't Identify on a spatial view

MichaelGinzburg — Thu, 26 Mar 2020 17:32:12 GMT

I tried to create a simply view, only OBJECTID and Shape fields - still no results.

The Geodatabase is ST_Geometry.

Re: Can't Identify on a spatial view

MichaelGinzburg — Sun, 26 Apr 2020 15:25:39 GMT

Hello George.

I tried to create a simply view, only OBJECTID and Shape fields - still no results.

The Geodatabase is ST_Geometry.

Re: Can't Identify on a spatial view

George_Thompson — Mon, 27 Apr 2020 11:20:04 GMT

At this point, I would recommend upgrading to a supported version of the Enterprise Geodatabase and then retest. If that does not work, I would connect Esri technical support.

Re: Can't Identify on a spatial view

MichaelGinzburg — Sun, 20 Dec 2020 14:27:13 GMT

Hello again,

Thanks to everybody who participated.

I rebuilt the DB server. Now I have no problem with spatial indices. Nor with identify.

I have problem with selection. I can't select from spatial view. Getting no results.

What can be the problem?

Still on 9.3.1.

Thanks!