QGIS » QGIS Application

Not reproducable here. Please add more details.

the same #11744 ?

Per Engström wrote:

However, when using the Identify Feature tool on Oracle features QGIS hangs in a endless loop and the entire QGIS program window gets grayed/whitened (as shown in attached screen-dumps). QGIS has to be forced to quit. Happens every time we use the Identify Feature tool on Oracle-layers.

As said I can't reproduce that here, in other words identify works fine for me on oracle layers. There must be something special about your installation. Do you get any messages in the message log regarding Oracle?

I get the same Oracle Log Message in both QGIS 2.4.0.1 and 2.6.0 (2.6.0 reports in swedish).

Per Engström wrote:

I checked the message log viewed within QGIS and immediatly after loading the workspace/projektfile I have the following in the Message Log (Oracle Tab):

"No spatial index on column XXX_XXXX.XXX_VPOINT.SHAPE found - expect poor performance."

There is an identical message for each of the Oracle layers.

Are those views? Master should handle those better. Otherwise have you tried to create a spatial index (vector layer properties, general tab, create spatial index) ?

I cannot find any log that is time stamped at the hang event. When I use the Identify Feature tool QGIS hangs and I can not find any log entries regarding either Identify Feature or the crasch time stamp.

It isn't crashing, is it? It just takes ages to do the query - and that's probably because of the missing (or not detected) spatial index.

The Oracle Log Messages refers to Oracle Spatial layers containing water and sewage piping and valves, they are correctly projected on the map and I can view and search their attribute tables.

I have left it running as is for hours and nothing happens, it doesn't respond.

I tried to create Spatial Index as you proposed, it tried for a couple of seconds then presented an error message. Message Log (Oracle-tab) as follows:

"Creation spatial index failed.
SQL:CREATE INDEX QGIS_IDX_0000000001 ON "XXXXX_XXXXX"."XXX_XXXX_XXXX_VPOINT"("SHAPE") INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL
Error: ORA-01702: a view is not appropriate here
Kan inte köra uttryck"

("Kan inte köra uttryck" means "Can not run expression").

Could it be that I am using separate login credentials to the Oracle Server - view only login with QGIS and edit login with the proprietary AutoCAD Map 3D plugin?

Must I have write access to the Oracle server to create Spatial Index? Can the Spatial Indexing be done outside QGIS directly on the Oracle server?

Ok, nice work :) The master you are referring to, is it going to be released as 2.8.0? When will it be out?
Best Regards!
Per Engström

Per Engström wrote:

Ok, nice work :) The master you are referring to, is it going to be released as 2.8.0? When will it be out?
Best Regards!
Per Engström

2.8.0 is planned for 20.02.2015 (see release schedule). But you can verify right now using a nightly build or a weekly snapshot (links in the section following the release schedule), if master actually solves the problem for you.

Per Engström wrote:

Hello again! I have now tested with Master f00db95 (2.7.0) and it seems to be no difference, the program hangs after the Identify Feature tool have been used. Nothing happened for several minutes so I took a screen-shot to describe the process, planning to leave it running over the weekend.

No need - if you see "expect poor performance" there will be poor performance. Does the problem also occur when you use the geometry table instead of the view?

Please run the following query in sqlplus and report what it produces:

SELECT shape FROM vab_view_mapx_vline WHERE sdo_filter(shape,mdsys.sdo_geometry(2003,NULL,NULL,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(1,1,-1,-1)))='TRUE';