[Geoserver-users] wfs-t: transaction insert failed

GeoServer GeoServer User
1

Hi list,
again i tried to perform a transaction insert, but it failed with this exception message:

java.lang.RuntimeException: Parsing failed for Point: com.vividsolutions.jts.util.AssertionFailedException Parsing failed for Point: com.vividsolutions.jts.util.AssertionFailedException null

The request comes from a getFeature response which i took and wrapped with a wfs:Transaction and wfs:Insert with some changed data just to test the wfs-t interface. Here's the request: <?xml version="1.0" encoding="UTF-8"?>

<wfs:Transaction service=“WFS” version=“1.0.0” xmlns:wfs=“http://www.opengis.net/wfs” xmlns:ora=“http://umwelt.hessen.de/oracle” xmlns:sde=“http://umwelt.hessen.de/arcsde” xmlns:topp=“http://www.openplans.org/topp” xmlns:gml=“http://www.opengis.net/gml” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xsi:schemaLocation=“http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd”>

wfs:Insert
<ora:KA_KOM_EINL_SDO fid=“KA_KOM_EINL_SDO.nfm-756f8fbf_11ac937f759_-8000”>
ora:OBJECTID726</ora:OBJECTID>
ora:ABW_ANL_ID800000059</ora:ABW_ANL_ID>
ora:EXT_KA_NR07000000000-1</ora:EXT_KA_NR>
ora:KA_NAMEEntenhausen</ora:KA_NAME>
ora:KA_ZUSATZNAMEEntenhausen</ora:KA_ZUSATZNAME>
ora:BETREI_ID100001832</ora:BETREI_ID>
ora:BETREIBER_NAMETSV Entenhausen</ora:BETREIBER_NAME>
ora:BETREIBER_ANREDEDonal Duck</ora:BETREIBER_ANREDE>
ora:BETREIBER_ADRESSATDonald</ora:BETREIBER_ADRESSAT>
ora:EINLEITESTELLE_ID9000</ora:EINLEITESTELLE_ID>
ora:EINLEITESTELLE_BEZBla</ora:EINLEITESTELLE_BEZ>
ora:GEMARKGEntenhausen</ora:GEMARKG>
ora:RECHTSWERT3489186</ora:RECHTSWERT>
ora:HOCHWERT5473595</ora:HOCHWERT>
ora:TK25_KARTE6217</ora:TK25_KARTE>
ora:VERSICKERG_JNnein</ora:VERSICKERG_JN>
ora:GEWAE_NR239628</ora:GEWAE_NR>
ora:GEWAE_HAUPTNAMEFanggraben</ora:GEWAE_HAUPTNAME>
ora:GEWAE_EZG76.593</ora:GEWAE_EZG>
ora:WASSERKOERPERDEHE_239628.1</ora:WASSERKOERPER>
ora:MITTL_NIEDRWA_ABFL74</ora:MITTL_NIEDRWA_ABFL>
ora:ERLAUB_BEHOERDERP Walt Disney</ora:ERLAUB_BEHOERDE>
ora:RECHTL_AKTUELLja</ora:RECHTL_AKTUELL>
ora:ERLAUB_ID100026525</ora:ERLAUB_ID>
ora:LETZTE_ERLAUB_DAT2000-05-15</ora:LETZTE_ERLAUB_DAT>
ora:STAND2008-03-10</ora:STAND>
ora:SHAPE
<gml:Point srsName=“http://www.opengis.net/gml/srs/epsg.xml#31467”>
<gml:coordinates xmlns:gml=“http://www.opengis.net/gml” decimal=“.” cs=“,” ts=" ">3489186 5473595</gml:coordinates>

</gml:Point>
</ora:SHAPE>
</ora:KA_KOM_EINL_SDO>
</wfs:Insert>
</wfs:Transaction>

I’m using geoserver 1.6.3 with oracle backend. Does anyone know what the exception means?
Thanks
Albrecht

2

Albrecht.Weiser@anonymised.com ha scritto:

