Bug report #22030

Error importing cover from Geoserver WFS service

Added by Mauro preda 6 months ago. Updated 6 months ago.

Status:Feedback
Priority:Normal
Assignee:-
Category:Web Services clients/WFS
Affected QGIS version:3.4.6 Regression?:No
Operating System:Windows 10 64 bit Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29844

Description

In geoservers (http://geoserver.org/) there are levels coming from postgis tables and views created with geoserver sql view.

Access to WFS works perfectly for all complete postgis covers .. but goes wrong if it's a cover created with sql vista

here is the error message:

2019-05-09T11:40:40 CRITICAL Layer te_108_t : Scarico delle geometrie per il vettore sit_area_infrastrutture:te_108_t fallito o parzialmente fallito: Scarico delle geometrie non riuscito: Error transferring http://89.96.217.121:80/geoserver/wfs?SERVICE=WFS&REQUEST=GetFeature&VERSION=2.0.0&TYPENAMES=sit_area_infrastrutture:te_108_t&STARTINDEX=0&COUNT=1000000&SRSNAME=urn:ogc:def:crs:EPSG::32632&BBOX=469878.84158786124316975,5005658.55914706736803055,557148.479013089556247,5062663.48473474942147732,urn:ogc:def:crs:EPSG::32632 - server replied: . Puoi tentare di ricaricare il vettore con F5

Versione di QGIS
3.4.6-Madeira

History

#1 Updated by Giovanni Manghi 6 months ago

  • Status changed from Open to Feedback

The server request fails, so this not seems a QGIS issue:

<ows:ExceptionReport version="2.0.0" xsi:schemaLocation="http://www.opengis.net/ows/1.1 http://89.96.217.121:80/geoserver/schemas/ows/1.1.0/owsAll.xsd"&gt;&lt;ows:Exception exceptionCode="NoApplicableCode"><ows:ExceptionText>java.lang.RuntimeException: java.lang.RuntimeException: java.io.IOException
java.lang.RuntimeException: java.io.IOException
java.io.IOExceptionCannot do natural order without a primary key, please add it or specify a manual sort over existing attributes</ows:ExceptionText></ows:Exception></ows:ExceptionReport>

Also available in: Atom PDF