[Geoserver-devel] CITE tc42.4

Hi Andrea and Justin,

I have encountered an additional error on CITE testing that had passed on Justin’s automated CITE vs my.

ERROR: operator does not exist: timestamp with time zone ~~ unknown

Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Position: 94</ows:ExceptionText>

</ows:Exception>

</ows:ExceptionReport>

It seem to be the same bug as logged by Andrea. Which version of postgis are you using Justin?

http://jira.codehaus.org/browse/GEOS-1854

I am using postgis 8.4

Below is the full error log

Test wfs:wfs-1.1.0-Basic-GetFeature-tc42.4 (s0009/d1e32742_1/d1e717_1/d1e24448_1/d1e15408_1)

Assertion: Correctly evaluate the PropertyIsLike predicate expressed by a valid ogc:PropertyIsLike element.

Request d1e23248_1:
   Method: post
   URL: http://localhost:8080/geoserver/wfs
   Body: 
<wfs:GetFeature xmlns="http://www.occamlab.com/ctl" xmlns:ctl="http://www.occamlab.com/ctl"
                xmlns:gml="http://www.opengis.net/gml"
                xmlns:myparsers="http://teamengine.sourceforge.net/parsers"
                xmlns:ogc="http://www.opengis.net/ogc"
                xmlns:ows="http://www.opengis.net/ows"
                xmlns:p="http://teamengine.sourceforge.net/parsers"
                xmlns:parsers="http://www.occamlab.com/te/parsers"
                xmlns:saxon="http://saxon.sf.net/"
                xmlns:sf="http://cite.opengeospatial.org/gmlsf"
                xmlns:te="http://www.occamlab.com/te"
                xmlns:tec="java:com.occamlab.te.TECore"
                xmlns:wfs="http://www.opengis.net/wfs"
                xmlns:xi="http://www.w3.org/2001/XInclude"
                xmlns:xlink="http://www.w3.org/1999/xlink"
                xmlns:xs="http://www.w3.org/2001/XMLSchema"
                xmlns:xsd="http://www.w3.org/2001/XMLSchema"
                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                service="WFS"
                version="1.1.0">
   <wfs:Query srsName="urn:x-ogc:def:crs:EPSG:4326" typeName="sf:PrimitiveGeoFeature">
      <ogc:Filter>
         <ogc:PropertyIsLike escapeChar="\" singleChar="?" wildCard="*">
            <ogc:PropertyName>sf:dateProperty</ogc:PropertyName>
            <ogc:Literal>20*-10-??</ogc:Literal>
         </ogc:PropertyIsLike>
      </ogc:Filter>
   </wfs:Query>
</wfs:GetFeature>
   Response from parser p:XMLValidatingParser.GMLSF1:
      <ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows"
                     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                     version="1.0.0"
                     xsi:schemaLocation="http://www.opengis.net/ows http://localhost:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd">
  <ows:Exception exceptionCode="NoApplicableCode">
      <ows:ExceptionText>java.lang.RuntimeException: java.io.IOException
java.io.IOException
null
ERROR: operator does not exist: timestamp with time zone ~~ unknown
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 94</ows:ExceptionText>
  </ows:Exception>
</ows:ExceptionReport>

Message d1e23297_1:
   FAILURE: Empty response

Result: Failed

Victor Tey

Software Engineer
ASRDC
CSIRO Earth Science and Resource Engineering

Phone: cid:image001.gif@anonymised.comcid:image002.gif@anonymised.comcid:image003.gif@anonymised.comcid:image003.gif@anonymised.comcid:image004.gif@anonymised.comcid:image003.gif@anonymised.comcid:image003.gif@anonymised.comcid:image003.gif@anonymised.comcid:image003.gif@anonymised.comcid:image003.gif@anonymised.comcid:image003.gif@anonymised.comcid:image003.gif@anonymised.com+61 8 6436 8944
Victor.Tey@anonymised.com | www.csiro.au |
Address: Australian Resources Research Centre, 26 Dick Perry Avenue, Kensington WA 6151

PLEASE NOTE
The information contained in this email may be confidential or privileged. Any unauthorised use or disclosure is prohibited. If you have received this email in error, please delete it immediately and notify the sender by return email. Thank you. To the extent permitted by law, CSIRO does not represent, warrant and/or guarantee that the integrity of this communication has been maintained or that the communication is free of errors, virus, interception or interference.

Please consider the environment before printing this email.

Afaik this is a known issue with versions of postgres of 8.4 and up. That build server is actually running quite an older version of postgres (8.1) which is why it passes.

While it would be great to squash this issue once and for all I don't think I would let it hold you up.

@Andrea: I believe we discussed how to squash this one before but I can't remember what we came up with.

On 10-05-18 3:30 AM, Victor.Tey@anonymised.com wrote:

