kapayne@uga.edu

using wfst to insert data to sql server instance

Discussion created by kapayne@uga.edu on Sep 11, 2013
Hi, I have enabled a service for WFS-T editing. I deployed the service through ags10.1 sp1.  I have a script that is writing an insert statement to write data to a sql server instance.  The xml looks well formed but when I run the script I get this message:

http://servername/data contains 1 features to insert into http://WFST endpoint
<?xml version="1.0"?>
<wfs:Transaction version="1.0.0" handle="TX01" service="WFS"
xmlns="wfst endpoint"
xmlns:myns="wfst endpoint"
xmlns:gml="http://www.opengis.net/gml"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Insert handle="INSERT01">
<myns:NERAdmin_0 fid="2" xmlns:myns="wfst endpoint">
<myns:Name>*****</myns:Name>
<myns:Valid_on>2012-08-24T00:00:00.0Z</myns:Valid_on>
<myns:ReferenceName>*****</myns:ReferenceName>
<myns:pcode>NG</myns:pcode>
<myns:SHAPE><gml:Polygon xmlns:gml="http://www.opengis.net/gml"><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates>13.576869,13.95956 13.5784699,13.9526 13.5858899,13.9209 13.5906699,13.90206 13.59453,13.87954 13.6019299,13.8517399 13.61461,13.7959 13.6184499,13.77752 13.62082,13.7713199 WHOLE LOT MORE GML </gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon></myns:SHAPE>
</myns:NERAdmin_0>
</wfs:Insert>
</wfs:Transaction>

No features inserted. Here's what the WFS server returned:
<ows:ExceptionReport version='1.1.0' language='en' xmlns:ows='http://www.opengis.net/ows'><ows:Exception exceptionCode='NoApplicableCode'><ows:ExceptionText>Transaction request failed: import data changes operation failed.</ows:ExceptionText></ows:Exception></ows:ExceptionReport>
Done. Bye bye.


Does anyone have any suggestions on how I might troubleshoot this?
Thanks!

Outcomes