topic Re: Can't select on a spatial view in ArcGIS Enterprise Questions

Can't select on a spatial view

MichaelGinzburg — Sat, 23 Jan 2021 12:50:44 GMT

Hello,

I can't select on a spatial view.

Queryfunctionality always returns empty DataTable.

I can't select in ArcGIS Desktop but not in ArcGIS Server.

ArcGIS Server 9.3.1

ArcSDE 9.3.1

Thanks!

Re: Can't select on a spatial view

Bud — Tue, 26 Jan 2021 00:09:58 GMT

Is the view registered with the geodatabase?

Can you tell us about the unique ID column? Is it 100% guaranteed to be unique? Is it based on a static column or is it generated/calculated?

In ArcGIS Desktop, if you open the attribute table, and navigate to the last record, are you able to select all records? (I'm just trying to get a sense of what's working and what isn't.)

I had similar issues. It happened after I made a change to the SQL of a registered view. In my case, I dropped the view and recreated it, and re-registered it. That seemed to fix my selection issues.

Re: Can't select on a spatial view

DanPatterson — Sat, 23 Jan 2021 16:19:11 GMT

@VinceAngelo tagging here as well

Re: Can't select on a spatial view

MichaelGinzburg — Sat, 23 Jan 2021 18:05:02 GMT

The uniqueid column is objectid.

The view is not registered.

I did not alter anything, just created the view with sdetable command.

Thanks!

Re: Can't select on a spatial view

VinceAngelo — Sun, 24 Jan 2021 05:34:01 GMT

It's been ages since I last used 9.3.1, which has been out of support over seven years now
(it's so different from modern releases it might as well be a different product).

There isn't nearly enough information here to begin to speculate about what could be the problem. Among the details missing:

RDBMS in use (exact version)
Definitions of the tables involved in the query
The exact SQL to create the view
The exact parameters (except password) used in the sdetable commands
An indication of the cardinality of the joins
Example output
An indication of the uniqueness of the registered rowid column

Working with ancient software is a considerable risk to your organization. I recommend you migrate your data to a modern software stack (supported OS, DBMS, and application stack).

- V

Re: Can't select on a spatial view

MichaelGinzburg — Wed, 27 Jan 2021 11:39:35 GMT

Thanks Vince,

Oracle 11g

The sdetable command:

sdetable -o create_view -T BUILDING_GVIEW ^
-t "LYR_BUILDING, BUILDING_VIEW" ^
-c "LYR_BUILDING.OBJECTID,LYR_BUILDING.SHAPE,BUILDING_VIEW.*" ^
-w "LYR_BUILDING.BUILDING_CODE=BUILDING_VIEW.BUILDING_CODE" ^

The OBJECTID column is unique for a spatial view (building_gview).

The problem seems to occur in ADF only.

The problem is that it is the test environment. In the production environment everything works.

Re: Can't select on a spatial view

MichaelGinzburg — Thu, 28 Jan 2021 08:24:58 GMT

Some update: we have found that for some reason ADF considers one of the view fields to be not nullable despite it is defined as nullable in the view and source DB table.

As a workaround we excluded the field from the query and it started to select.

I still don't know if the same configuration works ok on the production.