Hi list,
again i tried to perform a transaction insert, but it failed with this exception message:
<ServiceException>
      java.lang.RuntimeException: Parsing failed for Point: com.vividsolutions.jts.util.AssertionFailedException Parsing failed for Point: com.vividsolutions.jts.util.AssertionFailedException null

</ServiceException>

Hum, can you go to config/server, enable verbose exceptions,
try again, and report back the full error once more? This time
it should contain a stack trace.

Cheers
Andrea

3

Hi Albrecht,

Have you checked the coordinates element in the Point geometry? It says that cs="," which means that the x and y coordinate should be seperated by a comma, something like this (using the Point):

<gml:coordinates xmlns:gml="http://www.opengis.net/gml&quot; decimal="." cs="," ts=" ">3489186,5473595</gml:coordinates>

In your request the coordinates are seperated by a space character...

I haven't tried this myself, but maybe it helps...

Best regards,
Thijs

Albrecht.Weiser@anonymised.com schreef:

Hi list,
again i tried to perform a transaction insert, but it failed with this exception message:
<ServiceException>
      java.lang.RuntimeException: Parsing failed for Point: com.vividsolutions.jts.util.AssertionFailedException Parsing failed for Point: com.vividsolutions.jts.util.AssertionFailedException null

</ServiceException>
The request comes from a getFeature response which i took and wrapped with a wfs:Transaction and wfs:Insert with some changed data just to test the wfs-t interface. Here's the request:

<?xml version="1.0" encoding="UTF-8"?>
<wfs:Transaction service="WFS" version="1.0.0" xmlns:wfs="http://www.opengis.net/wfs&quot; xmlns:ora="http://umwelt.hessen.de/oracle&quot; xmlns:sde="http://umwelt.hessen.de/arcsde&quot; xmlns:topp="http://www.openplans.org/topp&quot; xmlns:gml="http://www.opengis.net/gml&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xsi:schemaLocation="http://www.opengis.net/wfs _http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd_&quot;&gt;

        <wfs:Insert>
                <ora:KA_KOM_EINL_SDO fid="KA_KOM_EINL_SDO.nfm-756f8fbf_11ac937f759_-8000">
                        <ora:OBJECTID>726</ora:OBJECTID>
                        <ora:ABW_ANL_ID>800000059</ora:ABW_ANL_ID>
                        <ora:EXT_KA_NR>07000000000-1</ora:EXT_KA_NR>
                        <ora:KA_NAME>Entenhausen</ora:KA_NAME>
                        <ora:KA_ZUSATZNAME>Entenhausen</ora:KA_ZUSATZNAME>
                        <ora:BETREI_ID>100001832</ora:BETREI_ID>
                        <ora:BETREIBER_NAME>TSV Entenhausen</ora:BETREIBER_NAME>
                        <ora:BETREIBER_ANREDE>Donal Duck</ora:BETREIBER_ANREDE>
                        <ora:BETREIBER_ADRESSAT>Donald</ora:BETREIBER_ADRESSAT>
                        <ora:EINLEITESTELLE_ID>9000</ora:EINLEITESTELLE_ID>
                        <ora:EINLEITESTELLE_BEZ>Bla</ora:EINLEITESTELLE_BEZ>
                        <ora:GEMARKG>Entenhausen</ora:GEMARKG>
                        <ora:RECHTSWERT>3489186</ora:RECHTSWERT>
                        <ora:HOCHWERT>5473595</ora:HOCHWERT>
                        <ora:TK25_KARTE>6217</ora:TK25_KARTE>
                        <ora:VERSICKERG_JN>nein</ora:VERSICKERG_JN>
                        <ora:GEWAE_NR>239628</ora:GEWAE_NR>
                        <ora:GEWAE_HAUPTNAME>Fanggraben</ora:GEWAE_HAUPTNAME>
                        <ora:GEWAE_EZG>76.593</ora:GEWAE_EZG>
                        <ora:WASSERKOERPER>DEHE_239628.1</ora:WASSERKOERPER>
                        <ora:MITTL_NIEDRWA_ABFL>74</ora:MITTL_NIEDRWA_ABFL>
                        <ora:ERLAUB_BEHOERDE>RP Walt Disney</ora:ERLAUB_BEHOERDE>
                        <ora:RECHTL_AKTUELL>ja</ora:RECHTL_AKTUELL>
                        <ora:ERLAUB_ID>100026525</ora:ERLAUB_ID>
                        <ora:LETZTE_ERLAUB_DAT>2000-05-15</ora:LETZTE_ERLAUB_DAT>
                        <ora:STAND>2008-03-10</ora:STAND>
                        <ora:SHAPE>
                                <gml:Point srsName="http://www.opengis.net/gml/srs/epsg.xml#31467&quot;&gt;
                                        <gml:coordinates xmlns:gml="http://www.opengis.net/gml&quot; decimal="." cs="," ts=" ">3489186 5473595</gml:coordinates>

                                </gml:Point>
                        </ora:SHAPE>
                </ora:KA_KOM_EINL_SDO>
        </wfs:Insert>
