nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can't Identify on a spatial view

MichaelGinzburg

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!

Find more posts tagged with

Accepted answers

All comments

Anonymous User

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

Jesús de Diego

Asrujit_SenGupta

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)

MichaelGinzburg

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...

George_Thompson

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;

MichaelGinzburg

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!

George_Thompson

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?

MichaelGinzburg

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!

George_Thompson

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.

MichaelGinzburg

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

The Geodatabase is ST_Geometry.

MichaelGinzburg

Hello George.

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

The Geodatabase is ST_Geometry.

George_Thompson

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.

MichaelGinzburg

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!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.