Mapserver 4.10.2 does not seem to correctly format requests to Oracle when using WMS time support.
This server was built from source and is running on RHEL 4. Oracle is 10.1.0.5.0, The layer definition includes the line:
"wms_timeitem" "hurr_date"
which refers to an Oracle DATE column. The error returned is:
msDrawMap(): Image handling error. Failed to draw layer named 'Hurricanes'.
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-01861: literal does not match format string
. Query statement: SELECT OBJECTID, SHAPE FROM HYDRO.HURRICANES_TSQP WHERE (hurr_date >= '2004-01-01' AND hurr_date <= '2004-12-31') AND SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, 8307, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180,-90,180,90) ),'querytype=window') = 'TRUE' . Check your data statement.
Similar layer works fine w/ Postgis or shapefile data. Seems to be an Oracle-specific time formatting problem: e.g.
hurr_date >= (date '2004-01-01')
Reporter: jccartwright Date: 2007/07/01 - 20:38 Hello,
Mapserver 4.10.2 does not seem to correctly format requests to Oracle when using WMS time support.
This server was built from source and is running on RHEL 4. Oracle is 10.1.0.5.0, The layer definition includes the line: "wms_timeitem" "hurr_date" which refers to an Oracle DATE column. The error returned is:
msDrawMap(): Image handling error. Failed to draw layer named 'Hurricanes'. msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-01861: literal does not match format string . Query statement: SELECT OBJECTID, SHAPE FROM HYDRO.HURRICANES_TSQP WHERE (hurr_date >= '2004-01-01' AND hurr_date <= '2004-12-31') AND SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, 8307, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180,-90,180,90) ),'querytype=window') = 'TRUE' . Check your data statement.
Similar layer works fine w/ Postgis or shapefile data. Seems to be an Oracle-specific time formatting problem: e.g. hurr_date >= (date '2004-01-01')
Thanks!
-- john