[QGIS-Developer] Loading WFS layers from GeoServer

[Paul Wittle]

Hi,

I was using the 32 bit version (don't ask) but I've just tried it in the 64bit version (although 3.10) with the network logger installed and the errors read:

java.lang.RuntimeException: Failed to get property: {http://www.opengis.net/wfs/2.0}boundedBy Failed to get property: {http://www.opengis.net/wfs/2.0}boundedBy java.io.IOExceptionCannot do natural order without a primary key, please add it or specify a manual sort over existing attributes

The datasource is GeoServer but GeoServer is connecting to a view in SQL Server where the first table in the view is a table with a primary key and spatial index.

However I don't really understand because requesting the data in the GeoServer layer preview works fine so I assume QGIS is asking something the layer preview does not?

Thanks,
Paul

-----Original Message-----
From: Richard Duivenvoorde <rdmailings at duif.net>
Sent: 27 November 2020 15:00
To: Paul Wittle <P.Wittle at dorsetcc.gov.uk>; qgis-developer at lists.osgeo.org
Subject: Re: [QGIS-Developer] Loading WFS layers from GeoServer

Hi Paul,

QGIS 3.16 (well, since ... I don not know exactly) has s NetworkLogger/Debugger.
If you hit the F12 button, you will see all WFS-requests that QGIS is firing to the server.
You can 'replay' these in a browser, and see if it returns valid GML (as in: save it to disk and then try to open it as vector data).
Normally QGIS starts with a GetCapabilities request, then a DescribeLayer and then a GetFeature. You need that last one.
In the Network Debugging window you can also see if the server maybe returns an error code (as: not 200).

Does the Geoserver-layer preview work? As in can you see the layers there?

Normally WFS/WMS from Geoserver play pretty well together with QGIS.
Is there something special to the data? (curves, nonvalid geometries, ???)

Regards,

Richard Duivenvoorde



On 11/27/20 3:48 PM, Paul Wittle wrote:
> Hi,
>
>
>
> So the WFS layers do now return correctly from GeoServer in both WMS and all WFS formats and I’ve improved various indexes.
>
>
>
> I also found a plugin called WFS 2.0 Client and tried that; it returned the features successfully.
>
>
>
> Unfortunately that seems to be a one off download method rather than adding a live linked layer so it didn’t fix the issue but did prove that the GeoServer can return features.
>
>
>
> I’m still having the same trouble when trying to add the layers to QGIS 3.10 though; it just adds a layer with the image icon but of course it can’t draw the layer and it loads as a bad layer if you save it in the project.
>
>
>
> Does anyone have any suggestions of what might be the issue?
>
>
>
> The server does require authentication.
>
>
>
> Thanks,
> Paul
>
>
>
>
>
> *From:*Ian Turton <ijturton at gmail.com>
> *Sent:* 27 November 2020 09:59
> *To:* Paul Wittle <P.Wittle at dorsetcc.gov.uk>
> *Cc:* qgis-developer at lists.osgeo.org
> *Subject:* Re: [QGIS-Developer] Loading WFS layers from GeoServer
>
>
>
>
>
>
>
> On Fri, 27 Nov 2020 at 09:48, Paul Wittle <paul.wittle at dorsetcouncil.gov.uk <mailto:paul.wittle at dorsetcouncil.gov.uk>> wrote:
>
>     Hi,
>
>
>
>     I’m trying to load some WFS layers from my internal GeoServer into QGIS 3.10 and 3.16. The datastore in GeoServer is based on a view in a SQL Server database but it does have a primary key on the spatial table at least.
>
>
>
>     When I load it in 3.10 it comes in as the image icon (i.e. doesn’t load) so I thought I’d try it in the latest version and in that version QGIS just disappears (completely crashes).
>
>
>
>     Has anyone else had a similar problem and can help me work out how to get the layers to load? I suspect the issue is the way the view is configured in SQL Server however I also wonder if I need to investigate the 3.16 crash and potentially log that as a bug as it is not handling the crash with the normal message the application just closes without warning?
>
>
>
>
>
> Can you check if GeoServer is returning GML or an error message when you make a WFS request? But I don't think that QGis should crash no matter what is in the response.
>
>
>
> Ian
>
>
>
> This e-mail and any files transmitted with it are intended solely for
> the use of the individual or entity to whom they are addressed. It may
> contain unclassified but sensitive or protectively marked material and
> should be handled accordingly. Unless you are the named addressee (or
> authorised to receive it for the addressee) you may not copy or use
> it, or disclose it to anyone else. If you have received this
> transmission in error please notify the sender immediately. All
> traffic may be subject to recording and/or monitoring in accordance
> with relevant legislation. Any views expressed in this message are
> those of the individual sender, except where the sender specifies and
> with authority, states them to be the views of Dorset Council. Dorset
> Council does not accept service of documents by fax or other
> electronic means. Virus checking: Whilst all reasonable steps have
> been taken to ensure that this electronic communication and its
> attachments whether encoded, encrypted or otherwise supplied are free
> from computer viruses, Dorset Council accepts no liability in respect
> of any loss, cost, damage or expense suffered as a result of accessing
> this message or any of its attachments. For information on how Dorset
> Council processes your information, please see
> www.dorsetcouncil.gov.uk/416433
>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>

This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. It may contain unclassified but sensitive or protectively marked material and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All traffic may be subject to recording and/or monitoring in accordance with relevant legislation. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Dorset Council. Dorset Council does not accept service of documents by fax or other electronic means. Virus checking: Whilst all reasonable steps have been taken to ensure that this electronic communication and its attachments whether encoded, encrypted or otherwise supplied are free from computer viruses, Dorset Council accepts no liability in respect of any loss, cost, damage or expense suffered as a result of accessing this message or any of its attachments. For information on how Dorset Council processes your information, please see www.dorsetcouncil.gov.uk/416433