</wfs:Transaction>

I'm using geoserver 1.6.3 with oracle backend. Does anyone know what the exception means?
Thanks
Albrecht

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

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  
--
Met vriendelijke groeten,

Thijs Brentjens
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Brentjens Geo-ICT
Nieuwravenstraat 13
3522 RK Utrecht
tel.: +31 6 11 31 70 44
email: thijs@anonymised.com
http://www.brentjensgeoict.nl

KvK: 30228431 Kantoor Utrecht

4

Hi Thijs,
That was the problem. It should be comma separated. Now the request passes.
But now i get an oracle error (@Andrea):
"14 Jul 17:03:52 ERROR [data.oracle] - SQL Exception writing geometry column ORA-01861: literal does not match format string"
I assume, that oracle awaits another format of the geometry insertation - right? The name of the geometry column in the oracle db is SHAPE and its format is SDO_GEOMETRY. But the format should never mind, because the access to the database should be encapsulated through geoserver is that right?
Thanks :o)
Albrecht

-----Ursprüngliche Nachricht-----
Von: Thijs Brentjens [mailto:thijs@anonymised.com]
Gesendet: Montag, 14. Juli 2008 16:41
An: Weiser, Albrecht (HZD); geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] wfs-t: transaction insert failed

Hi Albrecht,

Have you checked the coordinates element in the Point
geometry? It says
that cs="," which means that the x and y coordinate should be
seperated
by a comma, something like this (using the Point):

<gml:coordinates xmlns:gml="http://www.opengis.net/gml&quot; decimal="."
cs="," ts=" ">3489186,5473595</gml:coordinates>

In your request the coordinates are seperated by a space character...

I haven't tried this myself, but maybe it helps...

Best regards,
Thijs

