Rich,

Have you tried MapServer 6?

It might be the null srid. I know there was some work done around that time 
(although I thought it was earlier).

If you send me the layer definition in question and the WFS request, I can try 
it with the current and some other versions.

Mike

--
Michael Smith
US Army Corps
Remote Sensing GIS/Center

From: Richard Suematsu 
<richard.suema...@syncadd.com<mailto:richard.suema...@syncadd.com>>
Date: Fri, 23 Dec 2011 14:19:23 -1000
To: <mapserver-users@lists.osgeo.org<mailto:mapserver-users@lists.osgeo.org>>
Subject: [mapserver-users] ORA-00932: inconsistent datatypes: expected %s got %s

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@orcl
msOracleSpatialLayerClose. Cleaning layerinfo handlers.
msOracleSpatialLayerClose. Release the Oracle Pool.
msConnPoolRelease(BuildingXXX,maps/maps@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.
_______________________________________________ mapserver-users mailing list 
mapserver-users@lists.osgeo.org<mailto:mapserver-users@lists.osgeo.org> 
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to