[mapserver-users] ORA-00932: inconsistent datatypes: expected %s got %s

[Richard Suematsu]

ORA-00932: inconsistent datatypes: expected %s got %s
 
Ok, I've been banging my head against this one for a while.  I'm getting this error on MapServer 5.6.7 on a WFS request.  WMS requests seem to work fine on the same layer.  This exact same file works fine on 5.6.0_Beta2.  I have no other BLOB/CLOB columns laying around.  I've tried running the sql (see log below) from the sqlplus and it works fine.  Any ideas?  Thanks.
 
My WFS Request is simple:
 
<?xml version="1.0"?>
<wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs" xmlns:ogc="http://www.opengis.net/ogc" service="WFS" version="1.0.0">
  <wfs:Query typeName="BuildingXXX">
                <ogc:Filter>
                  <ogc:OR>
                                <ogc:PropertyIsEqualTo>
                                  <ogc:PropertyName>XXXID</ogc:PropertyName>
                                  <ogc:Literal>3047</ogc:Literal>
                                </ogc:PropertyIsEqualTo>
                                <ogc:PropertyIsEqualTo>
                                  <ogc:PropertyName>XXXID</ogc:PropertyName>
                                  <ogc:Literal>3257</ogc:Literal>
                                </ogc:PropertyIsEqualTo>
                                <ogc:PropertyIsEqualTo>
                                  <ogc:PropertyName>XXXID</ogc:PropertyName>
                                  <ogc:Literal>2362</ogc:Literal>
                                </ogc:PropertyIsEqualTo>
                  </ogc:OR>
                </ogc:Filter>
  </wfs:Query>
</wfs:GetFeature>
 
 
msOracleSpatialLayerGetExtent. Using this Sql to retrieve the extent: SELECT SDO_GEOM.SDO_CONVEXHULL(shape, 0.001000) AS GEOM from (SELECT OBJECTID, BUILDNG_ID, STR_STAT_D, XXXID, shape FROM (select shape,OBJECTID,buildng_id,str_stat_d,XXXid from structure_existing_area) WHERE  XXXID > 0 and STR_STAT_D<>'DEMOLISHED' ).
msOracleSpatialLayerGetExtent(): OracleSpatial error. Error: ORA-00932: inconsistent datatypes: expected %s got %s
 . Query statement: SELECT SDO_GEOM.SDO_CONVEXHULL(shape, 0.001000) AS GEOM from (SELECT OBJECTID, BUILDNG_ID, STR_STAT_D, XXXID, shape FROM (select shape,OBJECTID,buildng_id,str_stat_d,XXXid from structure_existing_area) WHERE  XXXID > 0 and STR_STAT_D<>'DEMOLISHED' ) .Check your data statement.
msOracleSpatialLayerOpen called with: shape from (select shape,OBJECTID,buildng_id,str_stat_d,XXXid from structure_existing_area) using unique OBJECTID (Layer pointer 0000000001955030)
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerGetItems was called.
msOracleSpatialLayerGetItems(): Query error. Cannot retrieve column list
msOracleSpatialLayerOpen called with: shape from (select shape,OBJECTID,buildng_id,str_stat_d,XXXid from structure_existing_area) using unique OBJECTID (Layer pointer 0000000001955030)
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerGetItems was called.
msOracleSpatialLayerGetItems(): Query error. Cannot retrieve column list
msOracleSpatialLayerWhichShapes was called.
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT rownum, OBJECTID,shape FROM (select shape,OBJECTID,buildng_id,str_stat_d,XXXid from structure_existing_area) WHERE   ( ("XXXID"= 3047)  OR  ( ("XXXID"= 3257)  OR  ("XXXID"= 2362) ) )   AND SDO_FILTER( shape, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
msOracleSpatialLayerWhichShapes. Bind values: srid:-1   minx:523231.000000   miny:3895750.000000  maxx:536144.000000   maxy:3908174.000000 
msOracleSpatialLayerWhichShapes getting ordinate definition.
msOracleSpatialLayerWhichShapes converting to OCIColl.
msOracleSpatialLayerWhichShapes bind by name and object.
msOracleSpatialLayerWhichShapes name and object now bound.
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-00932: inconsistent datatypes: expected %s got %s
 . Query statement: SELECT rownum, OBJECTID,shape FROM (select shape,OBJECTID,buildng_id,str_stat_d,XXXid from structure_existing_area) WHERE   ( ("XXXID"= 3047)  OR  ( ("XXXID"= 3257)  OR  ("XXXID"= 2362) ) )   AND SDO_FILTER( shape, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE' . Check your data statement.
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerClose was called. Layer: 0000000001955030, Layer name: BuildingXXX. Layer connection: maps/maps at orcl
msOracleSpatialLayerClose. Cleaning layerinfo handlers.
msOracleSpatialLayerClose. Release the Oracle Pool.
msConnPoolRelease(BuildingXXX,maps/maps at orci,00000000019EB330)
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed
mapserv request processing time (msLoadMap not incl.): 0.094s
msFreeMap(): freeing map at 00000000019219F0.

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential and privileged information. Unauthorized
review, use, disclosure or distribution is prohibited. If you are not the addressee indicated in this
message kindly notify the sender by reply e-mail and destroy all copies of the original message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111223/8fdba9e2/attachment.htm>