Albrecht.Weiser@anonymised.com schreef:
>
> Hi list,
> again i tried to perform a transaction insert, but it
failed with this
> exception message:
> <ServiceException>
> java.lang.RuntimeException: Parsing failed for Point:
> com.vividsolutions.jts.util.AssertionFailedException Parsing failed
> for Point: com.vividsolutions.jts.util.AssertionFailedException null
>
> </ServiceException>
> The request comes from a getFeature response which i took
and wrapped
> with a wfs:Transaction and wfs:Insert with some changed
data just to
> test the wfs-t interface. Here's the request:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <wfs:Transaction service="WFS" version="1.0.0"
> xmlns:wfs="http://www.opengis.net/wfs&quot;
> xmlns:ora="http://umwelt.hessen.de/oracle&quot;
> xmlns:sde="http://umwelt.hessen.de/arcsde&quot;
> xmlns:topp="http://www.openplans.org/topp&quot;
> xmlns:gml="http://www.opengis.net/gml&quot;
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;
> xsi:schemaLocation="http://www.opengis.net/wfs
> _http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd_&quot;&gt;
>
> <wfs:Insert>
> <ora:KA_KOM_EINL_SDO
> fid="KA_KOM_EINL_SDO.nfm-756f8fbf_11ac937f759_-8000">
> <ora:OBJECTID>726</ora:OBJECTID>
> <ora:ABW_ANL_ID>800000059</ora:ABW_ANL_ID>
> <ora:EXT_KA_NR>07000000000-1</ora:EXT_KA_NR>
> <ora:KA_NAME>Entenhausen</ora:KA_NAME>
>
> <ora:KA_ZUSATZNAME>Entenhausen</ora:KA_ZUSATZNAME>
> <ora:BETREI_ID>100001832</ora:BETREI_ID>
> <ora:BETREIBER_NAME>TSV
> Entenhausen</ora:BETREIBER_NAME>
> <ora:BETREIBER_ANREDE>Donal
> Duck</ora:BETREIBER_ANREDE>
>
> <ora:BETREIBER_ADRESSAT>Donald</ora:BETREIBER_ADRESSAT>
>
> <ora:EINLEITESTELLE_ID>9000</ora:EINLEITESTELLE_ID>
>
> <ora:EINLEITESTELLE_BEZ>Bla</ora:EINLEITESTELLE_BEZ>
> <ora:GEMARKG>Entenhausen</ora:GEMARKG>
> <ora:RECHTSWERT>3489186</ora:RECHTSWERT>
> <ora:HOCHWERT>5473595</ora:HOCHWERT>
> <ora:TK25_KARTE>6217</ora:TK25_KARTE>
> <ora:VERSICKERG_JN>nein</ora:VERSICKERG_JN>
> <ora:GEWAE_NR>239628</ora:GEWAE_NR>
>
> <ora:GEWAE_HAUPTNAME>Fanggraben</ora:GEWAE_HAUPTNAME>
> <ora:GEWAE_EZG>76.593</ora:GEWAE_EZG>
>
> <ora:WASSERKOERPER>DEHE_239628.1</ora:WASSERKOERPER>
>
> <ora:MITTL_NIEDRWA_ABFL>74</ora:MITTL_NIEDRWA_ABFL>
> <ora:ERLAUB_BEHOERDE>RP Walt
> Disney</ora:ERLAUB_BEHOERDE>
> <ora:RECHTL_AKTUELL>ja</ora:RECHTL_AKTUELL>
> <ora:ERLAUB_ID>100026525</ora:ERLAUB_ID>
>
> <ora:LETZTE_ERLAUB_DAT>2000-05-15</ora:LETZTE_ERLAUB_DAT>
> <ora:STAND>2008-03-10</ora:STAND>
> <ora:SHAPE>
> <gml:Point
> srsName="http://www.opengis.net/gml/srs/epsg.xml#31467&quot;&gt;
> <gml:coordinates
> xmlns:gml="http://www.opengis.net/gml&quot; decimal="." cs="," ts="
> ">3489186 5473595</gml:coordinates>
>
> </gml:Point>
> </ora:SHAPE>
> </ora:KA_KOM_EINL_SDO>
> </wfs:Insert>
> </wfs:Transaction>
>
> I'm using geoserver 1.6.3 with oracle backend. Does anyone
know what
> the exception means?
> Thanks
> Albrecht
>
>
>
>
--------------------------------------------------------------
----------
>
>
--------------------------------------------------------------
-----------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open
source project,
> along with a healthy diet, reduces your potential for
chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
>
--------------------------------------------------------------
----------
>
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>

--
Met vriendelijke groeten,

Thijs Brentjens
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Brentjens Geo-ICT
Nieuwravenstraat 13
3522 RK Utrecht
tel.: +31 6 11 31 70 44
email: thijs@anonymised.com
http://www.brentjensgeoict.nl

KvK: 30228431 Kantoor Utrecht

5

Albrecht.Weiser@anonymised.com ha scritto:

Hi Thijs, That was the problem. It should be comma separated. Now the
request passes. But now i get an oracle error (@Andrea): "14 Jul
17:03:52 ERROR [data.oracle] - SQL Exception writing geometry column
ORA-01861: literal does not match format string" I assume, that
oracle awaits another format of the geometry insertation - right? The
name of the geometry column in the oracle db is SHAPE and its format
is SDO_GEOMETRY. But the format should never mind, because the access
to the database should be encapsulated through geoserver is that
right? Thanks :o) Albrecht

I'm not an Oracle user, so that error does not ring a bell.
Don't you happen to have a full stack trace along with the SQL
string that was generated?

Cheers
Andrea

6

Hi Andrea,
i solved the problem. It was an interesting phenomen:
the data model of the featureType i wanted to insert the test-dataset contained a column which was of the type BLOB (a binary type as you surely know). That has firstly the effect that a DescribeFeatureType request (and GetFeatureType too) in geoserver doesn't list this attribute. Secondly the transaction request fails.

Here the in oracle existing data model:
-number
-varchar
-number
-varchar
-etc
-geometry
-blob

data model served from geoserver by transaction insert-request:
-number
-varchar
-number
-varchar
-etc
-geometry

The error message coming from oracle: "SQL Exception writing geometry column ORA-01861: Literal does not match format string".
I think oracle was awaiting another attribute in the list to insert (for the blob-column). When nothing else comes, it serves a wrong interpretation and throws this exception i assume.
I didn't need the blob column and after deleting it the transaction insert passed. But i'm afraid that means if i have a binary data-field in my table i cannot perform a wfs-transaction!?!
Best wishes

Albrecht

-----Ursprüngliche Nachricht-----
Von: Andrea Aime [mailto:aaime@anonymised.com]
Gesendet: Dienstag, 15. Juli 2008 13:07
An: Weiser, Albrecht (HZD)
Cc: thijs@anonymised.com; geoserver-users@lists.sourceforge.net
Betreff: Re: AW: [Geoserver-users] wfs-t: transaction insert failed

Albrecht.Weiser@anonymised.com ha scritto:
> Hi Thijs, That was the problem. It should be comma
separated. Now the
> request passes. But now i get an oracle error (@Andrea): "14 Jul
> 17:03:52 ERROR [data.oracle] - SQL Exception writing geometry column
> ORA-01861: literal does not match format string" I assume, that
> oracle awaits another format of the geometry insertation -
right? The
> name of the geometry column in the oracle db is SHAPE and its format
> is SDO_GEOMETRY. But the format should never mind, because
the access
> to the database should be encapsulated through geoserver is that
> right? Thanks :o) Albrecht

I'm not an Oracle user, so that error does not ring a bell.
Don't you happen to have a full stack trace along with the SQL
string that was generated?

Cheers
Andrea

7

Albrecht.Weiser@anonymised.com ha scritto:

Hi Andrea, i solved the problem. It was an interesting phenomen: the
data model of the featureType i wanted to insert the test-dataset
contained a column which was of the type BLOB (a binary type as you
surely know). That has firstly the effect that a DescribeFeatureType
request (and GetFeatureType too) in geoserver doesn't list this
attribute. Secondly the transaction request fails.

Here the in oracle existing data model: -number -varchar -number -varchar -etc -geometry -blob

data model served from geoserver by transaction insert-request: -number -varchar -number -varchar -etc -geometry

The error message coming from oracle: "SQL Exception writing geometry
column ORA-01861: Literal does not match format string". I think
oracle was awaiting another attribute in the list to insert (for the
blob-column). When nothing else comes, it serves a wrong
interpretation and throws this exception i assume. I didn't need the
blob column and after deleting it the transaction insert passed. But
i'm afraid that means if i have a binary data-field in my table i
cannot perform a wfs-transaction!?! Best wishes

Yes, correct. We don't support blob fields in any datastore backend.
Quite frankly, I don't even know if it's possible to encode a blob
in GML (jdeolive?).

Cheers
Andrea

8

  > Yes, correct. We don't support blob fields in any datastore backend.

Quite frankly, I don't even know if it's possible to encode a blob
in GML (jdeolive?).

Yeah i think it would be possible with the xml type "hexBinary" which is just supposed to represent a stream of bytes. The binding for it in geotools is implemented but not really tested. Plus I am not sure how many geotools datastores support blobs. As written the binding maps to byte.class.

-Justin

Cheers
Andrea

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,487ccc3d308007180515871!

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com