Hi Andrea and Justin,

I have encountered an additional error on CITE testing that had passed
on Justin’s automated CITE vs my.

ERROR: operator does not exist: timestamp with time zone ~~ unknown

Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.

Position: 94</ows:ExceptionText>

</ows:Exception>

</ows:ExceptionReport>

It seem to be the same bug as logged by Andrea. Which version of postgis
are you using Justin?

http://jira.codehaus.org/browse/GEOS-1854

I am using postgis 8.4

Below is the full error log

Test wfs:wfs-1.1.0-Basic-GetFeature-tc42.4 (s0009/d1e32742_1/d1e717_1/d1e24448_1/d1e15408_1)

Assertion: Correctly evaluate the PropertyIsLike predicate expressed by a valid ogc:PropertyIsLike element.

Request d1e23248_1:

      Method: post

      URL: http://localhost:8080/geoserver/wfs

      Body:

<wfs:GetFeature xmlns="http://www.occamlab.com/ctl&quot; xmlns:ctl="http://www.occamlab.com/ctl&quot;

                                xmlns:gml="http://www.opengis.net/gml&quot;

                                xmlns:myparsers="http://teamengine.sourceforge.net/parsers&quot;

                                xmlns:ogc="http://www.opengis.net/ogc&quot;

                                xmlns:ows="http://www.opengis.net/ows&quot;

                                xmlns:p="http://teamengine.sourceforge.net/parsers&quot;

                                xmlns:parsers="http://www.occamlab.com/te/parsers&quot;

                                xmlns:saxon="http://saxon.sf.net/&quot;

                                xmlns:sf="http://cite.opengeospatial.org/gmlsf&quot;

                                xmlns:te="http://www.occamlab.com/te&quot;

                                xmlns:tec="java:com.occamlab.te.TECore"

                                xmlns:wfs="http://www.opengis.net/wfs&quot;

                                xmlns:xi="http://www.w3.org/2001/XInclude&quot;

                                xmlns:xlink="http://www.w3.org/1999/xlink&quot;

                                xmlns:xs="http://www.w3.org/2001/XMLSchema&quot;

                                xmlns:xsd="http://www.w3.org/2001/XMLSchema&quot;

                                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;

                                service="WFS"

                                version="1.1.0">

      <wfs:Query srsName="urn:x-ogc:def:crs:EPSG:4326" typeName="sf:PrimitiveGeoFeature">

            <ogc:Filter>

                  <ogc:PropertyIsLike escapeChar="\" singleChar="?" wildCard="*">

                        <ogc:PropertyName>sf:dateProperty</ogc:PropertyName>

                        <ogc:Literal>20*-10-??</ogc:Literal>

                  </ogc:PropertyIsLike>

            </ogc:Filter>

      </wfs:Query>

</wfs:GetFeature>

      Response from parser p:XMLValidatingParser.GMLSF1:

            <ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows&quot;

                                          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;

                                          version="1.0.0"

                                          xsi:schemaLocation="http://www.opengis.net/ows http://localhost:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd&quot;&gt;

    <ows:Exception exceptionCode="NoApplicableCode">

            <ows:ExceptionText>java.lang.RuntimeException: java.io.IOException

java.io.IOException

null

ERROR: operator does not exist: timestamp with time zone ~~ unknown

    Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.

    Position: 94</ows:ExceptionText>

    </ows:Exception>

</ows:ExceptionReport>

Message d1e23297_1:

      FAILURE: Empty response

Result: Failed

*Victor Tey *

Software Engineer
ASRDC
CSIRO Earth Science and Resource Engineering**

Phone:
cid:image001.gif@anonymised.com:image002.gif@anonymised.com:image003.gif@anonymised.com..:image003.gif@anonymised.com:image004.gif@anonymised.com:image003.gif@anonymised.com:image003.gif@anonymised.com:image003.gif@anonymised.com:image003.gif@anonymised.com:image003.gif@anonymised.com:image003.gif@anonymised.com:image003.gif@anonymised.com+61
8 6436 8944
Victor.Tey@anonymised.com <mailto:Victor.Tey@anonymised.com> *|* www.csiro.au
<http://www.csiro.au/&gt; *|*
Address: Australian Resources Research Centre, 26 Dick Perry Avenue,
Kensington WA 6151

*PLEASE NOTE*
The information contained in this email may be confidential or
privileged. Any unauthorised use or disclosure is prohibited. If you
have received this email in error, please delete it immediately and
notify the sender by return email. Thank you. To the extent permitted by
law, CSIRO does not represent, warrant and/or guarantee that the
integrity of this communication has been maintained or that the
communication is free of errors, virus, interception or interference.

*Please consider the environment before printing this email.*

------------------------------------------------------------------------------

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.