[TinyOWS-dev] Error when inserting new feature with TinyOWS

Thu May 10 13:21:33 EST 2012

Hi,

Thanks for your answer. Yes the fid is of type autoincrement (serial, in PostGIS). At least this should be enough for PostgreSQL since it has as default value nextval of fid

> From: Jukka.Rahkonen at mmmtike.fi
> To: tinyows-dev at lists.maptools.org
> Date: Thu, 10 May 2012 18:17:01 +0000
> Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> 
> Hi,
> 
> I have never done that myself so I am mainly guessing. Generating new fids is probably possible only if fid is of type autoincrement. Is is so in your tables?
> 
> -Jukka Rahkonen-
> 
> Ermond Parllaku wrote:
> 
> 
> > It is looking like a monologue to me, but I still have hopes that I will find or get a solution for my issue, since I am having deadlines too...
> 
> > Anyway from what I have been reading about similar issues to mine, it looks like I have troubles in configuring the config.xml within tinyows.
> 
> > <tinyows online_resource="http://localhost:81/cgi-bin/tinyows.exe"
> > schema_dir="C:/ms4w/apps/tinyows/schema/"
> > log="C:/ms4w/apps/tinyows/tinyows.log"
> > log_level="15">
> > <pg host="127.0.0.1" user="postgres" password="***" dbname="olives_gis1" port="5432"/>
> > <metadata name="Olives WFST Server"
> > title="WFST Olives" />
> >
> > <layer retrievable="1"
> > writable="1"
> > ns_prefix="tows"
> > ns_uri="http://127.0.0.1/"
> > //srid="EPSG:32634"
> > name="olives"
> > title="olives"/>
> > </tinyows>
> 
> I made in postgis another table which has only the fid (primary key) column and the geometry column, so that to make sure it is not an issue with the plain data. The name of the postgis table is olives2.
> 
> But I am still having the same error from the logs...
> 
> [ERROR] Element '{http://www.w3.org/2001/XMLSchema}import': Failed to locate a schema at location 'http://localhost:81/cgi-bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.0'. Skipping the import.
> 
> I also tried the wfs-t with QGIS so that to make sure it is not an issue with the configuration in client side, but still the same error, which is only in inserting. The update and delete work like a charm...
> 
> Now I am feeling too dummy and desperate since all the previous posts say that the error is in configuration, but the config.xml seems OK to me. The only thing I can think is that I have issues with the schemas defined in tinyows, although I have replaced them several times with other versions found in github and elsewhere in internet...
> 
> 
> 
> ________________________________
> From: erndal02 at hotmail.com
> To: tinyows-dev at lists.maptools.org
> Subject: RE: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> Date: Wed, 9 May 2012 21:35:30 +0200
> 
> By the way, I am using PostGIS 1.5.3 version, installed with PostgreSQL 9.1
> 
> The 2.0.0. version of PostGIS I read that it officially came out on May 2012. I don't think I need to upgrade the version of PostGIS, but may it be this the case of my errors?
> 
> ________________________________
> From: erndal02 at hotmail.com
> To: tinyows-dev at lists.maptools.org
> Date: Wed, 9 May 2012 21:03:00 +0200
> Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> 
> Hi,
> 
> I made another try, by adding this statement in config.xml:
> check_schema="0"
> so that to avoid the schema validation.
> 
> Now, another weird thing seems to be happening, taken from the log file of tinyows:
> 1. [Wed May 09 20:53:28 2012] [SQL] BEGIN;
> 2. [Wed May 09 20:53:28 2012] [SQL] SELECT nextval('public.olives_fid_seq');
> 3. [Wed May 09 20:53:28 2012] [SQL] SELECT ST_GeomFromGML('<gml:MultiPolygon xmlns:gml="http://www.opengis.net/gml" xmlns:feature="http://127.0.0.1:81/" xmlns:wfs="http://www.opengis.net/wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" srsName="EPSG:32634"><gml:polygonMember><gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates decimal="." cs="," ts=" ">380328.125,4508968.75 380375,4508500 381250,4509093.75 381046.875,4509328.125 380328.125,4508968.75</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon></gml:polygonMember></gml:MultiPolygon>')
> 4. [Wed May 09 20:53:28 2012] [SQL] SELECT ST_IsValid('01060000207A7F0000010000000103000000010000000500000000000080A0361741000000304A335141000000005C37174100000000D53251410000000008451741000000706933514100000080DB41174100000008A433514100000080A0361741000000304A335141')
> 5. [Wed May 09 20:53:28 2012] [SQL]
> 6. [Wed May 09 20:53:28 2012] [SQL] ROLLBACK;
> 
> If I try to insert directly the geometry as it is in row 3 of the log file, from postGIS, the feature is inserted in the database. So it looks like the geometry is OK. But I just cannot understand the row 5, why should it be empty, and also the row number 6 which just say "rollback". Meanwhile, if I run the query in row 4 in postgis, the result is true, which means the geometry is valid
> 
> The most important thing is that I still cannot add a feature from tinyows...
> 
> I would appreciate a lot some help on this issue...
> 
> Thanks
> 
> ________________________________
> From: erndal02 at hotmail.com
> To: tinyows-dev at lists.maptools.org
> Date: Wed, 9 May 2012 10:03:00 +0200
> Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> 
> Hi,
> 
> > You can't have success with WFS 1.1.0 because your geometry is in GML2
> > <gml:coordinates
> > However, you had some other problem too with the schema location. I can't say anything about that. Anyway, be sure to use GML2 with WFS 1.0.0 and GML3 with WFS 1.1.0.
> 
> Thanks for your answer. I wasn't sure if I could use the WFS 1.1.0, so now I am sure that I cannot.
> 
> Anyway I still have the same error, but I see in the log files one more error which says:
> [ERROR] Element '{http://www.w3.org/2001/XMLSchema}import': Failed to locate a schema at location 'http://localhost:81/cgi-bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.0'. Skipping the import.
> 
> If I try the URL in the browser it gives me the whole schema for the layer, and it's something like this:
> 
> <?xml version='1.0' encoding='UTF-8'?>
> <xs:schema targetNamespace='http://www.tinyows.org/' xmlns:tows='http://www.tinyows.org/' xmlns:ogc='http://www.opengis.net/ogc' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns='http://www.w3.org/2001/XMLSchema' xmlns:gml='http://www.opengis.net/gml' elementFormDefault='qualified' version='1.0'>
> <xs:import namespace='http://www.opengis.net/gml' schemaLocation='http://schemas.opengis.net/gml/2.1.2/feature.xsd'/>
> <xs:element name='olives' type='tows:olivesType' substitutionGroup='gml:_Feature' />
> <xs:complexType name='olivesType'>
>  <xs:complexContent>
>   <xs:extension base='gml:AbstractFeatureType'>
>    <xs:sequence>
>     <xs:element name ='rrethid' type='int' nillable='true' minOccurs='0' maxOccurs='1'/>
>     ......
>     ......
>    </xs:sequence>
>   </xs:extension>
>  </xs:complexContent>
> </xs:complexType>
> </xs:schema>
> 
> 
> I think the error should be somewhere in the schema folder within tinyows folder that I have (but not sure at all). Anyway if someone could tell me where to get the latest schema folder version of TinyOWS, I can try to replace them, and see if the error is there.
> 
> Also, if the error is at the schema, why shouldn't if fire also when editing/deleting a feature?
> 
> Thanks
> 
> > From: Jukka.Rahkonen at mmmtike.fi
> > To: tinyows-dev at lists.maptools.org
> > Date: Tue, 8 May 2012 19:34:43 +0000
> > Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> >
> > Hi,
> >
> > You can't have success with WFS 1.1.0 because your geometry is in GML2
> > <gml:coordinates
> > However, you had some other problem too with the schema location. I can't say anything about that. Anyway, be sure to use GML2 with WFS 1.0.0 and GML3 with WFS 1.1.0.
> >
> > -Jukka Rahkonen-
> >
> > Ermond Parllaku wrote:
> >
> > > Hi to all,
> >
> > > I configured a layer with TinyOWS and MS4W in Windows. I have other layers in the map viewer too, configured with OpenLayers, but the layer that I configured with TinyOWS is supposed to be editable. Anyway, I can edit and delete features from the layer. But unfortunately I haven't managed yet to insert new features.
> >
> > In the log of TinyOWS, when I try to insert a new feature, I keep getting an error:
> >
> > [ERROR] Element '{http://www.tinyows.org/}olives': This element is not expected. Expected is one of ( {http://www.opengis.net/gml}_Feature, {http://www.opengis.net/wfs}FeatureCollection )
> >
> > Just before the error, in the log file I see this query:
> > <wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/WFS-transaction.xsd">
> > <wfs:Insert>
> > <feature:olives xmlns:feature="http://www.tinyows.org/">
> > <feature:geometry>
> > <gml:MultiPolygon xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:32634">
> > <gml:polygonMember>
> > <gml:Polygon>
> > <gml:outerBoundaryIs>
> > <gml:LinearRing>
> > <gml:coordinates decimal="." cs="," ts=" ">381781.25,4509578.125 381875,4509031.25 382656.25,4509734.375 381781.25,4509578.125</gml:coordinates>
> > </gml:LinearRing>
> > </gml:outerBoundaryIs>
> > </gml:Polygon>
> > </gml:polygonMember>
> > </gml:MultiPolygon>
> > </feature:geometry>
> > </feature:olives>
> > </wfs:Insert>
> > </wfs:Transaction>
> >
> >
> > The config.xml is like this:
> > <tinyows online_resource="http://localhost:81/cgi-bin/tinyows.exe"
> > schema_dir="C:/ms4w/apps/tinyows/schema/"
> > log="C:/ms4w/apps/tinyows/tinyows.log"
> > log_level="15">
> > <pg host="127.0.0.1" user="postgres" password="***" dbname="olives_gis1" port="5432"/>
> > <metadata name="Olives WFST Server"
> > title="WFST Olives" />
> >
> > <layer retrievable="1"
> > writable="1"
> > ns_prefix="tows"
> > ns_uri="http://www.tinyows.org/"
> > //srid="EPSG:32634"
> > name="olives"
> > title="olives"/>
> > </tinyows>
> >
> > I thought the error might happen because in the database the geometry of the table olives is declared as POLYGON, so I changed it to MULTIPOLYGON, but I still got the same error. I also changed the WFS schema to 1.0.0, but still the same error.
> >
> > I have declared a DrawFeature variable like this, to draw the feature that will be saved in the database:
> >
> > var draw = new OpenLayers.Control.DrawFeature(
> > wfs, OpenLayers.Handler.Polygon,
> > {
> > title: "Add olives",
> > displayClass: "olControlDrawFeaturePolygon",
> > multi: "true",
> > id: "draw"
> > }
> > );
> >
> >
> > I would like to mention again that the editing and deleting of existing features work very well.
> >
> > I am using MS4W 3.0.4 (with OL included) and tinyows-1.0.0rc3. The database is in PostgreSQL & PostGIS.
> >
> > Since I don't have much experience with these technologies (more than 1 month) I might have made some stupid error, but I cannot find it anyway...
> >
> > Thanks a lot in advance for your help
> > _______________________________________________
> > TinyOWS-dev mailing list
> > TinyOWS-dev at lists.maptools.org
> > http://lists.maptools.org/mailman/listinfo/tinyows-dev
> 
> _______________________________________________ TinyOWS-dev mailing list TinyOWS-dev at lists.maptools.org http://lists.maptools.org/mailman/listinfo/tinyows-dev
> 
> _______________________________________________ TinyOWS-dev mailing list TinyOWS-dev at lists.maptools.org http://lists.maptools.org/mailman/listinfo/tinyows-dev
> _______________________________________________
> TinyOWS-dev mailing list
> TinyOWS-dev at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-dev/attachments/20120510/584edde1/attachment.htm 