Bug report #11748

Oracle - Layer is not valid - won't open with both 3002 and 3006 geometries?

Added by Bryan Hall over 9 years ago. Updated about 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Data Provider/Oracle
Affected QGIS version:2.6.0 Regression?:No
Operating System:Windows 64 Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:19981

Description

I verified that all geometries in the table/col are valid. There are a small number of 3006 multiline geometries mixed in with the bulk of 3002 single line geometries, as well as null geometries. SQL trace shows the following is being executed:

SQL> SELECT srid FROM mdsys.all_sdo_geom_metadata WHERE owner='CVC' AND table_name='C_PATH_SEGMENT' AND column_name='GEOMETRY_L';

      SRID
----------
      8307

SQL> SELECT DISTINCT t."GEOMETRY_L".sdo_gtype FROM "CVC"."C_PATH_SEGMENT" t WHERE rownum<=2;

GEOMETRY_L.SDO_GTYPE
--------------------

                3002

SQL> SELECT DISTINCT t."GEOMETRY_L".SDO_GTYPE FROM "CVC"."C_PATH_SEGMENT" t WHERE NOT t."GEOMETRY_L" IS NULL;

GEOMETRY_L.SDO_GTYPE
--------------------
                3006
                3002

SQL> SELECT srid FROM mdsys.all_sdo_geom_metadata WHERE owner='CVC' AND table_name='C_PATH_SEGMENT' AND column_name='GEOMETRY_L';

      SRID
----------
      8307

SQL> SELECT DISTINCT t."GEOMETRY_L".sdo_gtype FROM "CVC"."C_PATH_SEGMENT" t WHERE rownum<=2;

GEOMETRY_L.SDO_GTYPE
--------------------

                3002

SQL> SELECT DISTINCT t."GEOMETRY_L".SDO_GTYPE FROM "CVC"."C_PATH_SEGMENT" t WHERE NOT t."GEOMETRY_L" IS NULL;

GEOMETRY_L.SDO_GTYPE
--------------------
                3006
                3002

History

#1 Updated by Jürgen Fischer almost 9 years ago

  • Category changed from Data Provider to Data Provider/Oracle

#2 Updated by Giovanni Manghi almost 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#3 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF