I encountered an error with mapserver and oracle after updating from mapserver 8.6 build from 29.1.2026 to mapserver 8.6 build from 27.4.2026.
I use the stable build (daily) from gisinternals.com
I think it has to do with this issue: #7463
(but I'm not sure, there is a second commit to oraclespatial.c in the timerange)
the original query from mapserver to the database was:
SELECT "ART", "LEITUNGSART", "STATUS", FID,rownum, GEOM FROM (select FID,GEOM,ART,LEITUNGSART,STATUS from FW_STRANG) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
after the update, the error logged is:
[Tue Apr 28 13:11:22 2026].628000 Error: ORA-00932: Inkonsistente Datentypen: %s erwartet, %s erhalten
. Query statement: SELECT btmp.*, ROWNUM FROM (SELECT "ART", "LEITUNGSART", "STATUS", FID,GEOM FROM (select FID,GEOM,ART,LEITUNGSART,STATUS from FW_STRANG) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE' ) btmp . Check your data statement.msOracleSpatialLayerWhichShapes()
[Tue Apr 28 13:11:22 2026].628000 msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data statement and server logs
btmp was introduced with the issue i mentioned.
the layer definition (i.e.) is as followed:
LAYER
NAME "FW_STRANG"
STATUS ON
METADATA
"wms_title" "Strang"
"wms_layer_group" "/leitung"
"wms_group_title" "Leitung"
END
TYPE LINE
CONNECTIONTYPE PLUGIN
PLUGIN "oracle"
CONNECTION "WAERME/XXX@tnsname"
PROCESSING "CLOSE_CONNECTION=DEFER"
DATA "GEOM from (select FID,GEOM,ART,LEITUNGSART,STATUS from FW_STRANG) USING UNIQUE FID SRID 25832"
EXTENT 366712 5906795 401562 5921118
MINSCALEDENOM 50
#MAXSCALEDENOM 5000
SIZEUNITS METERS
CLASS
NAME "Vorlauf Anschlussltg Planung"
#Display Model Expression ART = 1 AND LEITUNGSART = 2 AND STATUS = 3
EXPRESSION ((([ART] = 1) AND ([LEITUNGSART] = 2)) AND ([STATUS] = 3))
MINSCALEDENOM 50
MAXSCALEDENOM 5000
STYLE
WIDTH 0.12
COLOR "#FF00FFFF"
LINECAP ROUND
LINEJOIN MITER
PATTERN
0 0.24 0.12 0.24 0 0.24 0
END
END
END
... many classes more ...
END
I encountered an error with mapserver and oracle after updating from mapserver 8.6 build from 29.1.2026 to mapserver 8.6 build from 27.4.2026.
I use the stable build (daily) from gisinternals.com
I think it has to do with this issue: #7463
(but I'm not sure, there is a second commit to oraclespatial.c in the timerange)
the original query from mapserver to the database was:
SELECT "ART", "LEITUNGSART", "STATUS", FID,rownum, GEOM FROM (select FID,GEOM,ART,LEITUNGSART,STATUS from FW_STRANG) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'after the update, the error logged is:
btmp was introduced with the issue i mentioned.
the layer definition (i.e.) is as followed: